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:

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.

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.