Polecenia (konsola):
Produkty
P4.querydata({datasetId: "products"})
P4.querydata({datasetId: "productsInfo"})
P4.data.products.q({"skus.sku.color": ["=","white"]})
P4.data.productsInfo.q({productId: ["=",34117,34329]})
P4.data.productsInfo.q({productId: ["=",34117,34329],"skus.sku.color": ["=","blue"]})
P4.data.products.q({"attributes.attributeGroup.attribute": ["and",{nameEn: 'Wielkość wyświetlacza [cale]', value: ["and", [">",6], ["<=", 7]]}]}).merge("productId")
Dokumenty
P4.querydata({datasetId: "documents"})
P4.querydata({datasetId: "offerDocuments"})
P4.data.documents
P4.data.offerDocuments
P4.data.documents.q({documentId: P4.data.offerDocuments.q({offerId: 1079600601}).all.documentId})
with(P4.data) {documents.q({documentId: offerDocuments.q({offerId: 1079600601}).all.documentId})}
Oferty
P4.querydata({datasetId: "offers"})
P4.querydata({datasetId: "tariffs"})
P4.querydata({datasetId: "promotions"})
P4.data.offers.q({dateFrom: ["or", ["<", "2016-03-18"], null], dateTo: ["or", [">", "2016-03-18"], null]})
P4.data.tariffs.q({tariffId: P4.data.offers.q({dateFrom: ["or", ["<", "2016-03-18"], null], dateTo: ["or", [">", "2016-03-18"], null]}).all.tariffId})
P4.data.promotions.q({promotionId: P4.data.offers.q({dateFrom: ["or", ["<", "2016-03-18"], null], dateTo: ["or", [">", "2016-03-18"], null]}).all.promotionId})
P4.data.offers.q({dateFrom: ["or", ["<", "2016-03-18"], null], dateTo: ["or", [">", "2016-03-18"], null]}).all.priceListId.unique()
PriceList
P4.querydata({datasetId: "priceLists"})
P4.data.priceLists.q({dateFrom: ["or", ["<", "2016-03-18"], null], dateTo: ["or", [">", "2016-03-18"], null]})
P4.data.products.q({productId: P4.data.priceLists.q({dateFrom: ["or", ["<", "2016-03-18"], null], dateTo: ["or", [">", "2016-03-18"], null]}).merge("productPrice.productId").unique()})
Usługi
P4.querydata({datasetId: "services"})
P4.data.services.q({cfsId: P4.data.offers.q({offerId:1081400602, sellChannel: "ESHOP"}).merge("services.serviceSection.service.cfsId")})
P4.data.services.q({"configuration.configurationForTariff.tariffId":30001})