Is it possible to make a widget in a modern dashboard that uses the code from my "Search SWQL Query" box as well?

I want to be able to display top 50 down but also search through the list with a query in a search bar. I've used the checkbox search in modern dashboards but it seems to only search the top 50 and not do a table lookup like the classic custom query "Search SWQL Query" Does. Thank you very much for any help you can provide.

EXAMPLE:

SELECT


NIP.NODE.Sysname AS [Name]

,'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(nip.node.nodeid) AS [_LinkFor_Name]

, '/Orion/images/StatusIcons/Small-' + nip.node.StatusLED AS [_IconFor_Name]

,NIP.IPAddress AS [IP Address]

,NIP.Interface.Name AS [Interface]

,NIP.Interface.Alias AS [Description]

,NIP.Interface.DuplexMode AS [Duplex Mode]

,NIP.Interface.InterfaceSpeed AS [Bandwidth]

,NIP.Interface.PercentUtil AS [Utilization]



----Used for Search Query on classic but doesn't work on modern dashboard----

FROM Orion.NodeIPAddresses NIP

WHERE (NIP.NodeID = ${NodeID})

AND (NIP.NODE.Sysname LIKE '%${SEARCH_STRING}%')

AND (NIP.IPAddress LIKE '%${SEARCH_STRING}%')

OR (NIP.Node.Caption LIKE '%${SEARCH_STRING}%')

OR (NIP.Interface.Caption LIKE '%${SEARCH_STRING}%')

ORDER BY NIP.Interface.Name

Find more posts tagged with

Modern Dashboards

Custom Query

Accepted answers

All comments

veenarani2312

[quote userid="290446" url="~/product-forums/the-orion-platform/f/orion-sdk/94739/is-it-possible-to-make-a-widget-in-a-modern-dashboard-that-uses-the-code-from-my-search-swql-query-box-as-well"]

[/quote]

I guess it is possible but it will take effort

dgsmith80

I would argue this isn't currently possible because the Modern Dashboard Tables are not paginated. It is a full list that you scroll down. So you can run the query as it is and set the widget size so that it only shows the first 50 entries, then when a user searches it will query the full table but will still be able to scroll down if there are more than 50 entries.

the_ben_keen

Why would you want to use the SWQL search? Is the built-in search within the widget (if you are running 2020.2.6) able to do the same search without having to add that SWQL search behind it?

shuth

I think the problem is he is using a SWQL query like "SELECT TOP 50 blah" for the initial widget.

The search box in the Modern Dashboard will then only search within those Top 50 results. With a Custom Query widget, it would run a new Top 50 search based on your search input.

Only workaround I can think of is to remove the TOP 50 but then the widget will want to display everything. You could limit it based on the widget size but it will still have the scroll bar.

the_ben_keen

Yeah having the "SELECT TOP 50" limits the results the widget brings in and the search feature only searches the information presented in the widget as you mentioned. Not sure resizing the widget would do anything because it would just make you scroll. I'm going to put this in my lab and see if I can figure something out.

dgsmith80

I read the OP as meaning that in a Custom Query widget you can select the "Number of Rows Per Page" option to say 50. That means your Widget will display 50 entries per page on your Dashboard BUT with the "Enable Search" option you could still search for any number of devices from the full query.

The "Search" function in a Modern Dashboard removes the requirement for the %{SEARCH_STRING}% stuff as it searches your fields naturally, but if you limit the Query to TOP 50 it will only search those 50, and if you don't then the Widget will load all your devices in the same way as Custom Query just less the Pagination.