How to change existing saved SQL Queries in GoldMine? How to update saved SQL Queries within GoldMine?

Version 1

    Details

    How to change existing saved SQL Queries in GoldMine? How to update saved SQL Queries within GoldMine?




    Resolution

    [STEPS]
    1. Tools >> SQL Query
    2.  From the drop down select the desired SQL Query to be modified (it might  be necessary also to select the specific GoldMine user from the drop  down)


    3. Update/ Modify the query as desired


    4. Button Save


    5. Check Update current query and if applicable change the name to reflect your changes


    6. OK
    >> RESULT: The original query is updated and either still with the original name available of if the name for the query was changed with the new provided query name





    ALTERNATIVELY the modified query can be added as an additional saved SQL Query

    5. Check Save as new query and recommended provide a different name, when the query should appear as an additional drop down entry from the list of saved SQL Queries


    6. OK
    >> RESULT: The saved query is added as a separate drop down entry for saved SQL Queries