How to edit an existing custom query in a data connection

How to edit an existing custom query in a data connection

This article describes how to edit an existing custom query in a data connection.
 

For version 7.14 and earlier:

1. From within TIBCO Spotfire Analyst, go to "Edit - Data Connection Properties".
2. Click  the "Settings..." button.
3. In the "General" tab, click on the "Edit..." button.
4. Highlight your custom query under "Views in connection:".
5. Click "Custom Query" and do the necessary changes.
6. Click the "Verify" button to verify the query is correct.
7. Click "Yes" to the popup question if you want to update columns.
8. Click OK.

For version 10.0 and higher, there are 2 ways to edit an existing custom query:

Option 1

1. From within Analyst client, go to "Data - Data Connection Properties".
2. Click the "Settings..." button.
3. In the "General" tab,  click on the "Edit..." button.
4. Highlight your custom query under "Views in connection:".
5. Click "Custom Query" and do the necessary changes.
6. Click the "Verify" button to verify the query is correct.
7. Click OK.

Option 2

1. Open the Data canvas.
2. Click on the cogwheel found under the red database icon representing the data connection.
3. Click "Custom Query" and do the necessary changes.
4. Click the "Verify" button to verify the query is correct.
5. Click OK.

Note: Custom queries must be trusted by a user belonging to the group "Custom Query Author" in order to work in the web clients. If you have an existing custom query and only want to change data source, please check the following article for how this can be achieved: 
https://support.tibco.com/s/article/How-to-update-database-server-information-on-existing-data-connections

Keywords: edit, custom, query, edit custom query