Looping through pxResults and set the property to table column title and Value to rows of a table
Can someone tell me how can I achieve the below?
I have a requirement to loop through the pxResults, and populate a table with the values. The property name should be the header of the columns of a table and the corresponding values as rows of the table. Also, based on the class, the properties on pxResults will differ and therefore the table structure. So the table has to be dynamically created.
Example- if I have .pxResults(1) =
|
Can someone tell me how can I achieve the below?
I have a requirement to loop through the pxResults, and populate a table with the values. The property name should be the header of the columns of a table and the corresponding values as rows of the table. Also, based on the class, the properties on pxResults will differ and therefore the table structure. So the table has to be dynamically created.
Example- if I have .pxResults(1) =
and pxResults(2) =
Then the table should be dynamically be built like
| pyName | pyValue |
| Bar | BAR |
| Fieldset | OUTLINE |
Accepted Solution
Updated: 3 Mar 2021 10:30 EST
Rulesware
PE
If I understood what you need, then I don't know how to do it using only a normal table in a normal section.
My approach is to create an HTML section using JSP to create the <table>.
First, you will need a list of the columns you need in the table. You can get it using a java step.
Second, you will need the HTML section using JSP.
Watch the video I've made. Tell me if this is what you need.
ING
NL
@MarcLasserre_GCS Yes, I am using a select query, and I have my results in a pagelist.pxResults.
How to acheive it? I would like to create the table dynamically. I dont have fixed columns and column headers, based on the query the column headers would differ. The above is just an example.
Accepted Solution
Updated: 3 Mar 2021 10:30 EST
Rulesware
PE
If I understood what you need, then I don't know how to do it using only a normal table in a normal section.
My approach is to create an HTML section using JSP to create the <table>.
First, you will need a list of the columns you need in the table. You can get it using a java step.
Second, you will need the HTML section using JSP.
Watch the video I've made. Tell me if this is what you need.