filter not working as expected

[KezHalls]

Hi
I am having issues with the filter across multiple queries. wondering if I am formatting incorrectly.

Environment

Operating System: windows 11
ServiceNow module version:4.0.5
PowerShell version: 7.4.5

Steps to reproduce

Both the below on same table. I would like to use the sys_class_name as that is more accurate for the data retrieval

#works with results returning
get-servicenowrecord -Table "cmdb_ci_service" -first 100 -DisplayValues true -filter @('category', '-eq', 'Business Service')

doesn't work, returns no results at all
get-servicenowrecord -Table "cmdb_ci_service" -first 100 -DisplayValues true -filter @('sys_class_name', '-eq', 'Business Service')

thanks

[gdbarron]

Hi @KezHalls. sys_class_name is a reference type field so you have to look it up slightly differently.

Running gsnr -table 'cmdb_ci_service' -Property sys_class_name -DisplayValue all -AsValue | where display_value -eq 'Business Service' | Select-Object -First 1 gives us

display_value    value
-------------    -----
Business Service cmdb_ci_service

The value you are currently using is the display name, not the actual underlying value. You need to use gsnr -table 'cmdb_ci_service' -first 100 -Filter @('sys_class_name','-eq','cmdb_ci_service'). The default value for -DisplayValue is true so that's not needed.

Category is a string and does not have the same constraint.

[gdbarron]

After a bit more research, it looks like sys_class_name isn't actually a reference field, it's a javascript lookup on the current table object. This would explain why dot walking does not work in this case.

So, the guidance above is valid, but the reasoning was slightly off 😄