Question Re: Editable Data Table and Searches in Technology Q&A

Editable Data Table and Searches

Angelo_Ab14 — Mon, 23 Sep 2024 09:30:12 GMT

Hi,

I have two requirement.

The first requirement is to find a smart way to search and add products in a list with over 20K products.

The products list picker have only Live Search and if i need to filter two attribute, for example Brand and Description, this is not possible. The alternative solution is to have cascade list pickers, for example the first one with brands and second one with pre filtered products, unfortunately the customer need a fast way to do this.

The question is, what is the smartest and fast way to search(with more than one attribute), select and add products to the Order ?

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

The second requirement is to have a smart way to add Items to an Order with as little click/tap possible and modify the main attribute of Item in a fast way. This is needed both in mobile(tablet) and desktop app.

I tried to use DataTable in Edit Mode like this with editable Quantity:

Unfortunately this solution doesn't works in Desktop App due to non supported Data Table Control.

How I can manage this ?

Thank you.

Re: Editable Data Table and Searches

panushjain — Mon, 23 Sep 2024 10:12:03 GMT

To answer Q1: An out-of-the-box filter option is available. Users can access the filter action via a button in the action bar or toolbar, which opens a filter page from the list (Object Table) page. On this filter page, users can select their desired criteria, which are then applied to the list page. A clear example can be found in the MDK Demo Application in the sample repository: https://github.com/SAP-samples/cloud-mdk-samples/tree/main/Sample_Applications/MDK_Demo_Application By tapping the "All Products" link under the Promotion Items section in the upper right corner, users can access a Filter button that initiates the filter action, allowing them to effectively choose and apply their selections.

Re: Editable Data Table and Searches

bill_froelich — Mon, 23 Sep 2024 16:01:52 GMT

In addition to the filtering already mentioned you could consider using the Object Table in multii-select mode to let the user pick multiple products and then have a single Add button to add all the selected ones.

When done you could dynamically generate a page of all the items added with the default quantity field pre-populated to allow updates to the quantity values if needed before a final save to the backend (offline or online).

Re: Editable Data Table and Searches

Angelo_Ab14 — Mon, 23 Sep 2024 16:39:34 GMT

Thank you Bill.

You Wrote "you could dynamically generate a page of all the items added with the default quantity field pre-populated".

What this means exactly ?

A page with a Data Table with all the added items and editable quantity column ?

Re: Editable Data Table and Searches

bill_froelich — Mon, 23 Sep 2024 17:10:13 GMT

A page with Editable Data Table would be one option but you also mentioned it not being available on the web client.

Another would be a page of Form Cells or combination of Section/FormCell. I am thinking maybe a title form cell for the item and then a simple property for the quantity pair for each item. Could also include more depending on what you needed to show for each item. Could also do an Object cell followed by a simple property for the quantity for each item. All depends on what you want / need.

You would generate most of the page dynamically based on the selected items and then need a rule on the Save to process all the data accordingly.

Re: Editable Data Table and Searches

Angelo_Ab14 — Mon, 23 Sep 2024 20:42:05 GMT

Thank you Bill for your time. I will try your suggestions. After the tests I will return back for the Accepted Solution.