v1.6 - Operator Select - All/Any??

A

Ap.Muthu

Guest
When we have Boolean Field - ENUM ("Yes","No") type, the search form yields a default operator drop-down combo -> Excatly, Like, <, >.
It is often required to have an Any or All option. The temporary hack for v1.6 is:-
In the file include/general_functions.php, Insert the following two lines at Line 74:-
$operator_select .= "<option value=\"<\"><=</option>";
$operator_select .= "<option value=\"<\">>=</option>";
 
E

Eugenio

Guest
Ap.Muthu wrote:
>
> When we have Boolean Field - ENUM ("Yes","No") type, the
> search form yields a default operator drop-down combo ->
> Excatly, Like, <, >.
> It is often required to have an Any or All option. The
> temporary hack for v1.6 is:-
> In the file include/general_functions.php, Insert the
> following two lines at Line 74:-
> $operator_select .= "<option value=\"<\"><=</option>";
> $operator_select .= "<option value=\"<\">>=</option>";

I don't understand your message, you're talking about adding >= <= operators for searching a data field?
You also have probably missed a "=" sign in the value of the option.

What about Any/All option? This option already exists.

(Latest version of DaDaBIK when this message was posted: 1.6)
 
A

Ap.Muthu

Guest
I am using the latest version 1.6.
>= means Greater Than or Equal To
<= means Less Than or Equal To

Lines needed:-
$operator_select .= "<option value=\"<\"><=</option>";
$operator_select .= "<option value=\"<\">>=</option>";

By adding the abovesaid lines into the general_functions.php file at Line 74, we enable it's availability for the internal table:-
Exactly/like/</>/<=/>=
will give the following in the drop-down box of search:-
Exactly
like
<
>
<=
>=

How does one implement Any / All option in the search form for a combo-box : select_single type?
 
E

Eugenio

Guest
Ap.Muthu wrote:
>
> I am using the latest version 1.6.
> >= means Greater Than or Equal To
> <= means Less Than or Equal To
>
> Lines needed:-
> $operator_select .= "<option value=\"<\"><=</option>";
> $operator_select .= "<option value=\"<\">>=</option>";
>
> By adding the abovesaid lines into the general_functions.php
> file at Line 74, we enable it's availability for the internal
> table:-

No!!
That part of the code refers only to the operators I use for date fields; and you also have probably missed a "=" sign in the value of the option.

If you want to add >=/<= for all the other field types you have to put them directly in the internal table (select_type_field), but I've never tried this hack, so I'm not sure if it works or not.

> How does one implement Any / All option in the search form
> for a combo-box : select_single type?

Any/All option means "or"/"and", and it already works also for select_single type.

(Latest version of DaDaBIK when this message was posted: 1.6)
 
A

Ap.Muthu

Guest
1. Yes the hack works - without the lines 74/75 insertion - we need to insert the values only into the internal table.

2. As for the ENUM field type, we need to set the internal table value to ~~Yes~No~
This way we get a blank first option that works well with exactly to be able to select all entries regardless of the ENUM variabl's status!

3. The checkbox, multiple_select, radio button -> all don't seem to work as they should. In fact they show all records when none are selected, and show none if any are selected!
 
E

Eugenio

Guest
Ap.Muthu wrote:

> 3. The checkbox, multiple_select, radio button -> all don't
> seem to work as they should. In fact they show all records
> when none are selected, and show none if any are selected!

I've replied to you in the other post.

(Latest version of DaDaBIK when this message was posted: 1.6)
 
A

ash

Guest
is there a boolean search added to the new release? AND/OR/Exact Phrase search?
 
E

Eugenio

Guest
ash wrote:

> is there a boolean search added to the new release?
> AND/OR/Exact Phrase search?

The AND/OR feature is already available in the current version, and also the exact phrase (exactly/like).

(Latest version of DaDaBIK when this message was posted: 2.2.1)
 
Top