in my below only getting for india data and one process
Summary:
Hi sir,
for above query with out put country parameter or process name parameter only geting india and regination process ?
when i scedule the report but i seeing in data in data model .
Could please assit and this issue ?
Content (required):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT A.*
FROM
(
SELECT txnh.module_identifier ProcessName,
wft.creator Requestor,
CAST(wft.assignees as VARCHAR(9)) CurrentAssignee,
wft.assigneesdisplayname CurrentAssigneename,
wft.assigneddate AssignedDate,
wft.title NotificationTitle,
txnd.status TxnStatus,
txnh.object ObjectName,
dp.person_id
FROM fusion.PER_PERSON_SECURED_LIST_V dp,
Tagged:
0