on 08-25-2014 10:09 AM
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...
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:
Hope it helps!!!
Regards,
Vignesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.