reports building relationship in query

[Ashwin32]

Hi

 we have requirement to join to tables, on table view dot walking works but while creating databsae view , dot working is not getting columns to join.

we have to joint two table  users and licenses entitlement on assign to but again its not working in databsae view

users.sys_id=License.Assignt_to,Sysid

is there any way to solve this prob? we need columns form both tables.

regards

Asg

[Iraj Shaikh]

Hi @Ashwin32 

There is no need to create database view. Creating report on License Entitlement table will accomplish your requirement.
You can add fields of user table by just dot walking through 'Assigned to' field of the License Entitlement table.

Please follow below steps:

Select 'Assigned to' field of the Available section and click on '+' icon as shown below

Since 'Assigned to' field is having reference of the user field. So, the user table fields will be available after clicking on '+' icon as shown below

You can select the user field as per your requirement and move it to the 'Selected' section as shown below

Please mark this response as correct or helpful if it assisted you with your question.

[Ashwin32]

Thanks!! Iraj

 we need data other way around, that means users need to join license on assign to , so user should be listed regardless of license i.e. user left outer join license