#Guys help me, its very urgent situation. i am doing data migration from po

vikrams290 over 8 years ago

#Guys help me, its very urgent situation.
i am doing data migration from portal to tempo. in portal data and tempo data, there is some diffrence so thats why i am not able to one user filter(facets ), that can filter these all data .

------------------------------------------------------------------------------------------------------------------------------------------------------------
Ex:-
Older data :- Physics (stored into datacase)
New data :- PHYSICS

I want to put single filter like
Student
|- Physics - that can filter both data togather.
|- Chemistry

once i click Physics, it will filter those record who having "PHYSICS" and "Physics" value.

Discussion posts and replies are publicly visible

Parents

0 ramakg
A Score Level 1
over 8 years ago

Vikram, you can build a query rule like this and the sample code as follows:
a!queryFilter(
field: "tRequestStatus",
operator: if(local!requeststatus="Open","not in",if(or(local!requeststatus="Completed",local!requeststatus="Cancelled"),"in","=")),
value: if(local!requeststatus="Open",{"Cancel","Cancelled","Complete","Completed","Terminate"},
if(local!requeststatus="Completed",{"Complete","Completed"},
if(local!requeststatus="Cancelled",{"Cancelled","Cancel"},
local!requeststatus)))
)),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ramakg
A Score Level 1
over 8 years ago

Vikram, you can build a query rule like this and the sample code as follows:
a!queryFilter(
field: "tRequestStatus",
operator: if(local!requeststatus="Open","not in",if(or(local!requeststatus="Completed",local!requeststatus="Cancelled"),"in","=")),
value: if(local!requeststatus="Open",{"Cancel","Cancelled","Complete","Completed","Terminate"},
if(local!requeststatus="Completed",{"Complete","Completed"},
if(local!requeststatus="Cancelled",{"Cancelled","Cancel"},
local!requeststatus)))
)),
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data