Formatted Search in GRPO Rows to Display Remarks Based on Quality Result

3 months ago 20

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
    DUMMY

    and it is showing lone for archetypal row

Read Entire Article