Use Custom Query Script Lost and Update Query Plan not working

[Former Member]

Hi

There is a bug in restful change datasource after change source the "Use Custom Query Script" is reset to false???

We try to fix is by updating the query plan as it

GET documents/{0}/dataproviders/{1}/queryplan

PUT documents/{0}/dataproviders/{1}/queryplan with the content of the GET

even after sertting custom=\"true\"

<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?>\n<queryplan editable=\"true\" custom=\"true\">

The response is success the query plan has not been modified?????

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<success>

    <message>The resource of type &quot;Query plan&quot; has not been modified.</message>

</success>

BI41 SP6 FP3 !!!

[daniel_paulsen · Accepted solution]

Hi Jean-Philippe,

Do you see the same results if you actually change the query that you retrieve from the GET?

If I follow your workflow and do not change the query, but only change the "custom" attribute, I get the same results as you do, but if I actually modify the query to be a custom query, it does get updated accordingly.

Does this work for you or are your expectations that the query should be considered updated when only changing the "custom" attribute without actually changing the query? (ie only setting the value for "use custom query script" should cause an update)

Dan

[Former Member · Accepted solution]

You are right if I really modify the SQL it is kept and changed. only changing the "custom" att to true does nothing.

Thank for your help