Searching, Grouping, Aggregation,Filtering in LIST UIBB

List UIBB in Floorplan Manager provides many general  functions like searching, filtering, grouping and aggregating which can business use in many ways. The below post includes all such functions.

Firstly Lets create a list UIBB and then adopting each function one by one.The list UIBB displays SFLIGHT data.

We have the table type for SFLIGHT structure.

Create a feeder class and implement the interfaces.

Implement and activate all methods. Put the code in GET_DEFINITION & GET_DATA method.

Create an OVP application by using Tx- FPM_WB

Provide page title, add list uibb.

Provide the feeder class.

Add fields as necessary.

Test the application.

So here we have the list uibb with SFLIGHT table data. We have just enabled the Personalization and Export to data sheet buttons.

---

---

Go to the UIBB configuration. As high lighted there is something called – MAXIMIZE BUTTON.

Check the Maximize Button and Save and now test the application.

So here the Maximize Button appears on the list uibb. Click the maximize button.

The List uibb is expanded and more number of records display and the maximize replaced with minimize button or restore button. Click the minimize/restore button.

So the list appears as usual.

---

---

let’s explore more about the search function.

From the dropdown choose -Search as Filter(GUIBB Toolabr).

Save the settings and test the application.

Here the Search Function appears on the list header. Click the Search function button.

As we have selected search function as Filter. It apperas.

Search for any carrid and hit enter key. The list is filtered with only those carrid value. Check the number of entries displayed on list uibb decreased.

Filter can be based on generic column value not a particular column value. Try with connid value and the list is filtered .

---

---

This time set the search function as – Search as Find.

Save the settings.

test the application.Click on Search Function button.

The search as find box appears.

Search for something i.e carrid value and it shows where the records appears in the list but the list remains as it is .

---

---

Let’s try the sorting and aggregation part. In the GET_DEFINITION method of the list feeder class provide the highlighted codes as marked below. Sorting is allowed for CARRID field and Aggregation is allowed for PRICE field.

Go to the list uibb configuration. Currently the Sorting/grouping is disabled.

Make it as – SORT- COLUMN HEADER.

Save and test the application.

For the field- CARRID the sorting option appears.

Choose Ascending or Descending and the LIST is sorted accordingly.

Make the Sorting/Grouping as – Sort & Group – Column Header. Save and test the application.

Sorting option appears for the CARRID field and Choose as Group.

So teh list is grouped by CARRID values.

We can ungroup as well.

Choose Custom Sorting.

Choose as Ascending and select as GROUP COLUMN.

Some new things appears. just make it ok.

So the list appears as follows.

Again go to the custom sorting .

Select the Hide Count in Grouping Header.

The hit number for each CARRID is hidden.

Select hide column label in grouping header.

It disappears.

Clear the custom sorting.

The list appears as simple.

---

---

Go to the GUIBB Settings and choose Default Sorting/grouping.

The below pop up appears.

Choose – Sort by as CARRID. 

Select Collapse Occurs on application start. OK.

Choose Default Aggregation.

The below pop up appears.

Provide field as PRICE and OK.

Save the settings and test the application. The the list appears as follows with Aggregation on Price based on CARRID group.

Change the Default Sorting/Grouping.

Save it.

Test the application. The list appears with out collapsed.

---

---

Lastly about Filtering. Put the below highlighted code in GET_DEFINITION method.

Go to the UIBB configuration.

Change the filtering as Column Header. Save and test the application.

So here the filtering option appears for the CARRID field.

---

---