+11
Let us say I add another value BIO SMIO (rhyme if you will š).
I feel like I just may have been cooking a long way by separating out values for a field too often.
Best answer by lhubbard
Equals is an exact match and will only return the one value.
Contains ābioā will return both ābio smioā and ābio clinical labsā. Contains ābio clinical labsā would not return ābio smioā.
+10think it will look for both with the āequalsā operator...I usually use 1 for each value if that fits in a single set. Using āContainsā might be best but youāll need to test it.
Equals is an exact match and will only return the one value.
Contains ābioā will return both ābio smioā and ābio clinical labsā. Contains ābio clinical labsā would not return ābio smioā.
+11So there is an involved answer to this and it deserves its own write up.
Almost 10 years ago for another system in another forum far far away? I wrote something else up that is similarĀ to understand the outcomes for those that are more literal and less (or not) SQL minded. So it will probably take some staging to show it in an article. But it currently seems like you can use multiple values with equal to and not equal to...for a single condition. No need to put a single value in each condition with those operators. That will then impact a condition set.
+6So there is an involved answer to this and it deserves its own write up.
Almost 10 years ago for another system in another forum far far away? I wrote something else up that is similarĀ to understand the outcomes for those that are more literal and less (or not) SQL minded. So it will probably take some staging to show it in an article. But it currently seems like you can use multiple values with equal to and not equal to...for a single condition. No need to put a single value in each condition with those operators. That will then impact a condition set.
Nice to know!
Enter your email address or username and password below to log in to Docebo Community. No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
