🧩 Regarding the puzzle I've posted a few days ago here:
https://www.linkedin.com/posts/fernandofernandez1_here-is-a-puzzle-that-i-dont-know-whether-activity-7253476761252872197-ZAti
🤔 Here is the Stack Exchange article that gave us the hint to the root cause: Translation Workbench!
https://lnkd.in/gwGd_5VZ
Basically:
💡 querying a picklist using LIKE will return or not return records depending on the user language: WHERE Rating LIKE 'Cold' will not work if the user language is German, you will have to use WHERE Rating LIKE 'Kalt'
📖 the documentation was updated to explain that the LIKE operator can only query on the label of the picklist, not on its API name
⚙️ if you have a scenario that you need to use LIKE to match on an API name, you will have to use a formula (or a text field updated via flow) that exposes the API name
🙏🏼 Thanks to Oleh Berehovskyi , Renato Oliveira, and Charles T for the explanation and Alexander Noble for finding that Stack Exchange article! 🙏🏼