Skip to main content
Skip to main content

listAndCount - Pricing Module Reference

Beta

This documentation provides a reference to the listAndCount method. This belongs to the Pricing Module.

This method is used to retrieve a paginated list of price sets along with the total count of available price sets satisfying the provided filters.

Example

To retrieve a list of prices sets using their IDs:

import {
initialize as initializePricingModule,
} from "@medusajs/pricing"

async function retrievePriceSets (priceSetIds: string[]) {
const pricingService = await initializePricingModule()

const [priceSets, count] = await pricingService.listAndCount(
{
id: priceSetIds
},
)

// do something with the price sets or return them
}

To specify relations that should be retrieved within the price sets:

import {
initialize as initializePricingModule,
} from "@medusajs/pricing"

async function retrievePriceSets (priceSetIds: string[]) {
const pricingService = await initializePricingModule()

const [priceSets, count] = await pricingService.listAndCount(
{
id: priceSetIds
},
{
relations: ["money_amounts"]
}
)

// do something with the price sets or return them
}

By default, only the first 15 records are retrieved. You can control pagination by specifying the skip and take properties of the config parameter:

import {
initialize as initializePricingModule,
} from "@medusajs/pricing"

async function retrievePriceSets (priceSetIds: string[], skip: number, take: number) {
const pricingService = await initializePricingModule()

const [priceSets, count] = await pricingService.listAndCount(
{
id: priceSetIds
},
{
relations: ["money_amounts"],
skip,
take
}
)

// do something with the price sets or return them
}

You can also use the $and or $or properties of the filter parameter to use and/or conditions in your filters. For example:

import {
initialize as initializePricingModule,
} from "@medusajs/pricing"

async function retrievePriceSets (priceSetIds: string[], moneyAmountIds: string[], skip: number, take: number) {
const pricingService = await initializePricingModule()

const [priceSets, count] = await pricingService.listAndCount(
{
$and: [
{
id: priceSetIds
},
{
money_amounts: {
id: moneyAmountIds
}
}
]
},
{
relations: ["money_amounts"],
skip,
take
}
)

// do something with the price sets or return them
}

Parameters

The filters to apply on the retrieved price lists.
The configurations determining how the price sets are retrieved. Its properties, such as select or relations, accept the attributes or relations associated with a price set.
sharedContextContext
A context used to share resources, such as transaction manager, between the application and the module.

Returns

PromisePromise<[PriceSetDTO[], number]>Required
The list of price sets along with their total count.
Was this section helpful?