Is there a maximum number of values you can enter when using the is in condition? The only info provided in the help sections is:
Used to retrieve records where the field selected contains a value that is included in a list of values. If the condition is followed by the phrase comma delimited list in parentheses, you cannot select the values but must enter them in list form separated by commas and without spaces.
Example: To retrieve three students using their IDs, select Demographic as the area, Student ID as the field, and is in (comma delimited list) as the condition, then enter the IDs as follows: 11111111,22222222,33333333.
Thank you for connecting with PowerSchool Community!
To provide further information, would you please let us know where were you trying to enter the values in the search field? Was it in the Start Page, Direct Database Export, or in the Data Export Manager?