Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Display multiple tables based on values from xml

Avatar

Avatar
Validate 1
Level 1
mankuu33664440
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
mankuu33664440
Level 1

Likes

0 likes

Total Posts

13 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
mankuu33664440
Level 1

15-12-2020

Hi, I'm new to livecycle designer. 

We have a requirement of displaying multiple tables from the xml values. 

 

<member_table num=1>

     <name>

    <skills>

        <SKILL1>

        <SKILL2>

        <SKILL3>

   </skills>

</member_table>

<member_table num=2>

     <name>

     <skills>

        <SKILL1>

        <SKILL2>

   </skills>

</member_table>

 

For each member number,

1. I should display member table which has one row with name

2. I should display skill table with all skills listed (this differs from member to member) 

 

 

Approach :

Built member table and skill table in a subform, and used action builder to repeat the subform for every member. I am able to get member table correctly as it has only one row. But skill table is getting with only one row, and first value is getting filled.

 

Please help on how to retrieve all the skills into all the skills tables based on member number. 

View Entire Topic

Avatar

Avatar
Establish
Employee
Kosta_Prokopiu1
Employee

Likes

144 likes

Total Posts

333 posts

Correct Reply

93 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Establish
Employee
Kosta_Prokopiu1
Employee

Likes

144 likes

Total Posts

333 posts

Correct Reply

93 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
Kosta_Prokopiu1
Employee

16-12-2020

There is a reason for that 🙂

You have created a hierarchical data structure and want to consume the data in more than one dynamic subform/table construct. That does not work because the data is gone through once (your member table) and then there is no "Reset" so your skills table are out of data. For that to work you could restructure your XML data like so:

 

<root>
    <member_table>
        <member>
            <number>1</number>
            <name>Name 1</name>
        </member>
        <member>
            <number>2</number>
            <name>Name 2</name>
        </member>
    </member_table>

    <skills_tables>
        <skill_table>
            <number>1</number>
            <name>if required in the skill table</name>
            <skills>
                <skill1>Skill 1</skill1>
                <skill2>Skill 2</skill2>
                <skill3>Skill 3</skill3>
            </skills>
        </skill_table>
        <skill_table>
            <number>2</number>
            <name>if required in the skill table</name>
            <skills>
                <skill1>Skill 1</skill1>
                <skill2>Skill 2</skill2>
            </skills>
        </skill_table>
    </skills_tables>
</root>