NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "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: # edit the Saved Search until it wo..."
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:
# edit the Saved Search until it works
# save
# delete.
After upgrading {{IMSMANG}} to V6.0 there might be Saved searches that do not work, especially if they use SQL.
# Edit the Saved search
# Click in the SQL field
# Press Ctrl+A and then Ctrl+C
# Copy to Navicat or Word
# Edit the SQL statement to something that works with PostGreSQL
# Copy and paste into the SQL field
# Save
# 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'''
<pre>
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
</pre>
'''Example of edited SQL statement'''
<pre>
SELECT
hazreduc_guid
FROM
hazreduc
</pre>
[[Category:NAA]]
# edit the Saved Search until it works
# save
# delete.
After upgrading {{IMSMANG}} to V6.0 there might be Saved searches that do not work, especially if they use SQL.
# Edit the Saved search
# Click in the SQL field
# Press Ctrl+A and then Ctrl+C
# Copy to Navicat or Word
# Edit the SQL statement to something that works with PostGreSQL
# Copy and paste into the SQL field
# Save
# 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'''
<pre>
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
</pre>
'''Example of edited SQL statement'''
<pre>
SELECT
hazreduc_guid
FROM
hazreduc
</pre>
[[Category:NAA]]