I created the query according to the example, but an error was reported during execution，in the CMDB Query Builder ？，

[David294]

I created the query according to the example, but an error was reported during execution，

Example

1. Navigate to All > Configuration > CMDB Query Builder.
2. Click Create new. Enter a Name - All servers with a connection to a DB. Choose CMDB Query, and click Create.
3. In the CMDB Classes list, locate the Server class, and drag it to the canvas.
4. Locate the Database class, and place it to the right of the Server class node on the canvas.
5. Click at the center of the right side of Server, and then at the center of the left side of Database to create a connection line between the two class nodes.

6. Click on the connection line once or twice until the Connection Properties appear in the right-side bar. In the Relationship Types and Related Items section, click Add Relationship Types and add all the relationships from the list.

   

7. Click Save, and then click Saved Queries on the left to see the widget for the saved query.
8. Click the query widget to return to the canvas in edit mode.
9. Click Run to execute the query.

   Review the query results. Each row displays the name of a server CI, the name of a database CI, and the relationship type between them.

10. Add columns to the query results:
    1. Click the Server 1 node on the canvas once or twice so that the Server 1 Report Columns section appears in the right-side pane. Click Add Columns.
    2. Select Manufacturer and then click outside the columns list to close it.
    3. Click Run.

       Review the query results which now include the Manufacturer column.

    4. Click Save again to save all your customization for this query.

[Siddharth27]

I have tried to replicate the steps at PDI and no errors were thrown. Try to replicate the issue again with different query and see if it works for you.

[trwblanchard]

I've finally managed to get around this myself. I'd get this issue when working in an application scope. Try creating a new one in Global instead. I think there are some hard-coded references to "u_cmdb_..." which would not work with an application prefix before the u_

[spandana3]

Hi 

In the above CMDB query filter there are two elements "Add relationship type" and "Add related item"  these are not visible to in our cmdb query builder can you let me know how to activate the those two elements.

Thanks in Advance.