Hi All,
We need to add CDATA to our xml content. We followed below
approach to add CDATA. But the out is coming as serialized xml, It is
transforming the “<” to “<” and “>” to “>”
Is there any option to get the output xml without the transformation.
Code snippet to add the CDATA:
<text>
{
fn:concat('<![CDATA[', xdmp:quote( <p>{ $description }</p> ), ']]>')
}
</text>
Current Issue:
<description>
<type>product_description</type>
<text><![CDATA[<p>Sample cdata content within para
tag.</p><p>Deep in the heart of a mysterious forest, a Pokemon
named Shaymin stumbles into the midst of a battle between two powerful Pokemon,
Dialga and Giratina. </p>]]>
</text>
</description>
Essentially we need to get rid of this entities and create simple elements like
this below.
<description>
<type>product_description</type>
<text>
<![CDATA[<p> Sample cdata content within para tag.</p><p>Deep in the heart of a
mysterious forest, a Pokemon named Shaymin stumbles into the midst of a battle
between two powerful Pokemon, Dialga and Giratina. </p>]]>
</text>
</description>
Thanks & Regards,
Santhosh
From: [email protected]
[mailto:[email protected]] On Behalf Of Asitmohan Nautiyal
Sent: Tuesday, May 05, 2015 11:49 AM
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Dynamic order by
Hi Pragya,
As per your requirement , you have to use if/else condition. Follow the below
sample algo:
for $each in $results//results/result (: $results//results/result ==> used
// äs you mentioned AgreementType can be at any level or not :)
return
if($each/AgreementType) then
if($sortDirection=""asc"") then
order by $each/AgreementType ascending
else order by $each/AgreementType descending
else $results
Now you can write own logic based on business conditions.
Regards,
Asit Nautiyal
________________________________
From:
[email protected]<mailto:[email protected]>
[[email protected]] on behalf of Kapoor, Pragya
[[email protected]]
Sent: Tuesday, May 05, 2015 9:34 AM
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Dynamic order by
Could someone help on this?
________________________________
From: Kapoor, Pragya
Sent: Monday, May 4, 2015 5:03 PM
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Dynamic order by
Thanks Asit.
But I have different requirement.
In your code :
return if($sorting/sorting/sort) then
for $each in $results//results/result
order by $each/AgreementType descending , $each/CollectionNo ascending
return $each (: modify as per your business requirement :)
else $results
In the order by clause you are using $each/AgreementType, but as mentioned in
the mail the element AgreementType is not static. This value is dynamic
moreover sort direction(asc/desc) is also dynamic.
Thanks
Pragya
________________________________
From:
[email protected]<mailto:[email protected]>
<[email protected]<mailto:[email protected]>>
on behalf of Asitmohan Nautiyal
<[email protected]<mailto:[email protected]>>
Sent: Monday, May 4, 2015 4:40 PM
To: MarkLogic Developer Discussion
Subject: Re: [MarkLogic Dev General] Dynamic order by
Hi Pragya,
try below sample code
let $sorting :=<a> <sorting>
<columnAlias>Currency</columnAlias>
</sorting>
<sorting>
<sort>desc</sort>
<columnAlias>AgreementType</columnAlias>
</sorting>
<sorting>
<sort>asc</sort>
<columnAlias>CollectionNo</columnAlias>
</sorting></a>
let $results :=
<report>
<columns>
<title>Currency</title>
<title>AgreementType</title>
<title>CollectionNo</title>
</columns>
<results>
<result>
<Currency>US dollar</Currency>
<AgreementType>abc</AgreementType>
<CollectionNo>0000050</CollectionNo>
</result>
<result>
<Currency>Pound sterling</Currency>
<AgreementType>xyz</AgreementType>
<CollectionNo>0000048</CollectionNo>
</result>
<result>
<Currency>Euro</Currency>
<AgreementType>ebf</AgreementType>
<CollectionNo>0000049</CollectionNo>
</result>
</results>
</report>
return if($sorting/sorting/sort) then
for $each in $results//results/result
order by $each/AgreementType descending , $each/CollectionNo ascending
return $each (: modify as per your business requirement :)
else $results
Regards,
Asit Nautiyal
________________________________
From:
[email protected]<mailto:[email protected]>
[[email protected]] on behalf of Kapoor, Pragya
[[email protected]]
Sent: Monday, May 04, 2015 3:21 PM
To: MarkLogic Developer Discussion
Subject: [MarkLogic Dev General] Dynamic order by
Hi,
I need to sort the $results based on element columnAlias in $sorting.
for eg :
In the below scenario, I want to first sort the $results with
AgreementType(desc) and then with CollectionNo(asc).If there is not <sort>
element in $sorting/sorting then do not use that element <columnAlias> for
sorting.
Moreover the elements in $sorting & $results will be dynamic and not fixed.
let $sorting :=<a> <sorting>
<columnAlias>Currency</columnAlias>
</sorting>
<sorting>
<sort>desc</sort>
<columnAlias>AgreementType</columnAlias>
</sorting>
<sorting>
<sort>asc</sort>
<columnAlias>CollectionNo</columnAlias>
</sorting></a>
let $results :=
<report>
<columns>
<title>Currency</title>
<title>AgreementType</title>
<title>CollectionNo</title>
</columns>
<results>
<result>
<Currency>US dollar</Currency>
<AgreementType>abc</AgreementType>
<CollectionNo>0000050</CollectionNo>
</result>
<result>
<Currency>Pound sterling</Currency>
<AgreementType>xyz</AgreementType>
<CollectionNo>0000048</CollectionNo>
</result>
<result>
<Currency>Euro</Currency>
<AgreementType>ebf</AgreementType>
<CollectionNo>0000049</CollectionNo>
</result>
</results>
</report>
Thanks
Pragya
"This e-mail and any attachments transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential , proprietary or
privileged information. If you are not the intended recipient, please contact
the sender by reply e-mail and destroy all copies of the original message. Any
unauthorized review, use, disclosure, dissemination, forwarding, printing or
copying of this e-mail or any action taken in reliance on this e-mail is
strictly prohibited and may be unlawful."
::DISCLAIMER::
----------------------------------------------------------------------------------------------------------------------------------------------------
The contents of this e-mail and any attachment(s) are confidential and intended
for the named recipient(s) only.
E-mail transmission is not guaranteed to be secure or error-free as information
could be intercepted, corrupted,
lost, destroyed, arrive late or incomplete, or may contain viruses in
transmission. The e mail and its contents
(with or without referred errors) shall therefore not attach any liability on
the originator or HCL or its affiliates.
Views or opinions, if any, presented in this email are solely those of the
author and may not necessarily reflect the
views or opinions of HCL or its affiliates. Any form of reproduction,
dissemination, copying, disclosure, modification,
distribution and / or publication of this message without the prior written
consent of authorized representative of
HCL is strictly prohibited. If you have received this email in error please
delete it and notify the sender immediately.
Before opening any email and/or attachments, please check them for viruses and
other defects.
----------------------------------------------------------------------------------------------------------------------------------------------------
"This e-mail and any attachments transmitted with it are for the sole use of
the intended recipient(s) and may contain confidential , proprietary or
privileged information. If you are not the intended recipient, please contact
the sender by reply e-mail and destroy all copies of the original message. Any
unauthorized review, use, disclosure, dissemination, forwarding, printing or
copying of this e-mail or any action taken in reliance on this e-mail is
strictly prohibited and may be unlawful."
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged information.
If you are not the intended recipient(s), please reply to the sender and
destroy all copies of the original message. Any unauthorized review, use,
disclosure, dissemination, forwarding, printing or copying of this email,
and/or any action taken in reliance on the contents of this e-mail is strictly
prohibited and may be unlawful. Where permitted by applicable law, this e-mail
and other e-mail communications sent to and from Cognizant e-mail addresses may
be monitored.
_______________________________________________
General mailing list
[email protected]
Manage your subscription at:
http://developer.marklogic.com/mailman/listinfo/general
