next »

[Ernest D.]

Hello, we have some question. The List reduce filter functionality is currently available for searching data in TABLE component.

However, the list reduce filter searches for data within the entire list.
    https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_prog_dialogs_list_filter.html

In competing SW ABRA, we were interested of their solution. Search is possible only in the specific column in which the cursor is located. See the attached link. Are you planning a similar solution?
    https://www.youtube.com/watch?v=Ljh4EQczyVg

In addition, the solution in SW ABRA allows searching in multiple columns at the same time.

Best regards,
Ernest

[Olivier E.]

Hello Ernest,

We would like to define your expectations more precisely.

Attached is a link to a Microsoft Excel screenshot of the Data -> Filter menu.

https://upload.4js.com/sharefiles/2aoqw

The process is:

1 - you select some columns
2- Data -> Filter.   This adds some arrows at the column names.
3- click on one arrow, and you get the windows.

In this window, you can:

* Sort the table regarding this column's values (Ascending or Descending)
* Search and select/unselect in a list of values which one you would like to reduce the table view. (This doesn't affect the totals)


Our question is: Can this fix your problem?

Best regards,

Olivier Eckert - Four Js Support

[Ernest D.]

Hello,

In our opinion, the solution in EXCEL application is complicated.
Try watching the video with the filtering example again.
The video shows, how to enter a condition for a list (TABLE).
https://www.youtube.com/watch?v=Ljh4EQczyVg

1. the user clicks on the column 'Nazev'
2. the column header is highlighted
3. the user writes the first string of the condition "poji"

   https://app.screencast.com/Pb8Cy2NKbsySm

4. if the user confirms the condition (presses ENTER), the condition is applied to the list of values ​​in the table
5. the condition string "poji" is displayed next to the condition entry field

   https://app.screencast.com/pn7YVV5nHZU9c

6. the user clicks on the column 'Mesto'
7. the column header is highlighted
8. the user writes the second string of the condition "praha"

   https://app.screencast.com/dN53fGNXiuYOA

9. if the user confirms the condition (presses ENTER), the condition is applied to the list of values ​​in the table
10. the condition string "praha" is displayed next to the condition entry field

   https://app.screencast.com/OEb1YP2PUY9Vg

The result of entering the conditions in this example is something like:
    name MATCHES "*poji*" AND city MATCHES "*praha*"


Best regards,
Ernest

[Ernest D.]

Hello,

In our opinion, the solution in EXCEL application is complicated.
Try watching the video with the filtering example again.
The video shows, how to enter a condition for a list (TABLE).
https://www.youtube.com/watch?v=Ljh4EQczyVg

1. the user clicks on the column 'Nazev'
2. the column header is highlighted
3. the user writes the first string of the condition "poji"

   https://app.screencast.com/Pb8Cy2NKbsySm

4. if the user confirms the condition (presses ENTER), the condition is applied to the list of values ​​in the table
5. the condition string "poji" is displayed next to the condition entry field

   https://app.screencast.com/pn7YVV5nHZU9c

6. the user clicks on the column 'Mesto'
7. the column header is highlighted
8. the user writes the second string of the condition "praha"

   https://app.screencast.com/dN53fGNXiuYOA

9. if the user confirms the condition (presses ENTER), the condition is applied to the list of values ​​in the table
10. the condition string "praha" is displayed next to the condition entry field

   https://app.screencast.com/OEb1YP2PUY9Vg

The result of entering the conditions in this example is something like:
    nazev MATCHES "*poji*" AND mesto MATCHES "*praha*"


Best regards,
Ernest