Skip to Content
avatar image
Former Member

Adding Queries To The Top Level Navigation

Good evening Gurus,

I added a query definition(Assigned To Me) at top level navigation but for certain users it doesn't appear. The users that have the query(Assigned To Me) at top level navigation have the "create master agreement role" and the users that don't have the query(Assigned To Me) at the top level navigation don't and shouldn't have the "create master agreement role".

Attached are images to give more details.

Image with the query(Assigned To Me)

Image without the query(Assigned To Me)

The Assigned To Me Query Code:


SELECT <%RESULTS%>

FROM

<%SCHEMA%>.FCI_MAS_VALUE_LIST_VALUE T4,

<%SCHEMA%>.FCI_CONTRACT T1

JOIN

<%COLLABCHECK_TBL(T1.OBJECTID, 1004)%>

LEFT OUTER JOIN (SELECT PARENT_OBJECT_ID, COUNT(*)

AS AGR_COUNT FROM <%SCHEMA%>.FCI_AGREEMENT

GROUP BY PARENT_OBJECT_ID) T2

ON T1.OBJECTID = T2.PARENT_OBJECT_ID

LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_INTERNAL_CAT T3

ON T1.INT_CAT_OBJECT_ID = T3.OBJECTID

<%DYN_JOIN%>

WHERE

T1.CONTEXTID =<%CONTEXT(contracts.Contract)%>

AND T1.IS_TEMPLATE =0

AND T1.STATUS_OBJECT_ID = T4.OBJECTID

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

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

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

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

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

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

AND

(

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

OR

(T1.DOC_OWNER_USER_OBJECT_ID=<%CURRENT_USER_ID%>)

)

<%DYN_FILTER%>

<%ORDERBY%>

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 15, 2015 at 06:37 PM

    How did you add the query to the top level navigation?  There is more than one way to do that. Also are there any access entries on the query/reports?

    Gary

    Add comment
    10|10000 characters needed characters exceeded