Need sorting without Paginginfo

Question

Hi , 
 
 I have list of year in drop down which i want to sort without using paging info function ? 
 
 Can we do that ?

mayurm168 · Answer

Here is my suggested answer based on your restriction not to make change in source of data, or any other objects. ========================================= create a rule named getYearObject 
 code.... {year:ri!year} 
 input... year (number integer) ========================================= create a parent rule named getYearObjectArray 
 code... a!foreach( items:ri!years, expression:rule!getYearObject(fv!item) ) 
 input... years (number integer) multiple ========================================= In your master rule write below code. For understanding I am writing code step by step. 
 local!yearDummyData:{2011,2012,2002,2014}, local!pagingInfo:a!pagingInfo(startIndex:1, batchSize:-1 sort: a!sortInfo(field: "year",ascending: true())) local!yearObjects:rule!getYearObjectArray(years:local!yearDummyData), local!sortedYears:todatasubset(local!yearObjects,local!pagingInfo), local!answer :index(local!sortedYears.data,"year",{}) 
 Hope this works as standalone code. 
 Regards, Mayur Mondhe

Colton Beck · Answer

You can use the hidden sort() function. If you pass it your array of years, it should return them in chronological order. 
 
Keep in mind that there are issues with using hidden functions, specifically the possibility that they could be deprecated unexpectedly in future releases. It is unlikely that this would happen though.

aloks0189 · Answer

Hi sauravk as per my understanding few points as mentioned below: 
 
1. Usage of datasubset is the best option to achieve your requirement. In fact while working on some other module if your dependent code is written by your colleague and not meeting the standars then you can probably flag this out and modify this instead of compromising/ignoring this. As you are aware these features are OOTB in Appian hence suggesting other work around is not a great option. However you can achieve this in several ways. 
 
2. Alternate way: you can write a stored procedure and query the data in ascending/descending order then concat the resultant values into a single variable of type varchar2/varchar2/text. Return this variable as an OUT parameter and capture the same in Appian, split this text into list of text string and use this inside the dropdown. Similarly if you want to carry the primary key id, you need to follow the same step and instead of one OUT parameter, you need to return 2 OUT parameters. 
 
But once again, this approach is not recommended.

Need sorting without Paginginfo

Top Replies