I am finding this tooltip guidance a little ambiguous:
Does this mean Boolean AND -- that is, the search returns records having *all* the values selected or checked in the select_multiple? I think so, but need to verify.
And if that's correct, is there any way to get Boolean OR instead? That is, the search returns records having *any* of the values selected or checked in the select_multiple, but any given record may match only a subset of the choices selected/checked?
ALSO -- another question. Further up on the forms configurator, tooltip guidance on select_multiple says:
Must the varchar length be greater than the length of the primary key in the lookup table -- say, if the primary key in the lookup is char(2), and there are 10 unique values of that key, should this variable be set to varchar(20) in the underlying database being configured in DaDaBIK?
Thank you!
There are problems with the Internet connection, we cannot check if there are upgrades available.
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.
mysql version: 8.0.33
Web server: Apache
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.5.1 Safari/605.1.15
please note that when you search a value in a select_multiple_* field using is_equal, you will find records having the selected value for the field (which means only that value or that value AND also other ones if you selected several values).
Does this mean Boolean AND -- that is, the search returns records having *all* the values selected or checked in the select_multiple? I think so, but need to verify.
And if that's correct, is there any way to get Boolean OR instead? That is, the search returns records having *any* of the values selected or checked in the select_multiple, but any given record may match only a subset of the choices selected/checked?
ALSO -- another question. Further up on the forms configurator, tooltip guidance on select_multiple says:
Note that the corresponding database field type must be varchar.
Must the varchar length be greater than the length of the primary key in the lookup table -- say, if the primary key in the lookup is char(2), and there are 10 unique values of that key, should this variable be set to varchar(20) in the underlying database being configured in DaDaBIK?
Thank you!
Your current DaDaBIK version
You are using DaDaBIK version 11.7-Elba enterprise, installed on 09-16-2022 (installation code: 0), the latest version of DaDaBIK isThere are problems with the Internet connection, we cannot check if there are upgrades available.
In case you want to upgrade to a more powerful edition (from Pro to Enterprise/Platinum, from Enterprise to Platinum) please contact us.
System info
PHP Version: 8.1.20mysql version: 8.0.33
Web server: Apache
Client: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/16.5.1 Safari/605.1.15