SavedQueryVisualization always creates two records - Update / Retrieve-Problem

(0) Share

Report

Posted on by Tobias Koller

hi,

my plugin is creating an record of type "savedqueryvisualization" to display some information right beside the account-list (where the charts are located).

The problem I have right now is, that after I've created that record a second record with the same Id but different uniqueid gets created.

The view "savedqueryvisualization" only returns one record, but the table "savedqueryvisualizationbase" has two of these records.

The Problem:

when I retrieve the record from my plugin it returns the first record.

when I update the record it updates the second record (because they have the same Id)...

So I can never retrieve my updated record...

I checked the View "savedqueryvisualization": there is an orderby overwritetime asc which returns the wrong record.

any ideas how to fix this issue?

Tobias

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Radu Chiribelea 6,667 on at

Like (0)

Report

Looks to be related to the solution layering. What are the SolutionIds for each of the entries? Can you share the code you're using the perform these operations ?

Was this reply helpful? Yes No
T.Koller 145 on at

Like (0)

Report

no, the solutionid and the savedqueryvirtualizationid are exactly the same...the only difference is the unique id

Was this reply helpful? Yes No
Radu Chiribelea 6,667 on at

Like (0)

Report

How about the component state ?

Was this reply helpful? Yes No
T.Koller 145 on at

Like (0)

Report

one is 0, the other one 1...i think there is an issue within my plugin.

when I simply just create a new savedqueryvisualization it only creates one record.

Was this reply helpful? Yes No
Verified answer

Radu Chiribelea 6,667 on at

Like (0)

Report

One is published while the other one is unpublished: msdn.microsoft.com/.../gg328546.aspx

Can you share your code here? Also are you generating the SavedQueryVisualizationID from the code or are you letting the CRM Platform handle it?

Was this reply helpful? Yes No
Tobias Koller on at

Like (1)

Report

hi Radu,

thanks for your help. That was the problem...one is published, one is not.

After I published my entity the second record is gone.

Tobias

Was this reply helpful? Yes No