I have a table who has a column of surnames - I know a user can search for a character like, for example, a "G" and get a list of all surnames with a "G" or "g" anywhere in the surname.
Users sometimes just want to examine all surname starting with a particular letter like "G".
Is there a way to just search for the 1st char of the surname? Some kind of wildcard filter or a way to apply SQL on the fly using Like or Left or String variables to limit to the 1st char? Any way to make a filter case sensitive?
I thought one approach might be to create an extra hidden column containing just the 1st char of the Surname Column and use it in a filter form.
Any ideas of how to do this would be appreciated - Thank You!
Sorry to disappoint you but unfortunately something like this is not possible with the plugin build in features and it will require some code customization. We can offer you our paid customization service where you can hire one of our developers to implement this feature for you.
I have a table who has a column of surnames - I know a user can search for a character like, for example, a "G" and get a list of all surnames with a "G" or "g" anywhere in the surname.
Users sometimes just want to examine all surname starting with a particular letter like "G".
Is there a way to just search for the 1st char of the surname? Some kind of wildcard filter or a way to apply SQL on the fly using Like or Left or String variables to limit to the 1st char? Any way to make a filter case sensitive?
I thought one approach might be to create an extra hidden column containing just the 1st char of the Surname Column and use it in a filter form.
Any ideas of how to do this would be appreciated - Thank You!
Hi tcghs,
Thank you for your purchase.
Sorry to disappoint you but unfortunately something like this is not possible with the plugin build in features and it will require some code customization.
We can offer you our paid customization service where you can hire one of our developers to implement this feature for you.
If you are interested let us know.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Bogdan
At least you saved me from continuing to search the documentation trying to find a feature that's not there.
Might be worth thinking of adding some kind of more flexible search criteria (wildcard, etc.) in the future.
Mike
Hi Mike,
We have some plans after the stable release of the 2.0 version to release some add ons. One of them is related to some advanced filters.
I will write down your suggestion so I hope that we can add your idea to our add on.
Thank you for sharing some new ideas with us.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables