Skip to main content
U
udhayakumarm000856
January 19, 2022
Question

functions expression rules

  • January 19, 2022
  • 11 replies
  • 0 views

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 

    11 replies

    harshitb6843
    harshitb6843
    January 19, 2022

    Hi there,

    I do not understand this part. 

    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.html

    If 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

      U
      udhayakumarm000856Author
      January 19, 2022

      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}

      harshitb6843
      harshitb6843
      January 19, 2022

      Hi there,

      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.

        stefanhelzle0001
        stefanhelzle0001
        Brainy
        January 19, 2022

        My quick solution is to fetch all the IDs from DB, then randomly remove items until only 5 are left.

        a!localVariables(
  local!dbIds: {3,7,42,6,9,13,123,45,889,657},
  reduce(
    rule!TST_RemoveRandomItemFromList(_,_),
    local!dbIds,
    enumerate(5)
  )
)

TST_RemoveRandomItemFromList(
  list(Integer Array),
  dummy(Integer)
  
  remove(
    ri!list,
    ceiling(rand() * count(ri!list))
  )

        stewart.burchell
        stewart.burchell
        January 19, 2022

        An alternative would be to fetch all of the questions form the DB (agnostic of their database ids), and then generate a random list of 5 integers in the range of the size of the fetched array (ensuring no duplicate random integers are generated) and then use those to index your fetched array.

          stefanhelzle0001
          stefanhelzle0001
          Brainy
          January 19, 2022

          This may create the same value multiple times. That was my first idea as well and I had no good idea to remove duplicates. I know that union does that, but then I would have to create more than 5 random numbers. But how much? With enough bad luck, all numbers are the same ...

          Terms & ConditionsAccessibility statement