ng-grid filter per column

[Pieter Herroelen]

Hi,

Is there something foreseen in ng-grid to allow for per-column filtering? This was also asked in this thread, but not answered.

Thanks in advance,

Pieter

[Tim Sweet]

the built in search function provides a per-column filtering by specifying "Column Name : SearchVal" (and multiple column/value pairs with a semicolon delimiter). otherwise if the workbench portion of the grid source tree, you will see a header cell filtering mechanism example. 

[Pieter Herroelen]

Found it! (https://github.com/angular-ui/ng-grid/blob/master/workbench/index.html). I'll figure it out from there.

Thanks for the help,

Pieter

[Brad Rice]

I'm interested in doing this, too, Pieter. If you have a simple
example to Plunker or JS Fiddle when you discover, I would appreciate
it. I'll do the same if I figure it out.

> --
> You received this message because you are subscribed to the Google Groups
> "AngularJS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to angular+u...@googlegroups.com.
> To post to this group, send email to ang...@googlegroups.com.
> Visit this group at http://groups.google.com/group/angular?hl=en-US.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>



--
Brad Rice
brad...@gmail.com
~
Do all that you can to live in peace with everyone. Rom 12:18 NLT

[Brad Rice]

I actually got it to work. This is basic.

http://plnkr.co/edit/kcgoXx

I'm still deciding if I need to have filtering work on the search with
the pull down. Right now I am setting the pulldown to undefined if you
start typing a search term and vice versa.

[Pieter Herroelen]

Hi Brad,

Have you looked at https://github.com/angular-ui/ng-grid/blob/master/workbench/index.html ? I don't know if it's hosted somewhere, I just cloned the repo and ran it locally. 

Anyway, it does what I need: an input field in the header of each column, filtering based only on the content of that column. Behind the scenes, it builds the string you would have written in the search box ("Column Name : SearchVal; Column Name2 : SearchVal2;..."), like Tim described earlier.

Best regards,

Pieter

[Timothy Sweet]

Just a heads up, you can also use regular expressions in those search
expressions. this is useful if you want to build excel style filtering
above the columns (contains, equals, starts with, ends with etc..)


On Fri, Mar 1, 2013 at 8:53 AM, Pieter Herroelen

> You received this message because you are subscribed to a topic in the
> Google Groups "AngularJS" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/angular/aC24cVln4Vw/unsubscribe?hl=en-US.
> To unsubscribe from this group and all its topics, send an email to

> angular+u...@googlegroups.com.
>
> To post to this group, send email to ang...@googlegroups.com.
> Visit this group at http://groups.google.com/group/angular?hl=en-US.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>



--

-Tim Sweet

[Brad Rice]

That's great. It appears the default must be contains, because if I
search using partial text, it returns something.

[Brad Rice]

Is there a way to filter on just two columns of a grid with the same text. I've figured out how to filter on a per column basis, but what I would like to do is filter on two columns with the same input.

var searchQuery = 'college:' + collegeText + ";" + 'curriculumName:' + $scope.filterText + 'department:' + $scope.filterText + ';';

Doesn't seem to work. I have to remove either department or curriculumName to get a result. Apparently, it thinks it needs to find it in both columns to return a result.

[Timothy Sweet]

You're forgetting a ; after the curriculum query before department.

[Brad Rice]

Unfortunately that didn't work I console.logged it to the screen:

curriculumName:3150;department:3150;

It appears it needs to find it in both columns rather than just one to
give me a return. If I type in Chemistry, I get something back because
it is in both columns, but if I type something unique in to a column I
get nothing in return.

Brad Rice
brad...@gmail.com
~
“So many books, so little time.” - Frank Zappa

[Timothy Sweet]

you can also use regular expressions in the queries

[Victor Hooi]

Hi,

Did the per-column filtering example disappear recently?

I just checked-out from Github, and opened up workbench/index.html, and there isn't any per-column filtering? (Also tried serving up through local webserver, in case that was it - also no go).

Cheers,

Victor

[Pieter Herroelen]

Hi,

The commit I checked out when it was still there is https://github.com/angular-ui/ng-grid/commit/3802cb1b4b589fbb0610d68168986d5c0aef6877

Best regards,

Pieter

[CG]

I've been having a lot of trouble with this... I found what I think is the relevant code chunk in workbench/index5, but that demo is totally broken for me so I can't figure out where the filtering is actually occurring.

I'm trying to get filter-by-column working (just for the first column, at the moment) and am clearly doing something very wrong. Can anyone help? http://plnkr.co/edit/70MMFWS6YJSyi4xHQroh?p=preview

Thank you SO much!!

[Brad Rice]

Try this on line 76

$scope.filterText = "campaign: " + searchText + "; ";

--

You received this message because you are subscribed to a topic in the Google Groups "AngularJS" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/angular/aC24cVln4Vw/unsubscribe?hl=en-US.
To unsubscribe from this group and all its topics, send an email to angular+u...@googlegroups.com.
To post to this group, send email to ang...@googlegroups.com.
Visit this group at http://groups.google.com/group/angular?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

Brad Rice
brad...@gmail.com
~
“God has promised pardon to your conversion; He has not promised a tomorrow to your delay.” - Augustine

[CG]

Well that fixes the errors (thanks!!) but it searches both columns. I type in "print" and instead of getting no results, like i should were I only searching the "campaigns" column, I get all the channel = print results. Any ideas?

[Brad Rice]

I've banged around on it and can't figure it out. I wonder if something has changed with column search in the latest version because it isn't working for me.

[CG]

Thank you for trying! For the time being, I've opened an issue, hopefully I'll figure it out. I highly suspect something is wrong, given that most of the 9 demos packaged with ng-grid don't even render for me.

[Brad Rice]

This is very bizarre to me, but I found if I take filterOptions out of the gridOptions and set it separately on the scope it works. Here is my fork:

http://plnkr.co/edit/r9qdT3?p=preview

On Thu, May 9, 2013 at 1:38 PM, CG <cge...@gmail.com> wrote:

Thank you for trying! For the time being, I've opened an issue, hopefully I'll figure it out. I highly suspect something is wrong, given that most of the 9 demos packaged with ng-grid don't even render for me.

--

You received this message because you are subscribed to a topic in the Google Groups "AngularJS" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/angular/aC24cVln4Vw/unsubscribe?hl=en-US.
To unsubscribe from this group and all its topics, send an email to angular+u...@googlegroups.com.
To post to this group, send email to ang...@googlegroups.com.
Visit this group at http://groups.google.com/group/angular?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[CG]

Brad, thanks! I've actually gotten some more info by posting an issue on ng-grid - explaining the difference between $scope.gridOptions.filterOptions.filterText and $scope.filterText. I've still got a long way to go, but this is a start!

[code solver]

to hide/show specific columns in ng grid you can use columnsDef property of ng grid

for example see: hide-columns-in-ng-grid-angularjs