Can you sort a popup form on 2 columns?

jarod_m

This is technically for Factory Track not Syteline but I think this is more of a Mongoose developer question: Is it possible to sort a popup form on 2 columns?

For example, we're calling the WMSLInventoryLocPopup.mobi on one of the forms to choose an item location:

Run Form as Modal Child :  WMSLInventoryLocPopup.mobi( DISTINCT() OKCANCELOPTIONAL() SETVARVALUES(FormFilter=Whse='C(Whseedit)' and Item='C(Itemedit)' and LocType = 'S'  V(VLocQtyAvalFilter), FormOrderBy = Rank, Whse=C(Whseedit), Item=C(Itemedit), ItemDesc=C(Itemdesc), ParentComponentToUpdate=Locedit, DisplayMobileToolbar=V(DisplayMobileToolbar)) )

This is sorted by rank on the FormOrderBy parameter. We want to change the sort to sort by a DerLotExpiryDate (a customer property) and then by Rank. However, the parameter only seems to work when I pass it one value. Is there a way to make it sort by multiple columns?

Carsten Steinhoefel

You could store the list of OrderBy columns in a Variable and pass that instead of the literal values. That way there is no extra comma in the SETVARVALUES() parameter list.