Solved

How to sort output from List method on a SQL Service SmartObject?

  • 9 December 2019
  • 2 replies
  • 4 views

Hi all,

 

I want to populate radio button list with data from List method on a SQL Service Instance SmartObject. Is there way to sort the output from this List method based on a different column which has display order in the table?

 

DocType Table

----------------------

DocTypeCode - primary key

DocTypeName - Display Value

DisplayOrder - integer

 

Can this be accomplised in anyways?

 

Thanks,

Praveen

 

icon

Best answer by Mike_K2 9 December 2019, 21:03

View original

2 replies

Badge +10
Hi Praveen,

If you look into the rules of the form and find the call to the list method, you should see a "Sort" tab when configuring the rule. This will allow you to specify the column and direction of the sort.

Regards,

Mike

Mike,

That worked. Thanks for helping out a newbie. I looked everywhere except there :-) 

 

Regards,

Praveen

 

Reply