Notifications
Announcements
No record found.
Hello everyone,
I've created just a dummy multi-select option set named List in one of the entities. Below are the values:
in Dynamics 365 On-Premise version. When I run a select query in SQL (select new_list from product) to check the values saved.
Can anyone help me to understand the multi-select option-set value. What is the -1 here in the output?
SELECT account.name,
account.markmpn_multiselecttest
FROM account
INNER JOIN
MultiSelectAttributeOptionValuesBase AS msj
ON account.AccountId = msj.ObjectId
AND msj.ObjectIdTypeCode = 1
AND msj.ObjectColumnNumber = 1234
WHERE CONTAINS(msj.SelectedOptionValues, '1 OR 2')
Hi,
Can you please show me what values you have selected on the record from UI?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 137 Super User 2025 Season 2
#ManoVerse 57
Jimmy Passeti 50 Most Valuable Professional