Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Retrieve record from StringMapBase table of CRM DB

建议的答复 Retrieve record from StringMapBase table of CRM DB

  • Friday, August 17, 2012 10:50 AM
     
     
    Sign In to Vote
    0

    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.

    thank you.

    saroj

     

All Replies

  • Friday, August 17, 2012 11:00 AM
     
     
    Sign In to Vote
    0

    Hi,

    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.

    Best regards,
    Mathieu

    Microsoft .NET / Dynamics / MSSQL + BI

     
  • Saturday, August 18, 2012 11:49 PM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    0

    Hello,

    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.

    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Follow Andriy on Twitter

     
  • Monday, August 20, 2012 8:31 AM
    Moderator
     
     Proposed Answer
    Sign In to Vote
    0

    Hi,

    you can also refer http://mahenderpal.wordpress.com/2012/06/10/show-ms-crm-2011-optionest-values-in-dropdownlist-in-asp-net/

    Conatact Me
    Follow me on Twitter
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

     
  • Tuesday, August 21, 2012 2:39 PM
     
     
    Sign In to Vote
    0

    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.

    saroj

     
  • Wednesday, August 22, 2012 4:26 AM
     
     
    Sign In to Vote
    0

    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.

    Thank you.

    saroj

     
  • Wednesday, August 22, 2012 5:11 AM
    Moderator
     
     
    Sign In to Vote
    0

    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

    Microsoft CRM MVP - http://mscrmuk.blogspot.co  http://www.excitation.co.uk