Querying from local data

Hi All,

I have queried the data from table and have stored in some local variable.

User have option to select three values: LOB2,LOB3,LOB4. Now based on these selected values i have to query the id

please help me to make changes in the below code to achieve the same.

a!localVariables(
local!data:{
{id:1,lob2:"Commercial Banking", lob3:null ,lob4:null},
{id:2,lob2:"Commercial Banking", lob3:"Commercial Banking" ,lob4:null},
{id:3,lob2:"Commercial Banking", lob3:"Commercial Banking" ,lob4:"CMB"},
{id:4,lob2:"Commercial Banking", lob3:"Commercial Banking" ,lob4:"GPB"},
{id:5,lob2:"Commercial Banking", lob3:"Commercial Banking" ,lob4:"RBWM"},
{id:6,lob2:"Commercial Banking", lob3:"Commercial Banking" ,lob4:"HOST"}
},


local!selectedLOB2:"Commercial Banking",
local!selectedLOB3:"Commercial Banking",
local!selectedLOB4:"GPB",

local!id:index(
local!data.id,
{
wherecontains(local!selectedLOB2, touniformstring(index(local!data,"lob2",null))),
wherecontains(local!selectedLOB3, touniformstring(index(local!data,"lob3",null))),
wherecontains(local!selectedLOB4, touniformstring(index(local!data,"lob4",null)))
}
),
local!id

).

I need suggestion on the highlighted text so that the output should come 4.

--

  Discussion posts and replies are publicly visible