Query-workflow pending approval

[jaheer_hussain]

Hi,

In the below query I want to two add filters(owner and phase as prequalification).Can some one  throw light on this,please?

SELECT <%RESULTS%>

FROM FCI_WORK_REQUEST T1 INNER JOIN

FCI_WORK_ENGINE_STATE T2 ON T1.NATIVE_ID = T2.NATIVE_ID INNER JOIN FCI_WORK_ITEM

T3 ON T1.NATIVE_ID = T3.NATIVE_ID

WHERE

T1.CONTEXTID=<%CONTEXT(workflow.workitem)%> AND

T3.INACTIVE=0 AND

T1.PHASE_SUB_REF_OBJECT_NAME IN ('Waiting for Executive Approvals', 'Waiting

for Executive Approval','Pre Qualification')

AND

FCI_DATEDIFF(T2.CREATED_AT_DATETIME,<%TODAY%>,16) >= 0

AND

T1.DOCUMENT_REF_CLASS_ID = 2002

GROUP BY T1.DOCUMENT_REF_OBJECT_NAME,

T1.ROOT_PARENT_OBJECT_NAME, T1.PHASE_SUB_REF_OBJECT_NAME,

T2.CREATED_AT_DATETIME, T1.NATIVE_ID, T2.CREATED_AT_DATETIME,

T3.PERF_GRP_OBJECT_NAME

with Regards

Jaheer...

[Former Member]

Hi Jaheer,

With the above query, only Phase filter can be created. You havn't mentioned anything about which owner you are refering to?

Phase Filter:

• Include PHASE_SUB_REF_OBJECT_ID = ? in where clause.
• In Filter prompt, create a filter with Date Type as Value List  and Value list Type as Contract Document Phase.

Hope it helps!!!

Regards,

Vignesh

[jaheer_hussain]

Hi Vigneshwar,

Thank you.How to filter owner of master agreemnet in this aboave query?

With Regards,

Jaheer