最新消息:雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客

tags - Oracle BI Publisher RTF Template: Extract First column with Repeated corresponding column Details in Tabular Format - Sta

programmeradmin0浏览0评论

I'm working with an Oracle BI Publisher RTF template, and I am trying to create a table where the Extract_Person_Number is displayed in the first column, and for each person, their previous employment details (Employer Name and Employment End Date) should appear in subsequent rows. The issue is that when I try to display multiple rows for each person (with the previous employment details), the Extract_Person_Number doesn't show up, even though it should only appear once in the first row.

The XML output that we are using in the RTF template is :

   <DATA_DS>
<G_1>
<PAYROLL_ACTION_ID>28</PAYROLL_ACTION_ID>
<G_2>
<FILE_FRAGMENT>
<XX_Psft_Intg_POC_2>
<REP_CATEGORY_NAME>XX Psft Intg POC 2</REP_CATEGORY_NAME>
<parameters>
<request_id>300000004769531</request_id>
<FLOW_NAME>sk 4</FLOW_NAME>
<legislative_data_group_id/>
<effective_date>2025-03-04</effective_date>
<start_date/>
<report_category_id>300000004769405</report_category_id>
<action_parameter_group_id/>
</parameters>

<Person>
<Person>
<Extract_Person_ID>10002984082</Extract_Person_ID>
<Extract_Person_Effective_Start_Date>2024-10-22T00:00:00.000Z</Extract_Person_Effective_Start_Date>
<Extract_Person_Number>81</Extract_Person_Number>
<Extract_Person_Primary_EMail_ID>10002984085</Extract_Person_Primary_EMail_ID>
<Extract_Person_System_Person_Type>PWK</Extract_Person_System_Person_Type>
<Person_Full_Name>Last407, First407</Person_Full_Name>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name>Prev Empl Emplr Name 1</Extract_Previous_Employment_Employer_Name>
<Extract_Previous_Employment_End_Date>2024-10-27T00:00:00.000Z</Extract_Previous_Employment_End_Date>
<Extract_Previous_Employment_Name>Prev Empl Name 1</Extract_Previous_Employment_Name>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name>Prev Empl Emplr Name 2</Extract_Previous_Employment_Employer_Name>
<Extract_Previous_Employment_End_Date>2029-10-27T00:00:00.000Z</Extract_Previous_Employment_End_Date>
<Extract_Previous_Employment_Name>Prev Empl Name 2</Extract_Previous_Employment_Name>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
</Person>
</Person>
<Person>
<Person>
<Extract_Person_ID>10002588238</Extract_Person_ID>
<Extract_Person_Effective_Start_Date>2024-09-11T00:00:00.000Z</Extract_Person_Effective_Start_Date>
<Extract_Person_Number>78</Extract_Person_Number>
<Extract_Person_Primary_EMail_ID>10002588241</Extract_Person_Primary_EMail_ID>
<Extract_Person_System_Person_Type>PWK</Extract_Person_System_Person_Type>
<Person_Full_Name>Thumb, Tom</Person_Full_Name>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name>1 name only</Extract_Previous_Employment_Employer_Name>
<Extract_Previous_Employment_End_Date>2024-10-20T00:00:00.000Z</Extract_Previous_Employment_End_Date>
<Extract_Previous_Employment_Name/>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
</Person>
</Person>
<Person>
<Person>
<Extract_Person_ID>10002930812</Extract_Person_ID>
<Extract_Person_Effective_Start_Date>2024-10-20T00:00:00.000Z</Extract_Person_Effective_Start_Date>
<Extract_Person_Number>51</Extract_Person_Number>
<Extract_Person_Primary_EMail_ID>10002930815</Extract_Person_Primary_EMail_ID>
<Extract_Person_System_Person_Type>PWK</Extract_Person_System_Person_Type>
<Person_Full_Name>Last402, Last402</Person_Full_Name>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name/>
<Extract_Previous_Employment_End_Date/>
<Extract_Previous_Employment_Name/>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
<PrevExp>
<PrevExp>
<Extract_Previous_Employment_Employer_Name/>
<Extract_Previous_Employment_End_Date/>
<Extract_Previous_Employment_Name/>
<Extract_Previous_Employment_Person_Id/>
</PrevExp>
</PrevExp>
</Person>
</Person>
</XX_Psft_Intg_POC_2>
</FILE_FRAGMENT>
</G_2>
</G_1>
</DATA_DS>

Expected Output:

Person Number Previous Employment Employer Name Extract Previous Employment End Date
81 Prev Empl Emplr Name 1 2024-10-27T00:00:00.000Z
Prev Empl Emplr Name 2 2029-10-27T00:00:00.000Z
78 1 name only 2024-10-20T00:00:00.000Z

与本文相关的文章

发布评论

评论列表(0)

  1. 暂无评论