How to filter dataset

Hi sauravk
Use below code snippet to get last three rows

index(reverse({1,2,3,4,5,6}),{1,2,3},null())

regards,
Sachin

You can also try

todatasubset(
  local!DataSubset.data,
  topaginginfo(
     local!DataSubset.totalCount - 3,
     local!DataSubset.totalCount
   )
)

Code:

load(
local!mydatasubSet:a!dataSubset(
startIndex: 1,
batchSize: 4,
sort: a!sortInfo(
field: "name",
ascending: true()
),
totalCount: 10,
data: {"a", "b", "c", "d", "e", "f", "g", "h", "i", "j"},
identifiers: {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
),
todatasubset(
arrayToPage:local!mydatasubSet.data,
pagingConfiguration:topaginginfo(
local!mydatasubSet.totalCount - 2,
local!mydatasubSet.totalCount
)
)
)

 

Output:

startIndex: 8 batchSize: 10 sort: List of SortInfo: 0 items totalCount: 10 data: List of Text String: 3 items "h" "i" "j" identifiers: List of Number (Integer): 3 items 8 9 10

Hi sauravk just out of interest, if you are the one who is querying the data (using your queryentity or queryrule) and expecting only last 3 rows always, then simply you can make the use of paging info where you need to provide the sort attribute values, where field will be your primary key and ascending must set to false

Example

a!pagingInfo(
1, 3, a!sort("id", false())
)

I believe this must be your approach instead of querying Multiple set of rows (which are not needed / you don't these data) and later applying filter over this data. Unless you are receiving this data from some other sources and you are not the one who is querying the data.

Using this approach, it will query only the required set of rows(last 3 rows) which you are needed.

However this also depends upon, from where are you receiving the data (using your own rule / any external sources)

Thanks for that. Is this solution will work inside with also as my requirement is bit dynamic here , on basis of user input I want to do this filtration n user will select this option from dropdown only.

Yes obviously you Can, upon saveInto of dropdown you can refresh your data using a!save(local!yourVariable, rule!queryTheDb)