Comparison of Data Retrieval API vs SQL

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`

Configuration Engineer Knowledge Base