Comparison of Data Retrieval API vs SQL

Owned by Pavel Matyasko (Deactivated)
Last updated: Oct 27, 2023 by Pricefx Learning Hub
1 min read

SQL

Pricefx Groovy API

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.