Developer forum

Forum » CMS - Standard features » Sorting in Query Publisher [New Index]

Sorting in Query Publisher [New Index]

E-mail notifications
Adrian Ursu
Reply
Posted on 31/05/2016 13:50:16

Hi Guys,

I have a new index, built using SQL Index Builder.

I am publishing the result using Query Publisher.

I have not figured out how to sort the results. I have defined 2 default sorting criterias in the Query definition but I am not sure how to use them in the front-end.
I have tried this:

/serial-number-search?SerialNumber=1UJCJSCV3A1AA0050&sortBy=Description&SortOrder=DESC


SerianNumber is the Search Criteria and the Description is one of the implicit sorting fields.

Thanks,
Adrian


Replies

 
Nicolai Høeg Pedersen
Posted on 31/05/2016 14:11:41
Reply

Hi Adrian

I do not think you can control the sorting from querystring. That is only possible in Ecommerce because the catalog publisher handles that.

BR Nicolai

 
Adrian Ursu
Posted on 31/05/2016 14:27:29
Reply

Can I try to sort using Linq?

Do you plan on adding this to future releases?

Thanks,

Adrian

 
Nicolai Høeg Pedersen
Posted on 31/05/2016 15:13:43
Reply

Linq would not work since you only get one page of the results in the query publisher at the time.

I'll add the request to the backlog and we will take a look at it later.

BR Nicolai

 
Adrian Ursu
Posted on 31/05/2016 16:18:14
Reply

Thanks.

I realized that after sending the question :)

I have found a work around. I am using 4 separate queries (presorted) and I am loading the paragraphs according to the query string.

Not pretty, but it does the job.

Thanks,

Adrian

 

You must be logged in to post in the forum