Skip to main content
Nintex Community Menu Bar
Solved

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

  • December 9, 2019
  • 2 replies
  • 25 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

 

Best answer by Mike_K2

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

2 replies

Forum|alt.badge.img+10
  • Answer
  • December 9, 2019
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

  • Author
  • December 10, 2019

Mike,

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

 

Regards,

Praveen