EQL display responsability value

Hello pmari,

I think for fetching person name you should try using  'Responsibilities.Person.FullName'  or 'Responsibilities.Person.FirstName' instead of Responsibilities.ResponsibilityType.Name

Please refer screen shot,

problem is we have several responsability types like

- Change package creator

- Hoofaannemer (the guy who is reposable for the change)

and i would like to display the Fullname of the "Hoofdaannemer"

Hi,

If you want to display the fullname of "Hofdaannemer" then try the following eql :

START WITH ChangeRequest

SELECT

  Code,

  Description,

  DateRegistered,

  Attributes["Global", "Tijdelijke wijziging"].Value,

  Attributes["Global", "Risicoanalyse"].Value,

  Attributes["Global", "Regularisatiewijziging"].Value,

  Responsibilities.Person.FullName,

  Responsibilities.ResponsibilityType.Name,

  AuditDetails.Person.FirstName,

  AuditDetails.Person.Surname

WHERE

 Responsibilities.ResponsibilityType.Name='Hoofdaannemer'

 AND

 Class.Code = 'BELV-M'

ORDER BY

  Code

I have performed the same at my end,

Just make sure that in the Responsibility topic of Change request , the Person must have some entry(or value) in its Full Names and First Names fields in Properties, 

Hope this helps you.

Many thx Jyoti ....

last question :

is it also possible to show on the same line now the different Responsability people in 2 different columns for the corresponding reponsability type :

- Change Package Creator

- Hoofdaannemer

so :

Change request /Status/Description/ ........./Responsabilityperson.surname(Change P Creator)/Responsabilityperson.surname(Hoofdaannemer)

Many thx Jyoti ....

last question :

is it also possible to show on the same line now the different Responsability people in 2 different columns for the corresponding reponsability type :

- Change Package Creator

- Hoofdaannemer

so :

Change request /Status/Description/ ........./Responsabilityperson.surname(Change P Creator)/Responsabilityperson.surname(Hoofdaannemer)

Hello pmari,
As per my knowledge it is not possible to show two different responsibility type people in two different columns, all different responsibility types will be displayed in a single column but in different rows.
Again if you want to display a person having two different responsibility types in single column then use ‘And keyword’
e.g.WHERE Responsibilities.ResponsibilityType.Name='Hoofdaannemer' AND Responsibilities.ResponsibilityType.Name='Change Package Creator'
If you want to display person having either of the two responsibilities i.e. 'Hoofdaannemer' or 'Change Package Creator' then use ‘Or’ keyword.