How Advance query can be written. How it differes from SQL
It will be useful if some one attaches a OML file with a small query
Regards,
Sandeep
Hi Shanmuk,
You can follow this video tutorial:
https://www.youtube.com/watch?v=YwUsOHch6i8
Kind regards,
Remco Dekkinga
shanmuk sandeep wrote:
Check if there is some documentation that can helps you. I've these doc pages: Write Your Own SQL Queries and SQL Canvas (it's for 9.1 but works the same for P10).
António Pereira
Advance Query pretty much just passing your SQL to your database engine, with some modification:
- you can use entity name instead of physical table name eg. {Customer}
- you can use entity's attribute name instead of logical table name eg. [Fullname] or {Customer}.[Fullname]
You can also call stored procedure or function in advance sql with your own database syntax.
For stored procedure if you are using external database, you can refer to an entity to derive the database connection with this syntax (Oracle DB):