Breadcrumbs

Comparison of Data Retrieval API vs SQL

SQL

Pricefx Groovy API
SQL
SELECT *
  FROM "PX3"
  WHERE name = "MyTable"
    AND filters
  ORDER BY ValidFrom DESC
  OFFSET 0
  LIMIT MaxFindResultLimit
Groovy
api.find(
  "PX3",
  0,
  api.getMaxFindResultsLimit(),
  "-ValidFrom",   // ORDER BY ValidFrom DESC
  Filter.equal("name", "MyTable"),
  *filters)
SQL
SELECT *
  FROM "PX"
  WHERE filters
  ORDER BY ValidFrom DESC
  OFFSET 0
  LIMIT 1
Groovy
api.find(
  "PX",
  0,
  1,
  "-ValidFrom",
  *filters)
SQL
SELECT value
  FROM LTV
  WHERE table.name = "MyTable"
  AND name = "key1Value"
Groovy
api.vLookup(
  "MyTable",  //of Simple type
  "key1Value"
)
SQL
SELECT FieldX
  FROM MLTV2
  WHERE
    table.name = "MyTable"
    AND key1 = "key1Value"
    AND key2 = "key2Value"
Groovy
api.vLookup(
    "MyTable",  //of Matrix2 type
    "FieldX",
    "key1Value",
    "key2Value"
)