Add new column on eB Web report.

I would like to generate a report for list of people registered on eB Web and I wanted to add few columns such as the Permission Roles and Skills. Is there a way to do it?

For instance, on below image I want to add new column next to Scope Name before generating the report.

Parents
  • Hello Adzrai,

    Try using Skills.Skill.Name and Roles.Role.Name fields as shown in eQL below

    START WITH Person
    SELECT
    Id,
    Code,
    Initial,
    Title,
    Surname,
    FirstName,
    DISPLAY_NAME( Status ) Status,
    Scope.Name,
    Skills.Skill.Name,
    Roles.Role.Name
    WHERE
    (
    Code LIKE @SearchString
    OR Surname LIKE @SearchString
    OR FirstName LIKE @SearchString
    )
    AND Status = 'A'
    AND IsTemplate = 'N'
    ORDER BY
    Code

    and let us know how it goes.

    Regards,
    NT

    Answer Verified By: Adzrai 

Reply
  • Hello Adzrai,

    Try using Skills.Skill.Name and Roles.Role.Name fields as shown in eQL below

    START WITH Person
    SELECT
    Id,
    Code,
    Initial,
    Title,
    Surname,
    FirstName,
    DISPLAY_NAME( Status ) Status,
    Scope.Name,
    Skills.Skill.Name,
    Roles.Role.Name
    WHERE
    (
    Code LIKE @SearchString
    OR Surname LIKE @SearchString
    OR FirstName LIKE @SearchString
    )
    AND Status = 'A'
    AND IsTemplate = 'N'
    ORDER BY
    Code

    and let us know how it goes.

    Regards,
    NT

    Answer Verified By: Adzrai 

Children
No Data