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.
--gauravs0002
Discussion posts and replies are publicly visible