How to create Advance Query

  

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:

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,

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).


Regards,

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):