where does the unpublished values will be stored for ms crm

(0) Share

Report

Posted on by sandeepc

5,470

recently we created optionsets from Nav to CRM through ssis package using cozyroc tool and the option set was showing in crm once package executed successfully but the data was not showing in database once we saved and published the data those option sets showed in data base

my question is where does the option set will be stored in database (sql) untill we publish it in crm??

*This post is locked for comments

All responses (29)

Answers (3)

sandeepc 5,470 on at

Like (2)

Report

RE: where does the unpublished values will be stored for ms crm

thank a lot
Suggested answer

Adrian Begovich 1,025 Super User 2025 Season 1 on at

Like (1)

Report

RE: where does the unpublished values will be stored for ms crm

Hi sandeepc,

Option Set values are stored in the StringMapBase table, so if the database transaction has not taken place then you can not query for the Option Set values. It is impossible to retrieve the unpublished Option Set values.
Verified answer

sandeepc 5,470 on at

Like (0)

Report

RE: where does the unpublished values will be stored for ms crm

can we add some more steps in code to get unpublished optionset
sandeepc 5,470 on at

Like (0)

Report

RE: where does the unpublished values will be stored for ms crm

s
Verified answer

Adrian Begovich 1,025 Super User 2025 Season 1 on at

Like (1)

Report

RE: where does the unpublished values will be stored for ms crm

Hi sandeepc,

Did the query work without your addition?
sandeepc 5,470 on at

Like (1)

Report

RE: where does the unpublished values will be stored for ms crm

thanks for your replys @adrian
sandeepc 5,470 on at

Like (0)

Report

RE: where does the unpublished values will be stored for ms crm

new option set which was saevd but not published is not showing. i think we need to do some research on where does the unpublished optionset stores
sandeepc 5,470 on at

Like (0)

Report

RE: where does the unpublished values will be stored for ms crm
Suggested answer

Adrian Begovich 1,025 Super User 2025 Season 1 on at

Like (1)

Report
RE: where does the unpublished values will be stored for ms crm

Hi sandeepc,

This is a less strict version of the query. We can tighten things up after you get this example working.

select dbo.StringMapBase.AttributeName, dbo.StringMapBase.AttributeValue, dbo.StringMapBase.Value from dbo.StringMapBase where dbo.StringMapBase.AttributeName = 'address1_shippingmethodcode'
sandeepc 5,470 on at

Like (0)

Report

RE: where does the unpublished values will be stored for ms crm

what about unpublished data