1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

How can I get one record from same multiple records?

Discussão em 'StackOverflow' iniciado por fdantas, Abril 5, 2019.

  1. fdantas

    fdantas Administrator Moderador

    Hi I have written a query which need to show the data in drop down box. Let me share my query what i written

    DEFINE TEMP-TABLE tt_seq_report.
    FIELD tt_seq_report.neutral_part_obj AS DECIMAL
    FIELD tt_seq_report.patt_id AS CHARACTER
    FIELD tt_seq_report.npai_info2 AS CHARACTER.

    EMPTY TEMP-TABLE tt_seq_report.

    FOR EACH gdmf_neutral_part NO-LOCK :
    FIND FIRST gdcf_part_type WHERE gdcf_part_type.part_type_obj EQ gdmf_neutral_part.part_type_obj NO-LOCK NO-ERROR.
    CREATE tt_seq_report.
    ASSIGN
    tt_seq_report.neutral_part_obj = gdmf_neutral_part.neutral_part_obj
    tt_seq_report.patt_id = gdcf_part_type.patt_id WHEN AVAILABLE gdcf_part_type
    tt_seq_report.npai_info2 = gdmf_neutral_part.npai_info2.


    END.

    /* Written in window main block */

    FOR EACH tt_seq_report NO-LOCK :
    coCombo-2:ADD-LAST(tt_seq_report.patt_id).
    END.

    FOR EACH tt_seq_report NO-LOCK :
    coCombo-3:ADD-LAST(tt_seq_report.npai_info2).
    END.
    /*
    If you see tt_seq_report.patt_id and tt_seq_report.npai_info2 data is
    i.e tt_seq_report.patt_id -BFA
    tt_seq_report.npai_info2 -23
    tt_seq_report.patt_id -BFA (same id)
    tt_seq_report.npai_info2 -24
    tt_seq_report.patt_id -SS
    tt_seq_report.npai_info2 -23
    tt_seq_report.patt_id -SS (same id)
    tt_seq_report.npai_info2 -24
    tt_seq_report.patt_id -ABS
    tt_seq_report.npai_info2 -23
    tt_seq_report.patt_id -ABS (same id)
    tt_seq_report.npai_info2 -24
    and so on.
    */


    So here tt_seq_report.patt_id is same for one set of records but tt_seq_report.npai_info2 is will not be same for every records. I could use where condition if there is tt_seq_report.patt_id is BFA,SS,ABS only but it has many.

    If I run this window then i can get multiple same tt_seq_report.patt_id in drop down box.

    i.e once we select drop down box the showing records like below CustID(label Name for dropbox) Value(label Name for dropbox)

    BFA 23 BFA 24 SS 23 SS 24 ABS 23 ABS 24

    But My expected output should be

    CustID(label Name for dropbox) Value(label Name for dropbox)

    BFA 23 24

    SS 23 24

    ABS 23 24

    Please help this case. Thank you.

    Continue reading...

Compartilhe esta Página