Skip to main content

getCollectionsBaseQuery

Get a base SelectQuery for querying collections.

Import​

import { getCollectionsBaseQuery } from "@evershop/evershop/catalog/services";

Syntax​

getCollectionsBaseQuery(): SelectQuery

Parameters​

None.

Return Value​

Returns a SelectQuery object with base table collection.

Examples​

Basic Usage​

import { getCollectionsBaseQuery } from "@evershop/evershop/catalog/services";
import { pool } from "@evershop/evershop/lib/postgres";

const query = getCollectionsBaseQuery();

// Load all collections
const collections = await query.execute(pool);

Get Single Collection​

import { getCollectionsBaseQuery } from "@evershop/evershop/catalog/services";
import { pool } from "@evershop/evershop/lib/postgres";

const query = getCollectionsBaseQuery();

// Load collection by code
const collection = await query
  .where('code', '=', 'summer-sale')
  .load(pool);

console.log(collection.name);
console.log(collection.description);

See Also​