running apex 5.1 trying to create badge list in the classic report
Used this query to get a badge list.
When it executes it creates a circle badge with line 9 and the word label under it and a badge with the count and the word value under it. Same for the union query.
What I was expecting is the value of the count in the badge and the word line 9 under the badge.
What am I missing here? In addition to this I'd like to create a link to another page.
is there a another/better way in apex 5.1 to do this?
--
select 'Line 9' Label,count(*) value from
jmaag.duplicate_rod_count
where
trunc(create_date)='16-mar-2017'
and decode(location_id,57,9,59,9,61,9,11)=9
union all
select 'Line 11' label,count(*) value from
jmaag.duplicate_rod_count
where
trunc(create_date)='16-mar-2017'
and decode(location_id,57,9,59,9,61,9,11)=11