Default Filter

Hi all,
I have an employee entity which contains employee details except status of employee(Active or Inactive).I have different entity called employee status which contains status of employee with employee IDs. The issue is how to configure default filter for active employees, Can anybody suggest me best way for it?
Actually i have tried one scenario like: I have written QueryEntity which will gives all active employeeIDs from employee status entity, and i have used employee ID as field in default filter and used operator "IN" and In value section i called above queryEntity expression rule,but i am getting following error:

The Requested Record Type Is Not Available

Cannot apply operator [IN] to field [org_emp_id] when comparing to value [TypedValue[it=197,v={TypedValue[it=3,v=INC-16004],TypedValue[it=3,v=INC-16005],TypedValue[it=3,v=INC-16006],TypedValue[it=3,v=INC-16007]}]]. (APNX-1-4203-015)

...

OriginalPostID-244537

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    @ Mayureshs can you get me through your table structure bit clearly. As far I understand you are storing a nested CDT of type employee status in the employee CDT. If so you can directly use the field name using dot operator and can compare with the relavent value. If both the CDT s are independent then I would recommend you to construct a view to retrieve your desired values and can compare accordingly.
Reply
  • 0
    Certified Lead Developer
    @ Mayureshs can you get me through your table structure bit clearly. As far I understand you are storing a nested CDT of type employee status in the employee CDT. If so you can directly use the field name using dot operator and can compare with the relavent value. If both the CDT s are independent then I would recommend you to construct a view to retrieve your desired values and can compare accordingly.
Children
No Data