Hi everyone,
I'm getting an error while querying data. Scenario here is logged in user will have multiple countries associated. so when user logs in we are fetching loggedin user counties and passing the list of country id's to the view to get data. when user having upto 70 countries it is working fine but when exceeds it is throwing error. Can anyone please help me how to resolve the issue.
PFA image
Discussion posts and replies are publicly visible
I suggested to create that query/view/stored procedure in a way that it takes the user and manages that huge number of countries internally.