how to provide a search for datasubset or Array of rows?

Hi Ramp,

In below example in local!data which is and data subset  value and one more local variable local!filterDepartment with filter value .

so based on local!filterDepartment we can  filter  data subset .

load(
local!data: todatasubset(
{
{
id: 1,
name: "ABC",
department: "IT"
},
{
id: 2,
name: "XYZ",
department: "Admin"
},
{
id: 3,
name: "MNO",
department: "Finance"
}
}
),
local!filterDepartment: "Finance",
local!data.data[wherecontains(
tostring(
local!filterDepartment
), touniformstring(
index(
local!data.data, "department", null
)
)
)]
)

Thanks for the reply. this is working fine if we provide the exact department value. what about if need to provide the includes/like kind of filter/search.

Thanks in advance.

just make  local!filterDepartment as array and in where contains make that local variable as as touniformstring()

load(
  local!data: todatasubset(
    {
      {
        id: 1,
        name: "ABC",
        department: "IT"
      },
      {
        id: 2,
        name: "XYZ",
        department: "Admin"
      },
      {
        id: 3,
        name: "MNO",
        department: "Finance"
      }
    }
  ),
  local!filterDepartment: {
    "IT",
    "Admin"
  },
  local!data.data[wherecontains(
    touniformstring(
      local!filterDepartment
    ), touniformstring(
      index(
        local!data.data, "department", null
      )
    )
  )]
)

here i should provide the exact names as department contains. what i need is for example 

a!queryFilter(

fileld:"department",

operator:"includes",

value:local!filterDepartment

)

not the exact string search. Thanks for the immediate reply.

check attached code ,so based on local!filterDepartment string it will return includes functionality

load(
  local!data: todatasubset(
    {
      {
        id: 1,
        name: "ABC",
        department: "Information Technology"
      },
      {
        id: 2,
        name: "XYZ",
        department: "Admin Team"
      },
      {
        id: 3,
        name: "MNO",
        department: "Finance Team"
      }
    }
  ),
  local!filterDepartment: "Team",
  a!forEach(
    items: local!data.data,
    expression: if(
      search(
        local!filterDepartment,
        fv!item.department
      ) = 0,
      {},
      fv!item
    )
  )
)

Thanks a lot. is it fine to iterate all the records to provide the search right.

Yes

Yes