Difference between revisions of "Delete Non-functional Saved Search"

From IMSMA Wiki
Jump to: navigation, search
m (Dionysia moved page Not possible to delete Saved Searches to Delete Non-functional Saved Search without leaving a redirect)
Line 10: Line 10:
 
# Press Ctrl+A and then Ctrl+C
 
# Press Ctrl+A and then Ctrl+C
 
# Copy to Navicat or Word
 
# Copy to Navicat or Word
# Edit the SQL statement to something that works with PostGreSQL
+
# Edit the SQL statement to something that works with PostgreSQL
 
# Copy and paste into the SQL field
 
# Copy and paste into the SQL field
 
# Save
 
# Save

Revision as of 17:56, 18 October 2014

If a Saved Search is not functioning it is not possible to delete it. This might feel a bit backwards but there is a very easy work-around:

  1. edit the Saved Search until it works
  2. save
  3. delete.

After upgrading IMSMANG to V6.0 there might be Saved searches that do not work, especially if they use SQL.

  1. Edit the Saved search
  2. Click in the SQL field
  3. Press Ctrl+A and then Ctrl+C
  4. Copy to Navicat or Word
  5. Edit the SQL statement to something that works with PostgreSQL
  6. Copy and paste into the SQL field
  7. Save
  8. Now it is possible to delete. Note that the query will be executed in the background so if the edited SQL returns many rows it will take a few seconds to delete.

Example non-working SQL statement

SELECT
	hazreduc.hazreduc_guid
FROM
	hazreduc
INNER JOIN (
	SELECT
		b.hazreduc_localid,
		COUNT (b.hazreduc_localid) AS 'No'
	FROM
		hazreduc b
	GROUP BY
		b.hazreduc_localid
) b ON hazreduc.hazreduc_localid = b.hazreduc_localid
WHERE
	b. NO > 1
ORDER BY
	hazreduc.hazreduc_localid

Example of edited SQL statement

SELECT
	hazreduc_guid
FROM
	hazreduc