Data from collection or report

[vinod...@gmail.com]

Hi

I would like to use data from a report or collection (filtered by query) while generating PDF instead of data from array widget. Request guidance

Regards

Vinod

[Bidisha Das]

Hi Vinod,

Have you followed as mentioned here in Query 2: https://groups.google.com/a/runmyprocess.com/forum/?hl=en&fromgroups=#!searchin/supportforum/Passing$20array$20values$20to$20PDF/supportforum/i2y7HhDMK04/8X8JeawROgAJ

Yes, you can pass report widget data i.e collection data to PDF. Use below script to get all data of report & set it in a variable/text widget(report_data) on Web Interface.

var report_data = id_report.getAllValues();

alert(JSON.stringify(report_data));

RMPApplication.setVariable("report_data",JSON.stringify(report_data));

In process you will get array of JSON(collection data), you can transpose those data to convert to JSON of array and pass it to XSL in the same way you did for array widget and generate pdf.

Use below code in Process: 

<#assign transpose_columns = transpose(report_data)>

{"my_var_main":{"users_array":${transpose_columns}}}

Please try with this & let me know if it worked.

Thanks & Regards

Bidisha

[vinod...@gmail.com]

Hi Bidisha

Thanks for the quick response. I tried as advised but I am getting only one row.

Please find attached the screenshots and XSL file used. Request help

Regards


Vinod

[Pankaj Kumar]

Hi Vinod,

Kindly remove the tranpose of the array as report_data array do not required transposition, it is required in the case of passing data from array widget.

Please try below freemarker for passing array:-

"users_array":${report_data} 

attached is screen-print of the generated pdf using report data.

Thank you,

Pankaj Kumar

Fujitsu RunMyProcess Support

--
Fujitsu - RunMyProcess
---
You received this message because you are subscribed to the Google Groups "Fujitsu RunMyProcess Developer Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to supportforum...@runmyprocess.com.
To post to this group, send email to suppor...@runmyprocess.com.
Visit this group at https://groups.google.com/a/runmyprocess.com/group/supportforum/.
To view this discussion on the web visit https://groups.google.com/a/runmyprocess.com/d/msgid/supportforum/b2ccba48-3149-4ff3-a3da-1c486e22451f%40runmyprocess.com.

For more options, visit https://groups.google.com/a/runmyprocess.com/d/optout.

[vinod...@gmail.com]

Thanks a lot, Pankaj. It worked