Search with order by

Hi,

If you double click on column headers in aurena then it will arrange the data in ascending or descending order.

But I want to search on several columns and do order by on several columns not just one column

Would the usability and performance  be increased or decreased if the user can control the order by when executing the sql query to populate a client?

In the present solution to my knowledge:

1. Open the client
2. Press search
3. Use filter to do the order by 

In my vision:

1. Open the client
2. Add order by expression 
3. press search 

Hello,

an intermediate solution is to add manually the search statement like this :

 https://blabla.corpnet.ifsworld.com:48080/main/ifsapplications/web/page/CustomerOrderInvoice/Form;path=0.995139193.2111510127.1804377322;$filter=%28startswith%28tolower%28Identity%29,'cli_adjefr'%29%29;$orderby=InvoiceNo%20desc;record=KENvbXBhbnk9J1RFU1QnLEludm9pY2VJZD04NjYp

User friendly:-)

Hi @gope,

If it’s a commonly needed Order By criteria, then you can add that in the page designer so the order by will be added by default when user performs a search

Hope it helps!

Damith

What version of IFS Cloud are you on?

Hi @gope This is in 22R2 but this feature was there from Apps10 as I remember.

Regards,

Damith

When you write App 10 do you think it was forgotten in the version we running?

Have this version 

I don’t have the Order By option

Hi @gope 

Click on the 3 dots, you’ll find it ;)

Below is from 22R2 but it should be available in 22R1.

Regards,

Damith

So right :-)

Unexperienced web user don’t see the dots. :-)

I see that you have an option Field ranking what does that do?  

Vertical or Horizontal dot’s or Show more

What’s the hidden message?

I’m not sure when the field ranking is added in page designer, since you don’t have it, it should be in 22R2.

Check following F1 documentation link for more information.

Client Control Properties List - Technical Documentation For IFS Cloud

Regards,

Damith

If my perception of this option is that it’s not applicable on all clients am I missing some dots again would you say @dsj? 

i look in the Inventory Transaction History and it looks like this

You are in the correct place. May be a caching problem? try refresh meta data and projection cache and try again ;)

How to clear Aurena Metadata, Projection and Lobby caches? | IFS Community

Here’s how I see the Inventory Transaction History

@dsj  I didn’t managed to clear the cash in Edge so I changed to Chrome and then it worked :-)

@dsj using context is a way of getting a default order by that is for everybody, right?

If different people wants different order by this is not an option, right?

Unfortunately, that’s the only way I found out to achieve this. It’s not possible to set sort order in the search as we did in IEE. 

@dsj Would you vote for IFS to add a Advanced search option in Aurena like it was in IEE?

I'm fully agree with you, it would be natural to have it in the search panel. On the other hand, OrderBy is supported by OData and it should be possible to do use odata operations in the search ;)

Regards,

Damith