How to filter for multiple values at a time

Asked Nov 02 '16 at 17:24

Active Nov 02 '16 at 20:54

Viewed 275 times

Currently I'm working on Datatable. I am trying to create a dropdown filter. But as I am using fetching data from db, in the option field there will be multiple values. is it possible to match array of values on clicking selecting a particular item from list?

For example consider the code below.

    $('#mySelect').on('change',function(){
         var selectedValue = $(this).val();
         table.fnFilter("^"+selectedValue+"$", 0, true); //Exact value, column, reg
          });


    select: <select id="mySelect">
              <option value="">All</option>
              <option value="array1">a</option>
              <option value="array2">saf</option>
            </select>

and actual scenario here.

I have a drop down list of vendor.
I will fetch the items corresponding to each vendor from db table.
Each vendor may have more than one item.
Upon selecting the vendor name from the list, it has to filter corresponding items from Datatable.

so, <option value="item_code">vendor_name</option>

it's ok if only one item exist for the particular vendor. What if multiple items present? So i thought to store item_codes in an array and pass it value for filter. But how to make it works?

Or any other alternate ideas will be appreciated.

edited Nov 02 '16 at 20:54

Mamdouh Saeed

2,302
1
9
11

asked Nov 02 '16 at 17:24

techhunter

Do you mean that if selected option equal to item of an array? – Mamdouh Saeed Nov 02 '16 at 19:13
Updated question. – techhunter Nov 02 '16 at 19:36
Do you want to filter based on specific column on the table ? – Mamdouh Saeed Nov 02 '16 at 20:04
ye @MamdouhFreelancer. that can be done here by passing column number. What exactly I need is how could I pass multiple values to value attribute of option. – techhunter Nov 02 '16 at 20:05
is this fiddle good example to work with ? https://jsfiddle.net/2j6w9hqt/2/ – Mamdouh Saeed Nov 02 '16 at 20:07
Ok Sure. I found one way i.e but it's not suitable for me since i dont know the value before it fetched from db. – techhunter Nov 02 '16 at 20:15
See this https://jsfiddle.net/MamdouhFreelancer/2j6w9hqt/7/ – Mamdouh Saeed Nov 02 '16 at 20:15
I'm there.....! – Mamdouh Saeed Nov 02 '16 at 21:03
Have you found a solution yet? if not I can help – Rajshekar Reddy Nov 03 '16 at 09:27
@Reddy not yet found the solution. – techhunter Nov 03 '16 at 09:33
@safoorasafu so the requirement is you need to do a search on the datatable on multiple values.. Like if any one value in the array matches with any data of the row you need to display it right? – Rajshekar Reddy Nov 03 '16 at 12:18
Yes. Exactly the same. Multiple values in array and each value has to be matched with my first column itemcodes. – techhunter Nov 03 '16 at 12:30
This may give you a good place to start: http://stackoverflow.com/questions/5686735/populate-one-dropdown-based-on-selection-in-another – DevlshOne Nov 03 '16 at 12:52

How to filter for multiple values at a time

0 Answers0

Linked