Delete Non-functional Saved Search - Revision history

Alnaucler at 19:52, 5 April 2015

2015-04-05T19:52:42Z

← Older revision		Revision as of 21:52, 5 April 2015
Line 1:		Line 1:
	{{Note \| Even if you edit the Saved search so it works, it is not possible to delete it if it is used as Data source for a iReport}}		{{Note \| Even if you edit the Saved search so it works, it is not possible to delete it if it is used as Data source for a iReport}}

	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~~:		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 workaround:
	# edit the Saved Search until it works		# edit the Saved Search until it works
	# save		# save

Alnaucler at 14:40, 29 October 2014

2014-10-29T14:40:18Z

← Older revision		Revision as of 16:40, 29 October 2014
Line 1:		Line 1:
			{{Note \| Even if you edit the Saved search so it works, it is not possible to delete it if it is used as Data source for a iReport}}

	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:		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		# edit the Saved Search until it works

Alnaucler at 16:56, 18 October 2014

2014-10-18T16:56:36Z

← Older revision		Revision as of 18:56, 18 October 2014
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

Dionysia: Dionysia moved page Not possible to delete Saved Searches to Delete Non-functional Saved Search without leaving a redirect

2014-06-26T08:24:40Z

Dionysia moved page Not possible to delete Saved Searches to Delete Non-functional Saved Search without leaving a redirect

← Older revision	Revision as of 10:24, 26 June 2014
(No difference)

Alnaucler at 22:11, 25 June 2014

2014-06-25T22:11:39Z

← Older revision		Revision as of 00:11, 26 June 2014
Line 43:		Line 43:
	hazreduc		hazreduc
	</pre>		</pre>
			{{NavBox Technical Notes}}

	[[Category:NAA]]		[[Category:NAA]]

Alnaucler: 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..."

2014-06-25T22:09:33Z

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..."

New page

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]]