Friday, August 17, 2012 10:50 AM
Hi expert, I want to retrieve some record from StringMapBase table in CRM DB. But this entity is not present in reference.cs class. What is the related object for this. Please Suggest.
Friday, August 17, 2012 11:00 AM
What is "reference.cs" ? Is it your proxy for the CRM WebServices ?
Anyway, if the StringMapBase is not accessible from the proxy, you can directly connect to the SQL database, and execute a SELECT query on the table (only SELECT, don't execute other type of queries otherwise you would lose support from Microsoft...).
If you want to query without taking into account the permissions, then simply use the table, or the view with the same name. If you need to query taking into account the user's permissions, then use the Filtered views.
Microsoft .NET / Dynamics / MSSQL + BI
Saturday, August 18, 2012 11:49 PMModerator
I believe that you want to get labels for optionsets from those table.
To get the list of values and labels you can retrieve this information using metadata call using RetrieveAttributeRequest and cast the result to PicklistAttributeMetadata which will contain the list of labels you want to use.
- Proposed As Answer by Andrii ButenkoMVP, Moderator Saturday, August 18, 2012 11:49 PM
Monday, August 20, 2012 8:31 AMModerator
you can also refer http://mahenderpal.wordpress.com/2012/06/10/show-ms-crm-2011-optionest-values-in-dropdownlist-in-asp-net/
- Proposed As Answer by Mahender PalMVP, Moderator Monday, August 20, 2012 8:31 AM
Tuesday, August 21, 2012 2:39 PM
Hi Andrii, You are right i want to use the label and also its corresponding value. So that i can use it program.I am using SL on HTML. Will it work and also i am working with asynchronous query.
I ll try. If you give any example then it ll help me better.
Thank you for your time.
Wednesday, August 22, 2012 4:26 AM
Hi Andrii, i tried your suggestion but it didn't work coz it require Xrm.SDK. and I cant' use it in SL app. If there any alternative solution for it. Then pls suggest.
Wednesday, August 22, 2012 5:11 AMModerator
By 'SL', do you mean Silverlight ?
If so, you can use the messages suggested by Andrii by using a service reference to the Organization.svc web service
- Edited by DavidJennawayMVP, Moderator Wednesday, August 22, 2012 5:11 AM