XML Publisher Heading Suffixed With Date

Jacobelia S · Sep 26, 2017 7:00AM

Hi,

I have included XML with the date.

<?xml version="1.0" encoding="UTF-8" ?>

<Test>

<LIST_G_TEST>

<G_TEST>

<P_START_DATE>18-SEP-2017</P_START_DATE>

</G_TEST>

</LIST_G_TEST>

</Test>

Brajesh Shukla-95078 · Sep 26, 2017 7:00AM

May I know what is the date format used for start date parameter....if you can paste how its appearing in XML it will be great

Jacobelia S · Sep 27, 2017 7:00AM

I will certainly try this approach.

I have a question, is it possible to have column values as headings instead

of typing or manually creating headings in the RTF template?

On 27 Sep 2017 13:42, "community-admin" <community-prod-admin_ww@oracle.com>

Brajesh Shukla-95078 · Sep 27, 2017 7:00AM

Hi,

Since date is in DD-MMM-YYYY format so you can directly go with substr. If its in standard date format i.e. 2000-04-08T20:00:00 then we can go for format-date function

<?xdofx:substr(P_START_DATE,1,Instr(P_START_DATE,'-',1)-1)?>

Jacobelia S · Sep 28, 2017 7:00AM

Thanks for the valuable help.

Brajesh Shukla-95078 · Sep 28, 2017 7:00AM

If I understand correctly...you want table heading populate dynamically instead of hard coded heading?

If this is the case...you can generate your heading in XML data and use in rtf

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

XML Publisher Heading Suffixed With Date

Answers