My Agreements and contract document-Report

[jaheer_hussain]

Hi,

    I copied 'My Agreements and contract document-Report',now I want to add one filter field  status.How to modify this query to add this filter field status,so that I can get a report based on status.Can some throw light on this please?

Status are  Draft/approved/executed/expired...

With Regards,

Jaheer.

[former_member207877 · Accepted solution]

Hi Jaheer,

Please refer below query

SELECT <%RESULTS%>

FROM <%SCHEMA%>.FCI_CONTRACT T2

LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_VALUE_LIST_VALUE T6

ON T2.STATUS_OBJECT_ID= T6.OBJECTID

LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_VALUE_LIST_TYPE T5

ON T6.PARENT_OBJECT_ID= T5.OBJECTID

WHERE T2.INACTIVE=0 AND T2.STATUS_OBJECT_ID=T6.OBJECTID AND

T6.OBJECTID=?

Jaheer you want filter as drop down or picker?

If drop down refer below screen shot

Please let us know if you need any further assistance.

Regards,

Raj.

[jaheer_hussain · Accepted solution]

Hi Raj,

I want to add owner of master agreement as filter.How to modify this code?

please advise.

with Regards,

Jaheer

[former_member207877 · Accepted solution]

Hi Jaheer,

Please include below query in your respective query so that only the owned agreements will be displayed in report.

WHERE DOC_OWNER_USER_OBJECT_ID =<%CURRENT_USER_ID%>  or

WHERE DOC_OWNER_USER_OBJECT_NAME =<%CURRENT_USER_NAME%>

It will work for sure.

Please let us know if you have need further assistance

Regards,

Raj.

[Former Member · Accepted solution]

Hello!!!

Try out the below syntax:

WHERE <%AND_OP("UPPER(T1.DOC_OWNER_USER_OBJECT_ID)",<%?(parameterName)%>)%>

And add a filter in filter prompt with Object reference type and default value as null:104:null.

Regards,

Vignesh