how to access different context agreenents in single context

[Former Member]

how to access different context agreements in single context

I am having two context one is buy side second one sell side.

We have  developed one Query this query gives all sell side and buy side agreements.

SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_CONTRACT T1 WHERE T1.INACTIVE = 0 <%ORDERBY%>

if i click the buy side agreements id it will open the agreement.

if i click the sell side agreements id it is not opening the agreement we are getting error.

we have executed above query in buy side is it possible to open sell side context agreement?

[former_member89217 · Accepted solution]

The above query actually violates a basic principle in the application -- context security. Query results should always be filtered by the specific context the current user is in.   That being said, in a multi-context system one could do as you did and show results across contexts.  However, when trying to access documents across contexts you will then run into the document level security.  User A in context A will not be granted explicit access to documents in context B.  This is by design.