Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
+1
person also asked this
people also asked this
Replies
12 replies
Answers
2 answers
Subscribers
12 subscribers
Views
7658 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Data and Records
Default Filter
mayureshs
over 7 years ago
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
0
rodgraham
Certified Lead Developer
over 7 years ago
One thing you may wish to consider if you're using an Oracle dB if you pass more than 1000 employee ids to your in clause I think you'll get an Oracle error returned
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
@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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<