Report making: add columns from other table

[KateN]

Hi,

I'm trying to make a report from table "Computer (cmdb_ci_computer)" but I'd like to add columns from another table "requested Item (sc_req_item)" like this ones: Number, name, activity for, item, etc.. 

But if I go to the colomn selector and add these fields (under requested item), and I run the report, the fields are empty.. 

Where as I make a report on the requested Item (sc_req_item), these colomns do show values. 

[Chetna_dev]

It seems like you're encountering an issue with joining tables in your report. When you add columns from the "requested item" table to your report based on the "Computer" table, you're essentially performing a join operation between these two tables. If the fields from the "requested item" table are appearing empty in the report, it could be due to the absence of corresponding records or incorrect join conditions

[KateN]

Hi, 
Thank you for your reply, what can I do to fix this?

[Astik Thombare · Accepted solution]

Hi @KateN ,

If you're unable to achieve this through dot walking, consider creating a database view to join the tables. Here's a link that explains how to create database views:

https://www.youtube.com/watch?v=vk1MYBxTSxY

Please let me know if this helps! You can mark this answer as "Correct" if it resolves your issue, and "Helpful" if you find it valuable.

Thanks,

Astik Thombare

[AndersBGS]

Hi @KateN ,

Is the computer present on the req item table? If yes, then you can dot-walk from the req item table, and dot-walk to the computer table to get data from both tables.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards 

Anders