Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Sample Query to fetch matched record from BO

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 590
    Comment on it

    Using the below query you can retrieve the records from the BO in which you execute the Match Job(manual merge) and to determine which records matched with other.

    select distinct(finalquery.src_rowid), 
    finalquery.party_nm,
    finalquery.PARTY_ID
    from
    (select pm.src_rowid, 
    pm.party_nm,
    pm.PARTY_ID
    from 
    (select parentrecord.*,1 seq,'match with' parentrec,'' childrec  from
    (SELECT mtch.rowid_object_matched, xr.pkey_src_object SRC_ROWID,
    bo.PARTY_NM,
    bo.ROWID_OBJECT PARTY_ID
    FROM c_bo_party bo
    INNER JOIN c_bo_party_xref XR
    ON bo.rowid_object=xr.rowid_object
    INNER JOIN c_bo_party_MTCH mtch
    ON bo.rowid_object=mtch.rowid_object_matched
    GROUP BY  mtch.rowid_object_matched,xr.pkey_src_object,
    bo.PARTY_NM,
    bo.ROWID_OBJECT) parentrecord
    union all
    select childrecords.*,2 seq,'' parentrec,'match to' childrec from 
    (SELECT mtch.rowid_object_matched, xr.pkey_src_object SRC_ROWID,
    bo.PARTY_NM,
    bo.ROWID_OBJECT PARTY_ID
    FROM c_bo_party bo
    INNER JOIN c_bo_party_xref XR
    ON bo.rowid_object=xr.rowid_object
    INNER JOIN c_bo_party_MTCH mtch
    ON bo.rowid_object=mtch.rowid_object 
    GROUP BY  mtch.rowid_object_matched,xr.pkey_src_object,
    bo.PARTY_NM,
    bo.ROWID_OBJECT) childrecords) pm  ) finalquery;

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: