Hardware Asset filter by Model and Type

Andrea_Zorzi

Hi,

I'm currently using this API "Projection/GetProjectionByCriteria"  to retrieve the hardware asset values using the following query in order to filter them by name:

"SimpleExpression": {

               "ValueExpressionLeft": {

                       "Property": "$Context/Property[Type='81e3da4f-e41c-311e-5b05-3ca779d030db']/Name$"              

               },

               "Operator": "Like",

               "ValueExpressionRight": {

                       "Value": "%test%"              

               }

        }

and the result is correct. 

Now i would like to filter the hardware asset also for the Model field and Type field that are two list, but this is not working. The filter working by guid but not by display name.

Is it possible to filter also the Model field and Type field ? If yes, How is it possible ?

Thanks
Andrea

Geoff_Ross

Hi Andrea,

I'm not sure you can use that API to filter on lists by their display name. The property of the class will just contain the guid of the enum. Any interface will then look those up in a display string table.

You have a couple of options.

You could first use this API

api/V3/Enum/GetFlatList

to get enum IDs containing the display string you need to search for. And then plug those into the criteria for the second API as above. This will not be very performant.

You could instead use the GetDashboardData API to return the data you need using a SQL query with tokens in place of the search term. The query would join the class table with the display string table, allowing you to filter on enumeration display names.This will be nice and fast as your SQL server will be doing the work, rather than the browser.

There is an example of this in the webinar:

https://player.vimeo.com/video/233694856

Check it out from about 11 minutes.

Geoff

Geoff_Ross

Hi Andrea,

I'm not sure you can use that API to filter on lists by their display name. The property of the class will just contain the guid of the enum. Any interface will then look those up in a display string table.

You have a couple of options.

You could first use this API

api/V3/Enum/GetFlatList

to get enum IDs containing the display string you need to search for. And then plug those into the criteria for the second API as above. This will not be very performant.

You could instead use the GetDashboardData API to return the data you need using a SQL query with tokens in place of the search term. The query would join the class table with the display string table, allowing you to filter on enumeration display names.This will be nice and fast as your SQL server will be doing the work, rather than the browser.

There is an example of this in the webinar:

https://player.vimeo.com/video/233694856

Check it out from about 11 minutes.

Geoff