I try to search my huge user base (40000+ entries) using the reporting API with the following parameters:
but I always get all my users as a result.
The response indeed contains the login column. Actually, it contains these columns:
I tried other columns and patterns without success, filter_column and filter_pattern seem to have no effect.
By the way, filter_limit works as expected.
As a matter of fact, there is no way to search for a user. I really miss a method mirroring SitesManager.getPatternMatchSites for users.
That's a bug indeed. Those filters to currently not work for API's that return an array.
filter_pattern should work with the latest Piwik version though I think. Are you using the latest version (Piwik 2.13.1)?
I use Piwik 2.13.1.
I just had a look. It works if you use
filter_column=^publ. This is a bug as I expected our internal logic here https://github.com/piwik/piwik/blob/2.14.0-b1/core/API/ResponseBuilder.php#L193 would actually convert
filter_column=^publ to an array of
If you need that feature now I recommend to use this workaround until it is fixed.
@mattab I'm not sure re milestone.
It would be nice to make all those filter parameters work on all numeric indexed array returns for Piwik 3.0 but it's most likely not realistic.