Question Re: Setting a Default Value for Filter in Fiori Elements using Annotations in Technology Q&A

Setting a Default Value for Filter in Fiori Elements using Annotations

pghoshroy — Tue, 23 Aug 2022 03:59:53 GMT

Hi experts....

I have developed a simple app using Fiori Elements to show products for a particular store. For the app to work the user needs to provide the store or select the store.

As you can see it's a fixed value drop down list that I was able to achieve using the following annotation.

So now my next assignment is to assign a default value to it e.g. store name "ABC"; to save the user time from selecting it. However, the default value must be one from the existing list of stores (i.e. . ZPOS_C_STORE_NAME)

Can anyone advise how I can achieve this using Annotations or by App extension?

So basically, when the app loads; then it should look something like this before I press GO:

The App just uses 2 CDS views one for the complete list of Stores and Products/Material and CDS2 that provides a list of stores (which I am using for the Drop-Down List).

Regards,

Pablo Ghosh Roy

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

Bernard — Tue, 23 Aug 2022 05:38:49 GMT

Hi,

The annotation below should do the trick.

<Annotation Term="Common.FilterDefaultValue" String="ABC"/>

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

pghoshroy — Tue, 23 Aug 2022 05:44:24 GMT

Hi Bernard,

Thank you so much for your response. Can you please advise; how can I retrieve the value "ABC" in this case without hardcoding the value "ABC"?

Do I need to create another CDS View that would only contain the default value "ABC" as a single row and associate it to the main CDS Service?

Regards,

Pablo Ghosh Roy

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

Bernard — Tue, 23 Aug 2022 05:50:14 GMT

It may depend on the store default you want to display.

Is the default store any random valid store?

Or is the store to be displayed a store that is contextually relevant to the user?

(If the latter there is a default value personalisation option)

Just not sure what your intention is here.

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

gregorw — Tue, 23 Aug 2022 06:03:09 GMT

Have you tried the option to save variants? That way you only have to instruct the users once to create such a variant and set it as their default. If not all users should see all stores that you have to solve that using authorizations.

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

MioYasutake — Tue, 23 Aug 2022 12:37:48 GMT

If you want to set default values dynamically, the following blog post may be relevant.

https://blogs.sap.com/2020/08/15/sap-fiori-elements-initial-filter-values/

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

pghoshroy — Tue, 23 Aug 2022 23:40:23 GMT

Hi Bernard,

Thank you again for your response and I apologise if you found my question vague.

The scenario is .... Users will be assigned to a particular store. So, when a user logs onto the app; I must default the value of the store to which the user is assigned to; however, they do have the option to change and see the data for other stores.

e.g. User A, B, C are assigned to Stores 1,2,3. So, when User A opens the app; they can see the value 1 defaulted in the Store; similarly, B will see the value 2 as the store and C will see 3.

Now I have a single CDS view that lists all the materials across all stores. "C_MAT_STOCK_BY_PLANT_CDS"

Then I have another CDS that has the list of store and store names (which forms the Value List). "C_STORE_NAME"

Now I am trying to find a way to default the Store in the Value List/Drop Down. (The relation between the store and user is maintained in a table).

Regards,

Pablo Ghosh Roy

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

pghoshroy — Tue, 23 Aug 2022 23:46:08 GMT

Hi Mio,

Thank you for the link. I have seen that post before; I will revisit to see if it helps.

Regards,

Pablo Ghosh Roy

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

Bernard — Wed, 24 Aug 2022 07:32:37 GMT

You could add an association to your OData service (Consumer CDS view) where you have the user-to-store mapping.

You could then do a Fiori App extension, retrieve the store for the current user and set the relevant filter (i.e. your store filter) to the value retrieved.

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

pghoshroy — Thu, 25 Aug 2022 23:08:51 GMT

Thank You Bernard. Your solution/suggestion worked.

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

former_member822674 — Thu, 06 Oct 2022 14:15:19 GMT

Thanks Bernard.

Re: Setting a Default Value for Filter in Fiori Elements using Annotations

LN1 — Tue, 25 Jun 2024 20:48:35 GMT

Hi Pablo, Would you be able to share the details/steps of your solution that worked? I have a similar requirement but for a filter field that can accept multiple values. The possible values would be dynamic. It could be one value or a hundred of them. These values may come from a db table linked to the current user. Pls advise. Thanks.