Hi Experts,
I would require a sql query that will display all the persons entitlement.
though i have tried it in version 8.2 with following query
SELECT QERVPersonHasElement.Ident_Element,QERVPersonHasElement.UID_Person, QERVPersonHasElement.Ident_RessourceType, Person.FirstName , Person.LastName From QERVPersonHasElement Full Outer Join Person ON QERVPersonHasElement.UID_Person=Person.UID_Person ORDER BY QERVPersonHasElement.PWOXDateInserted
which gave me the desired output but in version 8.1 the QERVPersonHasElement table is missing can you guys help me out for this query in version 8,1