Can we combine two tables and get the fields without need to not walk to use in a report

[Nasreen2]

Hi All,

I got a requirement where user wanted to use the fields of multiple tables(task, asmt_assessment_instance, asmt_metric_result) in a single report since they wanted all the fields to be selectable directly from a single report for some Reporting automation to be done. So, I have created a database view combining these tables, and when I use this DB View in the report, the fields/columns coming from other tables are available as dot walking fields as shown below.

Here instead of dot walking, they wanted the fields to be available for direct selection like for example, instead of expanding the Assigned to field and then selecting the required field, they want that field to be directly selectable without expanding.

Is this possible to configure? 

Thanks,

Nasreen

[Dr Atul G- LNG]

No, even though it's a DB view, you can only access the first-level field values that are on the form. To access additional attributes for the same field, you need to use dot-walking.

For example, you can use dot-walking for the 'user' field, but for 'user manager,' you need to apply dot-walking. @Nasreen2 

[Ankur Bawiskar]

@Nasreen2 

the fields which you add in your view fields under your view table are allowed to add in gear icon.

You cannot add dot walked fields directly as view fields

So without expanding users can't add.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Nasreen2]

Can I get any servicenow documentation which support the above comment?

[Ankur Bawiskar]

@Nasreen2 

There is no documentation for this but there are lot many things which people know only when they implement it and then get to know that it's not possible.

I believe it's not possible even for ServiceNow to document each and every item.

If my response helped please mark it correct and close the thread so that it benefits future readers.