Like a lot of other posts in this forum, I'm trying to use drasticGrid whereby I can create a WHERE clause for the mysql query dynamically. I tried subclassing but that doesn't work when dynamically generated.
I can find no documentation on how to use defaultcolsContainExpression which has some promise. I'm finding some strange behavior though. First of all, it doesn't seem to matter what the first element is of each array condition, even a garbage string of characters, but some thing must be there (EXCEPT in the case below where a substring is being used and the fieldname can be blank???).
In the two examples below I'm trying to use the variable $category in the filter, but with no success:
Even though I'm not using GET it still ignores the $category part of the condition. A print_r($options) shows identical output in both cases. So why doesn't the first one work? And am I using defaultcolsContainExpression as intended?