DevOps, CI/CD and Automation

Hi,

How do I conditionally exclude a column from XML output (I'm using Reports 10).

E.g. IF :fissile_weight = 0 then exclude from XML output else include in XML output.

I've excluded it from the printed output by writing a Format trigger but this does not appear to affect the XML output.

I've also tried the following code at the Group level but it does not work

IF NVL(:fissile_weight,0) = 0 THEN
SRW.SET_XML_TAG(SRW.COLUMN_XML, 'FISSILE_WEIGHT', NULL);
ELSE
SRW.SET_XML_TAG(SRW.COLUMN_XML, 'FISSILE_WEIGHT', 'eso:FissileWeight');
END IF;
return (TRUE);


Thanks
Citizen