Avatars are useful for displaying an icon, image, or initials within a region. An Avatar can be used to display a single (partial) avatar, as multiple (report) avatars, or can be applied as a column type or in report templates to display an avatar for each report row. The multiple (report) display type is useful for being able to display multiple avatars as one region on a page outside of a report.
select TITLE, '#APP_FILES#' || IMAGE_URL as avatar from EBA_UT_DEMO_CARDS where category = 'badge'
In Interactive Reports, the Avatar partial is available for use as a column Type. The Avatar column in this demo uses the Avatar column Type and associated Partial settings to display an avatar in each row.
select ID, TITLE as name, SUBTITLE as job, BODY as email, substr(TITLE, 0, 2) as AVATAR from EBA_UT_DEMO_CARDS where category = 'badge'
The Avatar column uses the with-apply syntax in the HTML Expression attribute under Column Formatting to access the Avatar partial and display an avatar in each row.
{with/} TYPE:=IMAGE IMAGE:=#AVATAR# IMAGE_ALT:=Employee Profile Image SIZE:=t-Avatar--lg SHAPE:=t-Avatar--circle CSS_CLASSES:=u-color-29 {apply THEME$AVATAR/}
select ID, TITLE as name, SUBTITLE as job, BODY as email, '#APP_FILES#' || IMAGE_URL as avatar from EBA_UT_DEMO_CARDS where category = 'badge'