I try to build a query which shall be useable to search a specific field in the contract document section (contract document tab after a contract was uploaded). This query below is just only a draft. According to the results I’ve got redundant entries (see screenshot)and I don’t know how to set an additional filter which delivers me correct results by using this query for search.
FROM <%SCHEMA%>.FCI_CONGEN_CONTRACT_DOC T1,
<%EXT_TABLE(userdefined.bizdoc1, FCI_DYN_$2147483146)%> T3
AND T1.PARENT_CLASS_ID = 1004
AND T3.ZCLM_CMS_CONNO LIKE ?
Has somebody any idea what to do?
Thanks in advance