Extract date using index

Hi, instead of using wherecontains it sounds like you want to build something to the effect of "whereGreaterThan". You could do so inline by using a!forEach. Iterate over the list local!allResults.date, and for each item compare the value to ri!date. If the value is greater, return the index, otherwise, return {}. That way, you'll be passing an array of the indices you're after to fn!index, and it will return the subset array that you're looking for, because index's second (named index) parameter accepts arrays (index (Number (Integer)): The index or array of indices of the array.).

If you're on an earlier version of Appian and a!forEach isn't available, you can accomplish the same thing by creating a new rule and using apply().

Thanks,
Dan

Hi,

Please use index(masterArray, where(apply(rule!isDateGreater(data:_)),{masterArray}),{}).

rule!isDateGreater
-----------------------------
add your date condition, result should be boolean.

Hope it will help you..!!!

Per daniell's suggestion, but perhaps even easier, I would use a!forEach like this:

 

a!forEach(
  local!allResults,
  if(
    fv!item.date > today(),
    fv!item,
    {}
  )
)

This would allow you to return an array of the matching results directly, without having to go through the runaround of calculating a list of indexes to then use for the index() function on the array.