CAP - Filter initial worklist data

[vode]

Hello together,

I've created on a new CAP project and tried to filter the initial data based on a read operation from our Hana DB. Is it possible to query this "Initial Load" with some parameters.

In the first Step I would like to read parameters from my URL e.g. via

In the next step I would like to query my "Initial Load" from my Hana database, based on these parameters. How can I achieve this? Do I need to code this in my Component.js or my Worklist Controller?

Thanks and best regards,

Dennis

[gregorw]

Are you using Fiori Elements for your UI?

[vode]

Yes, I'm working with Fiori Elements.

[gregorw · Accepted solution]

With Fiori Elements you don't have to create any client side extension. It's supported out of the box to add URL query parameter like in your case ?quoteid=1234 to the URL. If quoteid is the attribute name of your CAP Entity, then the filter should be automatically applied.

But right now there seems to be a bug in UI5 1.108 (LTS) and 1.109. When you run my test application bookshop-demo and try:

http://localhost:4004/webapp/fiori-latest.html#V4Orders-manageUI5latest?OrderNo=1
or
http://localhost:4004/webapp/fiori-ui5-1.108.5.html#V4Orders-manageUI5latest?OrderNo=1

the Orders will not be filtered by the OrderNo 1. But when you try:

http://localhost:4004/webapp/fiori-ui5-1.110.0.html#V4Orders-manageUI5latest?OrderNo=1

you will get a filtered list.