Hi,
I want to insert a column to an existing Distribution list report so that users can listed users, their positions and status, and I'm stuck with Position.
the below is what I've created so far. I'm not sure what to add to get the users position (it's an attribute called 'position')
Can anybody share your knowledge?
The custom attributes of related objects, persons on distribution lists in this case, are generally not available in eQL, but this data could be exposed using the EXEC option, as documented in the eQL Help documentation. This option allows you to write queries directly in the native SQL and extract whatever you need, but this requires SQL programming knowledge.
Eric Rajala | Consultant
Cohesive
Email: eric.rajala@cohesivegroup.com
www.bentley.com
Hi Vivien, Have you tried the below:
START WITH DistributionList SELECT LineItems.Person.Code, LineItems.Person.Attributes["Global", "a"].Value WHERE Id > 0