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 i am completely agree with @rodgraham, as there is an Active thread on Oracle community about the same concern, please follow this Link:- https://community.oracle.com/thread/235143

    But if we talk about MySQL then i think there is no such limit, however we can set in list limit using max_allowed_packet
    Please follow the below Link for MySQL:-
    http://stackoverflow.com/questions/1532366/mysql-number-of-items-within-in-clause

    http://tinyurl.com/h8jd94l
Reply
  • 0
    Certified Lead Developer
    @mayureshs i am completely agree with @rodgraham, as there is an Active thread on Oracle community about the same concern, please follow this Link:- https://community.oracle.com/thread/235143

    But if we talk about MySQL then i think there is no such limit, however we can set in list limit using max_allowed_packet
    Please follow the below Link for MySQL:-
    http://stackoverflow.com/questions/1532366/mysql-number-of-items-within-in-clause

    http://tinyurl.com/h8jd94l
Children
No Data