CA Service Management

 View Only
  • 1.  Repor attachemnts

    Posted Sep 28, 2020 07:15 PM
    Hi good afternoon




    They could give me a procedure to get the information correctly

    Tanks.
    Regads


  • 2.  RE: Repor attachemnts

    Broadcom Employee
    Posted Sep 29, 2020 02:25 AM
    Edited by Brian Mathato Sep 29, 2020 02:33 AM
    Hi Anabel,

    It looks like your join or where-clause is incorrect. Share the query that is returning the results and we might be able to assist you further

    ------------------------------
    Kind Regards,
    Brian
    ------------------------------



  • 3.  RE: Repor attachemnts

    Posted Sep 29, 2020 11:19 AM
    Hi good day

    Thanks for helping me, see I share my query

    SELECT
    lrel_attachments_changes.attmnt,
    lrel_attachments_changes.chg,
    lrel_attachments_changes.id,
    lrel_attachments_changes.last_mod_dt,
    lrel_attachments_changes.persistent_id,
    chg.chg_ref_num,
    chg.status_symbol,
    chg.tenant_name,
    chg.id
    FROM
    lrel_attachments_changes,
    chg
    WHERE
    chg.tenant_name = 'Flap'

    Regas.


  • 4.  RE: Repor attachemnts

    Posted Sep 29, 2020 05:09 PM
    Edited by Lindsay Estabrooks Sep 30, 2020 03:00 PM
    I think you need to specify the attributes on which to join the two tables

    SELECT
    lrel_attachments_changes.attmnt,
    lrel_attachments_changes.chg,
    lrel_attachments_changes.id,
    lrel_attachments_changes.last_mod_dt,
    lrel_attachments_changes.persistent_id,
    chg.chg_ref_num,
    chg.status_symbol,
    chg.tenant_name,
    chg.id
    FROM lrel_attachments_changes
    JOIN chg ON chg.id = lrel_attachments_changes.chg
    WHERE
    chg.tenant_name = 'Flap'


    Cheers,
    Lindsay

    ------------------------------
    Lindsay Estabrooks
    Principal Consultant
    IT-EDU Consultants
    ------------------------------



  • 5.  RE: Repor attachemnts

    Posted Sep 30, 2020 01:53 PM
    Hi Lindsay 

    Ok thanks a lot for the help

    Regads