Hello.
When creating a query in Guardium 11.2 we need to choose Main Entity but after choosing it and getting further we should choose Entity & Attributes and there we can choose Entity that is different from Main entity. How does it work? Does it mean that if we choose Session entity and then choose Full SQL in Entity & Attributes it will show us Full SQL even if Main Entity doesn't have it inside and we can mix attributes from different entities no matter what entity was chosen as Main? What is Main entity used for then?
Or Main entity works as some sort of limiter that limits attributes that are available for showing in report and attributes from other entitiies that don't exist in entitty that is set as Main will not be shown in report (even if they are chosen in Query builder)?


------------------------------
Igor Volkov
------------------------------

Main entity defines relation between tables in your query

If you selected Session as a main entity the relation to full SQL is 1:N so in the Full SQL column you will have number of SQL visible in this session.

Read more for example from my blog:

https://guardiumnotes.wordpress.com/2017/10/06/guardium-reports-platform-understanding-1/

------------------------------
Zbigniew (Zibi) Szmigiero
IBM
Międzyrzecz
------------------------------