In the GRPO document, I person the pursuing user-defined fields (UDFs) astatine the enactment level:
- QUALITYRESULT (Alphanumeric values are A and R): This tract stores the prime effect of each item. it is successful Child table
- REMARKS (Alphanumeric): This tract stores remarks related to the item. It is successful Child table
- DisplayRemarks (Alphanumeric): This tract is intended to show the remarks conditionally. It is successful Parent table
what one privation is for each enactment successful kid if I get Quality result = 'R' past DisplayRemarks should show REMARKS
but it should happend for each row.i utilized query
SELECT
CASE
WHEN $[$38.U_MKTR_QUALITYRESULT.0] = 'R' THEN $[$38.U_MKTR_REMARKS.0]
ELSE NULL
END AS Remarks
FROM
DUMMYand it is showing lone for archetypal row