How to run a dynamically generated query(text format) in advance sql block?

Nithin,

can you share your dynamic query, am getting error : "'[OSUSR_' found in 'Expand Inline' parameter is a reserved prefix" .

Thanks in Advance.

Hi Deepak,

You should use the OutSystems entity and attribute names in your SQL, rather than the physical table names as some of the system entities are reserved.

Syntax is explained in Write Your Own SQL Queries.

Cheers,

Tiago.

Thanks a lot Tiago...

But am generating the Sql query dynamically and then am executing on SQL. 

How to write the Dynamic Sql qurey on outsystems?

The same as you would write it inside a SQL Node. An Expand Inline parameter is just  a placeholder for string that will be filled in runtime, so the query you write must follow the same convention - {Entity}.[Attribute].