Skip to Content
avatar image
Former Member

Use Custom Query Script Lost and Update Query Plan not working

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 !!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 19, 2015 at 09:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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