How can I set up a criteria to search for multiple different internal IDs?

AI generated answer (using internal Slack threads):

To set up a criteria to search for multiple different internal IDs, you can use a CASE statement in your search criteria. Here's how you can do it: 1. Prepare a list of your internal IDs in a format suitable for a NetSuite CASE statement. For example, if your internal IDs are 1234, 5678, and 8909, you would format them as '1234','5678','8909'. You can use Excel or any other tool to concatenate your IDs into this format. 2. In your saved search criteria, add a formula (text) field. 3. In the formula field, enter a CASE statement like this:

CASE WHEN {internalid} IN ('1234','5678','8909') THEN 1 ELSE 0 END

4. Set the formula field to be equal to 1. This will return all records with an internal ID in your list. Please note that this method might not work if you have hundreds of IDs, as the formula editor might have a limit on the number of characters it can handle. An alternative method is to add a custom checkbox field to your records, do a CSV import to check it for the records with the internal IDs you're interested in, and then use that checkbox as your search criteria. This method might be more scalable and easier to manage if you have a large number of IDs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******