A text file containing 587 material numbers was attached to a query selection screen on the "Exclude single values" tab. The query executed successfully, however, 150+ materials from the exclude file appeared in the results. Investigation into why this happens found:
1. When only 500 materials were imported to the "Exclude single values" tab none of the excluded materials appeared in the results.
2. When more than 500 materials were imported to the "Exclude single values" tab 150+ random materials from the exclude list appeared in the results.
Is there a way to ensure that when more than 500 values appear on the "Exclude single values" tab that none of them appear in the results?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.