Data are empty in database view

[Preethi26]

Hi Team,

I have applied database view to license_role and license_has_family table to get the mapping of application, subscription, role.

But the data in license has family is empty.

Iam keeping application field which is reference from both table as a key to join.

Kindly suggest whats wrong i have did.

[boyslim70]

Can't see image clearly

[Preethi26]

[Jan Cernocky]

Hi Preethi,

I see you're using dots in the where clause but the correct syntax is with underscore.

Can you try to change it to this?

se_application = sa_license_family

[Preethi26]

Hi @Jan Cernocky 

Tried that too, but still data is empty.