get oracle error ORA-01795 when has more than 1000 org

Description

oracle limit 1000 item on IN clause so you get bellow error when system has more than 1000 org

ORA-01795: maximum number of expressions in a list is 1000 error

it happen by MRole.getOrgWhere build query Org_ID IN (list of org)

work-around
build up condition by (0, Org_ID) IN ((0, org1), (0, org2),....)

Environment

None

Assignee

Hiep Lq

Reporter

Hiep Lq

Labels

Tested By

None

Fix versions

Priority

Major
Configure