Hello Josh,
Thanks a lot for your support.
The report should provide the following information:
Task ID
Assigned To
Created By
Current Step Name
Form Name
Date/Time of Creation
So the query that i'm using is:
SELECT DISTINCT T0.id as 'TaskId','|' as 'DIV1',
T4.canonicalname as 'AssignedTo','|' as 'DIV2' ,
T5.canonicalname as 'CreatedBy','|' as 'DIV3',
T0.step_name as 'step_name','|' as 'DIV4',
T0.instructions as 'instructions','|' as 'DIV5',
T2.create_time as 'create_time','|' as 'DIV6',
T2.complete_time as 'complete_time', '||' as 'DIV7'
FROM lc_db_usr.tb_task T0
INNER JOIN lc_db_usr.tb_assignment T1 ON (T0.current_assignment_id = T1.id)
INNER JOIN lc_db_usr.tb_process_instance T2 ON (T0.process_instance_id = T2.id)
INNER JOIN lc_db_usr.tb_queue T3 ON (T1.queue_id = T3.id)
INNER JOIN lc_db_usr.EDCPRINCIPALENTITY T4 ON (T3.workflow_principal_id = T4.id)
INNER JOIN lc_db_usr.EDCPRINCIPALENTITY T5 ON (T2.creator_id = T5.id)
WHERE (T0.status IN (2,3,4) AND T0.process_name = 'XYZ' AND T2.status = 1) order by T4.canonicalname
*Please have a look at the query. If you find any other better query please suggest me. I'll be greatful.
The problem is not with the form it seems. I'll summarize what i'm doing.
-> Using queryMultipleToXML i'm fetching data from the database.
-> Assigning it to an XML variable A (output of queryMultipleToXML).
-> In the next step, i'm assigning this A to a binded string variable of the form B(text box) using setValue service. Later when displaying the form i'll use this rawvalue of B and populate the table.
Then the form gets displayed. Query is fetching data properly('test' is showing proper data).
The problem might be in mapping/binding as i'm mapping XML to a string. Everything is looking fine but the output is not being displayed. :(
Thanks
Deepak