Deploy Queries

Issue: netFORUM query details are replaced with new records when a saved query is updated when using the Deploy Tool.

Save a Query

Deploy Query

Modify Query on Target

Re-Deploy Query from source

Notice replacement of query detail records.

Make sure the deletes are included, otherwise:

Query conditions will show old and new conditions

Duplicate Query Order will display duplicates

And the query may fail depending on the combined logic.

This is a problem for clients that create deployment scripts that include query details, and fail to re-compare their source and target databases when re-deploying the query. If the original deploy script is re-executed on the target, after a query is updated on the target, the original query details will be combined with the "new" query details, causing the duplication.