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 Class.Code = 'BELV-M' ORDER BY Code
Responsibilities.ResponsibilityType.Name, shows me for example "Change package creator"
I would like to display the the persons name instead of the type of responsability..
can anybody help me?
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)
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.
Answer Verified By: Carma De Villiers