You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

in my below only getting for india data and one process

Received Response
3
Views
1
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!