Filter by Empty or not empty in search fields in datagrid

1
Hello,   I like to filter data value (empty or not and all other possibility value) in search fields on datagrid. Please help me. I we have a module we can take this functionnality, me take me here name. Thank you  
asked
4 answers
4

Hi Mamdouh,

The grid search widget might be of help here. From the documentation "Any search criteria that can be written in XPath is supported". The xpath constraints you want are 

attribute empty 

[attributeName = empty]

 

attribute not empty

[attributeName != empty]

 

Association empty

[not(​ModuleName.associationName/ModuleName.EntityName)]

​

 

Association not empty

[ModuleName.associationName/ModuleName.EntityName]

 

 

Here is the link to the widget

https://appstore.home.mendix.com/link/app/49364/Mendix/Grid-Search

 

Hope this helps!

 

Edit: The github has a nice example project that show show to configure the AnySearch functionality.

https://github.com/tieniber/GridSearch

The test folder has the example project. In the project search for the page called "Filters". The Any Search tab has the example. 

answered
0

Hi Mamdouh, 

Filtering data is standard functionality on datagrids by adding search fields to the designated area:

But Im guessing your need goes beyond this functionality: what is it you want to do that is not possible using standard search functionality?

 

answered
0

Yes this is standard search functionality. But i like add search (Empty or not datavalue), this is classical in excel.

 

answered
0

Hi Austin I have a problem with Dropdown Dynamic The Multi-Select do not function, but single selection function correctly. Any Idea Please

 

answered