for example, I am having 10 questions in my DB for that each question has a unique question id
If I enter 5 then 5 question id should be come randomly help me out on this
Discussion posts and replies are publicly visible
Hi there,
I do not understand this part.
Unknown said:should be come randomly
But what I think is that, when you search for 5, you should get a question with id as 5. For that, you use queryFilter() in query(). Documentation - https://docs.appian.com/suite/help/21.4/fnc_system_a_queryfilter.htmlIf you want to combine it with any other filter, then try using logical expressions in query() function where you can pass multiple filters that can be applied all at the same time, or any of them.
I hope it helps.
Thanks,Harshit
it should come randomly means if there are 10 questions I want only 5 questions that is like not comes in ordering it should be like {10,1,5,3,8}
This can be another approach. You generate a list of incremental random values, all unique. And then use that array to index from the list of available questions.
Below is the code for the same.
a!localVariables( local!questionsData, local!array: 1 + tointeger(rand(5) * (1000 - 1)), local!sortedArray: rule!BAM_utils_sortArray( arrayValues_any: local!array, ascending_bool: true ), local!randomIndex: a!flatten( a!forEach( items: local!sortedArray, expression: wherecontains(fv!item, local!array) ) ), index( local!questionsData, local!randomIndex, {} ) )
In local!array, I am trying to generate the values in a specific range. The parameter of rand() function will give us 5 values. You can change it to n.