Comparison of Data Retrieval API vs SQL
- Pavel Matyasko (Deactivated)
- Pricefx Learning Hub
Owned by Pavel Matyasko (Deactivated)
SQL | Pricefx Groovy API |
|---|---|
SELECT *
FROM "PX3"
WHERE name = "MyTable"
AND filters
ORDER BY ValidFrom DESC
OFFSET 0
LIMIT MaxFindResultLimit | api.find(
"PX3",
0,
api.getMaxFindResultsLimit(),
"-ValidFrom", // ORDER BY ValidFrom DESC
Filter.equal("name", "MyTable"),
*filters) |
SELECT *
FROM "PX"
WHERE filters
ORDER BY ValidFrom DESC
OFFSET 0
LIMIT 1 | |
Found an issue in documentation? Write to us.
Â