Re: [MarkLogic Dev General] Dynamic order by

Asitmohan Nautiyal Mon, 04 May 2015 23:19:47 -0700

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] [[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] <[email protected]> on behalf of Asitmohan Nautiyal <[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>

<columnAlias>AgreementType</columnAlias>

</sorting>

<columnAlias>CollectionNo</columnAlias>

</sorting></a>

let $results :=

<title>Currency</title>

<title>AgreementType</title>

<title>CollectionNo</title>

</columns>

<Currency>US dollar</Currency>

</result>

<Currency>Pound sterling</Currency>

</result>

</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] [[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>

<columnAlias>AgreementType</columnAlias>

</sorting>

<columnAlias>CollectionNo</columnAlias>

</sorting></a>

let $results :=

<title>Currency</title>

<title>AgreementType</title>

<title>CollectionNo</title>

</columns>

<Currency>US dollar</Currency>

</result>

<Currency>Pound sterling</Currency>

</result>

</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.

----------------------------------------------------------------------------------------------------------------------------------------------------

_______________________________________________
General mailing list
[email protected]
Manage your subscription at: 
http://developer.marklogic.com/mailman/listinfo/general

Re: [MarkLogic Dev General] Dynamic order by

Reply via email to