Query functionality inconsistency

[Former Member]

Hi gurus,

Please assist with the following, it was working properly all along but when I checked it today this error came out:

Query Code:

SELECT DISTINCT <%RESULTS%> FROM <%SCHEMA%>.FCI_UDEF_BIZDOC1 T1 LEFT OUTER JOIN <%SCHEMA%>.FCI_UDEF_PHASE_SUB1 T2 ON T1.CURR_CONFIG_PHASE_OBJECT_ID = T2.OBJECTID LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_INTERNAL_CAT T3 ON T1.INT_CAT_OBJECT_ID = T3.OBJECTID <%MS_JOIN%>WHERE T1.INACTIVE = 0 AND T1.IS_TEMPLATE = 0 AND T1.CONTEXTID=<%CONTEXT(userdefined.bizdoc1)%> AND ((?=0) OR (T1.DOC_OWNER_USER_OBJECT_ID=<%CURRENT_USER_ID%>)) AND (<%SCHEMA%>.<%FCI_DOC_CHECKCOLLAB(T1.OBJECTID, 9999101, ?)%> = 1) <%ORDERBY%>

Image with error attached.

[Former Member · Accepted solution]

Hello Sabelo,

I feel this error is popping up due to the syntax error in FCI_DOC_CHECKCOLLAB logic. Please refer My Projects(FCI-MyProjectsActive) query to find the standard logic for it.

Hope this helps!

Regards,

Vignesh

[Former Member · Accepted solution]

Hi Vigneshwar,

Thank you for your response, I managed to sort it out have a look at it:

SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_UDEF_BIZDOC1 T1 LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_INTERNAL_CAT T4 ON T1.INT_CAT_OBJECT_ID = T4.OBJECTID

AND <%SCHEMA%>.FCI_DOC_CHECKCOLLAB(T1.OBJECTID, 9999101,<%CURRENT_USER_ID%>,'<%CURRENT_USER_GROUPS%>') = 1

AND ((<%?(MyOwnership)%>=2) OR

(T1.DOC_OWNER_USER_OBJECT_ID=<%CURRENT_USER_ID%>)) <%AND_OP("T1.INACTIVE",<%?(T1.INACTIVE)%>)%>

<%DYN_JOIN%>

WHERE T1.CONTEXTID=<%CONTEXT(userdefined.bizdoc1)%>

<%AND_OP("UPPER(T1.DISPLAY_NAME)",<%?(T1.DISPLAY_NAME)%>)%>

<%AND_OP("UPPER(T1.DOCUMENT_DESCRIPTION)",<%?(T1.DOCUMENT_DESCRIPTION)%>)%>

<%AND_OP("UPPER(T1.IS_TEMPLATE)",<%?(T1.IS_TEMPLATE)%>)%>

<%AND_OP("T1.INT_CAT_OBJECT_ID",<%?(T1.INT_CAT_OBJECT_ID)%>)%>

<%AND_OP("T1.INACTIVE",<%?(T1.INACTIVE)%>)%>

<%DYN_FILTER%>

<%ORDERBY%

It runs smoothly now.