unexpected query values

[NF-London]

I am seeing multiple [object Object] results in a basic query.  These are returning from a recently created custom property called "Room Name" by a user.  The custom property is a basic text field with no list or other features.  Is this correct?  I cannot seem to filter on 'contains value' or any filter for that matter.

[Jef]

Hi Nigel,

That's right, content of the configured custom properties should basically be a text.

The following article describes custom properties in ITA: 

https://community.se.com/t5/Editing-properties/Custom-properties-in-ITA/ta-p/447081

As an example, I have configured custom properties like 'Status' and 'website' for a rack and a server (in my setup). Here is an illustration of what Equipment Browser would display for the selected filters (in Show Columns):

If you are seeing unexpected entries (like [object Object]), then I guess:
it might be browser related and you might want to reload the page and/or try with cleared cache,
or it might be something with the setup (that might need to be investigated).

Kind regards,

Jef

[NF-London]

Unfortunately it appears to be an error with the compiling of the query.  See the attached.  Where do we go from here?

[Jef]

Hi Nigel,

Sorry, I just noticed this.

I will contact you and open an investigation ticket.

Kind regards,

Jef 

[Jef · Accepted solution]

Hi Nigel,

Sharing a short update here,

It appears using 'ROOM_NAME' as custom properties causing sql query problem/errors in web-client Equipment Browser. Captured a bug report, so it can be fixed in future version(s).

As a current work-around/solution, I've suggested to add/configure a new/another custom properties (like room_name or Room_name) and then Consolidate 'ROOM_NAME' to the newly configured property.

Kind regards,

Jef