Dear all ,
im showing a records for all data appear in my db but i have a coloumn for the empId and i want to apply a filter that will show only non-dublicated rows depend on the id.
could you please suggest for a solution.
i used the loged user to filter User records.
But now i need to show only non-repaeated records.
Discussion posts and replies are publicly visible
is empid is primary key of that entity table or view, if it is not a primary key than you can create an query entity rule that will return primary key of record on non duplicated empids. and used these on default filter field:id operator 'in' and rule which return ids
you have to create a rule and call it in apply
apply(rule!SubRule(data:ri!data,empId:_),{union(ri!data.empId,ri!data.empId)})
I have attached the code of rule!SubRule
this will return ids use these in default filter
if it is a primary key than you have to create expression back record