Need to filter the manually retrieved datasubset

Based on your response of attempting to find the latest entry, if you could create a view that does this for you.  Assuming a table (TBL_A) has columns (ID [PK], APP_ID,....) and you want to just get the rows for the latest entry for each APP_ID (latest being the greatest ID associated) then you could do a simple join like this:

Select A.* from TBL_A A INNER JOIN (SELECT APP_ID, MAX(ID) LATEST_ID from TABLE_A group by APP_ID) X on A.APP_ID = X.APP_ID

alternately, to do this in sail and the format you are using, you could do something like the following:

todatasubset(
    reject(
    isnull(),
      a!forEach(
        items: union(
          rule!ISS8_getAllRequests().applicationName,
          rule!ISS8_getAllRequests().applicationName
        ),
        expression: {
        if(<condition>, null,
          rule!ISS8_getRequestNumbersByAppName(
            fv!item
          )[1]
          )
        }
      )
      )
    )

note that, depending on the returned structure, you may need to use flatten() to remove a dimension from the array. 

Hi,

I've used this SQL Query function and created view. Now I'm able to filter. Thanks for your response!

Hi,

I've used this SQL Query function and created view. Now I'm able to filter. Thanks for your response!