I have created an SQL query for my table and there are columns that were fetched by a structure. I am not able to sort them by adding "{StructureName}.[StructureAttribute]" to the column attribute of List_SortColumn as it returns error of The multi-part identifier "{StructureName}.[StructureAttribute]" could not be bound.
I already set my Sort input parameter Expand Inline to Yes but it still doesn't work for columns from the structure.
Any suggestion?
Yes @Gabriel David
we can do Order by calculated column.
Just pass the Alias column name
or follow this link
https://stackoverflow.com/questions/8591526/t-sql-sorting-by-a-calculated-column
https://www.mssqltips.com/sqlservertip/7068/sql-order-by-clause-code-examples/
Hope this will help you.
Hi @Gabriel David ,
I saw in your sql query their is no entity name like {DashboardAssesmentColumns}.[NotificationDate] which you passed from sortcolumn.
Order by is working with table or entity columns which used in select statement.
Hi @Rahul Sahu,
Is there a way to sort those calculated columns?
This worked for me @Rahul Sahu
Thank you for your help.
Glad to help you.