Method Community

Usually, when I enter text at the top of a culumn to filter it, if that text is not in any of the rows, the grid shrinks down to 1 row and is blank

But I have a grid (Activities List) that behaves in the following way instead:

If I type, say, "XXXXX" into the Contact/Name/Company column of an existing grid (with 50 rows showing out of 65 records), nothing appears to happen. All 50 records are still on page 1. And at the bottom left corner of the grid, right next to "Records 50 out of 65", there is text that says "Error Generating Grid"

Please explain. 

Well, after a long search, it turns out the only column that was malfunctioning was the SQL column for Contact/Name/Company.

The code was OK, it's just that in the "Filter Fields(s)" section, there was a comma after the last item. I

The values in the field were "ContactsName,Entity,EntityCompanyName,"

I removed the last comma and everything seems to work. Not really sure how it got in there but...all's well that ends well, I guess.