#3931 (ok 4.1.0-beta3) IN Clause search does not permit multiple values

4.0.0
fixed
None
1
2013-12-12
2013-05-14
No

Problems while searching using the in clause. If there is a dropdown for the search column, it does not change to a test column when we select the IN clause.

Run the below sql to create a simple database and 2 innodb tables

create table test.customer(
    id int not null, 
    name varchar(20),
    primary key (id)
)
engine innodb;
insert into test.customer values (1,'foo'), (2, 'bar'), (3, 'baz');
create table test.address(
    id int not null,
    customer_id int not null,
    address varchar(20),
    primary key (id),
    foreign key (customer_id) references test.customer(id)
)
engine innodb;
insert into test.address values(1,1,'abc'), (2,2,'xyz');

Now go to the address table -> search
for column customer_id choose the Operator = IN(..)
The value remains a select option -

it has to change to a textbox option to allow multiple IN clause values

Discussion

  • Hugues Peccatte

    Hugues Peccatte - 2013-11-08

    Hi,

    Would it be ok to have a multiple select in this case please?

    H.

     
  • Marc Delisle

    Marc Delisle - 2013-11-08

    Yes.

     
  • Hugues Peccatte

    Hugues Peccatte - 2013-11-09

    Hi,

    Can I apply this to [NOT] BETWEEN search too ? I think this is relevant.

    Thanks.

     
  • Marc Delisle

    Marc Delisle - 2013-11-10
    • assigned_to: Marc Delisle
     
  • Marc Delisle

    Marc Delisle - 2013-11-10
    • summary: IN Clause search does not change to textbox --> (ok 4.1.0-beta3) IN Clause search does not permit multiple values
    • status: open --> resolved
    • Priority: 3 --> 1
     
  • Marc Delisle

    Marc Delisle - 2013-11-10

    Pull request accepted.

     
  • Marc Delisle

    Marc Delisle - 2013-12-12
    • Status: resolved --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks