Microsoft Dynamics CRM (Archived)

After deleting a value, Global option-set still shows a value in report

(0) Share

Report

Posted on by Abhishek Gupta

2,003

HI,

After deleting some value from global option set 'caseorigincode'. It still shows values in report dropdown value.

Below is a sql query i am using to fetch global option set to create a database.

SELECT OS.NAME, L.LABEL, AV.VALUE FROM ATTRIBUTEPICKLISTVALUEASIFPUBLISHEDLOGICALVIEW AV
JOIN OPTIONSETASIFPUBLISHEDLOGICALVIEW OS
ON AV.OPTIONSETID = OS.OPTIONSETID
JOIN LOCALIZEDLABELASIFPUBLISHEDLOGICALVIEW L
ON L.OBJECTID = AV.ATTRIBUTEPICKLISTVALUEID
WHERE OS.ISGLOBAL = 1 AND OS.ISCUSTOMOPTIONSET = 0
AND L.OBJECTCOLUMNNAME = 'DisplayName'
AND OS.NAME ='incident_caseorigincode'

Below is a result

it still shows a value Facebook and twitter though i have deleted it from MS crm,saved and publish.

Let me know what mistake i am doing. Thanks.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

PranavShroti 4,510 on at

Like (0)

Report

CRM might have soft deleted... check in Advance Find by selecting particular colums and see what values comes for filtering.

Hope this helps.

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (0)

Report

Hi

Make sure the report is connecting to the same instance that you have deleted the optionset value from.

You could try a publish all and see that makes a difference

Was this reply helpful? Yes No
Abhishek Gupta 2,003 on at

Like (0)

Report

Hi,

Yes report are connected to right environment. I checked in advance find to, it shows below snapshot.

Thanks

Abhishek

Was this reply helpful? Yes No
Suggested answer

PranavShroti 4,510 on at

Like (0)

Report

So advance filter will only pick records that are active in CRM DB. Now you need to update your query to only fetch active records from table.

Hope this helps.

Was this reply helpful? Yes No
Abhishek Gupta 2,003 on at

Like (1)

Report

Hi ,

Thanks for clue. I found the solution in the ComponentState attribute.

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg328546(v=crm.8)#bkmk_componentstate

So i modify my query to bring values from global option set where component state =0

WHERE OS.ISGLOBAL = 1 AND OS.ISCUSTOMOPTIONSET = 0

AND L.OBJECTCOLUMNNAME = 'DisplayName'

AND OS.NAME ='incident_caseorigincode' and AV.ComponentState=0

Thanks

Abhishek

Was this reply helpful? Yes No