Hi There


I am pulling data using sql query and placing into Table records.

List_sortcolumn is not working, can any one help me with your suggestion?


Thanks in advance

Hi Phani,

Here is a step by step document for those cases. Did you follow everything and still not working?

Regards,

Marcelo

it is not working. I already tried.

I am using a sub query in my sql and output is structure.

Hi,

can you share the module for us to check or at least some print screens.

Regards,

Marcelo



Text for above pic: 

1. TableRecordID.ID

2. Table Name used in the query


Hi

PFA.

I am getting below error while loading/preparing itself

"The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified."


hi,

On service studio if you test your advance query you can see the SQL that is being generated and run on the sql server. Without looking into your SQL I can't tell you why you are getting that error and the error is self explanatory.

Regards,

Marcelo