Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Modern Dashboard URL filters

I have been working on some Modern Dashboards and want to use the url filters talk about here:
documentation.solarwinds.com/.../core-fusion-dashboard-global-filters.htm

Let me walk you through where I get stuck.

Let's say I have a table widget with the SWQL of:

SELECT n.Caption,n.IP,n.MachineType,n.Status,n.DetailsUrl,n.VendorIcon , N.CustomProperties.Applications, N.CustomProperties.Support_Group
FROM Orion.Nodes n

I get how I can filter on status using: ?filters=5_Orion.Nodes_Status:eq:2
And I can swap out the _Status for any other field and make it work.

I and from my testing to filter on Custom Properties, I have to add an explicit join to that table.
Like in this SWQL:

SELECT n.Caption,n.IP,n.MachineType,n.Status,n.DetailsUrl,n.VendorIcon , N.CustomProperties.Applications, N.CustomProperties.Support_Group
FROM Orion.Nodes n
Join Orion.NodesCustomProperties NCP on N.NodeID = NCP.NodeID

I can search the custom property "Applications" with a filter like:
?filters=0_Orion.NodesCustomProperties_Applications:like:Application Name

And it will find nodes with the custom property 'Applications' set to 'Application Name' and the space won't bother anything.

Here's where I am stuck. I have underscores in some of my custom properties, properties that I use a lot. Underscores are clearly used in the URL parsing for tables and columns. It's even in the article I like above though I don't know if it's talking about the content it searches for. From the article:

Special characters
To safely construct/parse the URI parameter, global filtering does escape special characters.
Escaping is the simple operation of prefixing the following special characters with a single-quote character:
-_'|

I can't seem to get the underscore in a column name to be accepted by escaping it. Do I have to recreate the properties that have the special characters above?

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

What happens if you encode the underscore to "_" ?

jm_sysadmin

It gets truncated, none of the filter after where that replacement is is kept, so no filter applies. No error though

sum_giais

Hey @jm_sysadmin, I get the same results you see and also have underscores in numerous custom properties.

This is pretty cool funcionality though. I've got so many ideas on how to put this to use but not sure how conplex you can get with it.

jm_sysadmin

I love the ability. I am now recreating custom properties to work well with this feature.

mach5

Is there any safe path to remove underscore from custom properties name?

KMSigma.SWI

Depends on how entrenched they are in your environment.

If they are used for Alerts, Groups, Reports, Custom Widgets, Modern Dashboards, etc. - it can become a slog. Because Custom Properties are actually a net-new data table being added to the backend database, tons of stuff could rely upon them.

Is it possible to migrate the Node Custom Property from "Node_Role" to "NodeRole"? Yes, it's 100% possible, but there is no platform-native way to do this.

If I were asked to spearhead a set of tasks like this, I'd start with the All Defined Custom Properties (2023.3.0) report.

Then I'd try out a few new queries to see where Custom Properties are being used.

Then formulate yourself a plan by exporting the custom properties you need/want, changing their names, and then importing.

You should definitely have a lab environment in which to do this.

[embed:6b06e1a7-0ec1-4e43-9421-8caaf95469b6:65dd679d-a32e-4e15-b68c-2b05eed785c3:message=The%20only%20way%20to%20recover%20from%20deleting%20a%20Custom%20Property%20or%20importing%20incorrectly%20is%20to%20do%20a%20database%20restore.&type=warning]

maliron

For what it's worth I ran in to this issue with the underscores in custom properties as well and opened a case on it. They confirmed the bug, but do not have a fix on the roadmap yet.