Unable to delete custom made query

Liz_Ross

One of our IT Analysts saved 3 custom queries in the "search" area of the Portal.  One worked for a couple days, but she said she edited its criteria, and now when she looks at the query, Nothing shows up except the title of the Query up top.  No content shows in the center of the screen, and no options like "Edit" at the top right, or "Delete", "Save as" etc., show at the bottom either.   Not sure how to help her clear out this search.

Geoff_Ross

Hi Liz,

Nice to meet another Ross.

If the view is completely stuck, you can remove directly from the database with the following query.

-- Look up the guid in the URL of the view and paste it here
DECLARE @ViewGuid nvarchar(255) = 'e482ac21-9615-47d5-93e8-6c077e6ea754'

DELETE FROM NavigationNode
WHERE Id = @ViewGuid

DELETE FROM NavigationNode
WHERE Id = (
	SELECT Id FROM ViewPanel
	WHERE CHARINDEX(CONVERT(NVARCHAR(50), Id),(
		SELECT [Definition] FROM NavigationNode
		WHERE id = @ViewGuid)
	)  > 0
)

Geoff

This post is provided 'as is' with  no guarantees of any kind. Please test and back up your database first.

Liz_Ross

Oh just to add, her other 2 queries work fine and the Delete and other buttons are visible along the bottom.  I have also zoomed in/out (we're in IE 11) of the page but still none of these options show up.

merlenette_jones

Hello,

You can attempt to clear the browser cache by using (ctrl+F5). Also, have you tried recreating the view from scratch? 

What version of the Portal are you running?

Merle

Geoff_Ross

Hi Liz,

Nice to meet another Ross.

If the view is completely stuck, you can remove directly from the database with the following query.

-- Look up the guid in the URL of the view and paste it here
DECLARE @ViewGuid nvarchar(255) = 'e482ac21-9615-47d5-93e8-6c077e6ea754'

DELETE FROM NavigationNode
WHERE Id = @ViewGuid

DELETE FROM NavigationNode
WHERE Id = (
	SELECT Id FROM ViewPanel
	WHERE CHARINDEX(CONVERT(NVARCHAR(50), Id),(
		SELECT [Definition] FROM NavigationNode
		WHERE id = @ViewGuid)
	)  > 0
)

Geoff

This post is provided 'as is' with  no guarantees of any kind. Please test and back up your database first.