Adding Queries To The Top Level Navigation

[Former Member]

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%>

[former_member89217 · Accepted solution]

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

[Former Member · Accepted solution]

Hi Gary,

Thanks for the reply.

I'll attach images sequentially on how I added the query to top level navigation.

Step1:

Select query group

Step 2:

Type in "Agreement" and press search

Step 3:

Select the second "master agreement" group

Step 4:

Click on edit

Step 5:

Select "Add query reference"

Step 6:

Select "All Query Definitions"

Step 7:

Select the query you want to add to the query reference

Step 8:

Then it will appear on the table after you check the checkbox with field name "Include in top level navigation"

I hope this is clear enough if not please feel free to request more details.

Kind regards,

Sabelo

[Former Member · Accepted solution]

Hi Gary, please advise on other ways to put the query on the top level navigation and there are no access entries on the query.

Kind regards,

Sabelo.

[Former Member · Accepted solution]

Hello Sabelo,

Add the query(Assigned To Me) in FCI-ContractBuyList Query Group. This resolves your issue.

Regards,

Vignesh

[Former Member · Accepted solution]

Hi Vigneshwar,

Thanks for your reply. Let me do it now so I can give you feedback.

Regards,

Sabelo.

[Former Member · Accepted solution]

Thank you Vigneshwar, you response was spot on!!!!