DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

Welcome! Log In Create A New Profile

Advanced

Wildcards

Posted by ryarkiv 
Wildcards
December 11, 2018 12:55AM
I used to put wildcards into my "contains" searches in earlier versions of Dadabik.
It seems not to function any more. Solutions?
Re: Wildcards
December 12, 2018 03:24AM
Hello,
can you provide an example of the string you used to type?

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Wildcards
December 12, 2018 12:44PM
I have used % for several letters and _ for one letter.

"Pe_er" can give Peter and Peder (same name in danish, but alternatively spelled)

"%ristian" can give Christian and Kristian (same name in danish, but alternatively spelled)

Examples are legio when working with names in databases.
Re: Wildcards
December 13, 2018 01:58AM
Hello,
if you look at the old dadabik documentation, you will find this:

Searching values containing % or _ using the "contains", "starts with" or "ends with" conditions could lead to wrong search results.

Wildcards were never officially supported and the behaviour you described was not intended, at some point (dadabik 8.3) the bug (or maybe from your point of view, the feature) has been fixed and since then % and _ are considered normal characters.

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Wildcards
December 13, 2018 05:14AM
You are right.
From my point of view it was a brilliant feature. I never noticed any wrong results and wildcards like % and _ are commonly used on the net (libraries).

Thanks for the explanation.
Re: Wildcards
December 13, 2018 11:24AM
In most of the cases, the final users of a DaDaBIK app don't know about wildcards and they expect that a search for % returns records containing %.
It might be an optional feature we can easily add, though.

Best,

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Re: Wildcards
December 13, 2018 12:18PM
Please do add it in the future.
It would do much difference to my work.
Sorry, only registered users may post in this forum.

Click here to login