Hi
I am using Apex 24.2
I have a region of Type Cards. My sql is:
select
a.barcode as wagen,
decode(a.status, 1, 'Scannen', 2, 'abholbereit', 3, 'entladen') as status_desc,
b.halle as halle,
apex_util.get_since(a.status_change) as last_update,
max(c.seqnr) as vv,
'Anzahl Gebinde: ' ||count(c.seqnr) as count_scans
from BDV2001.ZIRKUSWAGEN_SCANWAGEN@BDV_PROD a
left join BDV2001.ZIRKUS_HALLEN@BDV_PROD b
on b.halle_id = a.halle
left join BDV2001.ZIRKUSWAGEN_SCAN@BDV_PROD c
on c.seqnr = a.seqnr
group by
a.barcode,
a.status,
b.halle,
a.status_change;
Attributes: title column is wagen. Subtitle column is last_update. Body column is status_desc. Secondary body column is halle. Icon column is count_scan.
If status_desc = Scannen, the body and badge should have a blue background. If status_desc = abholbereit, the body and badge should have a yellow background. If status_desc = entladen, the body and badge should have a green background.
Any help appreciated
Regards
Gus