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. 

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!