Using a custom data field as a filter

[abrookins]

Hey all,

Can we use custom data fields in CiviCRM 3.0 with CiviReport by default, or do we need to a write some PHP to make the filter?

Thanks,
Andrew

[Donald Lobo]

In 3.0 we've enabled custom data for the contribution reports

you will need to add code to add custom data to the other reports

lobo

[abrookins]

Lobo,

Thanks for the reply. 

I did see in the contribute report classes that the code now includes custom data fields in the group by and display lists, but that change doesn't appear to offer those fields as filters.

If you add a custom field in the 3.0 demo and make it searchable, that field doesn't show up as a filter in contribute reports, though it is available as a group by and display column. 

We patched the contribute form classes to add custom data fields into the filter list using the same code that adds them to the group by and display columns, and the query building code threw an exception. 

So we made a couple of more small changes and now custom data fields are appearing in the filter list and seem to be working, though at a basic level (string comparisons).  Is filtering on custom data fields a planned feature, or just grouping and displaying those fields?

Andrew

[Donald Lobo]

Not on the current feature list. Would be great if you'll could generalize it so it works for al data/html types and then submit it back as an issue, patch and a unit test!

lobo

[abrookins]

Lobo,

Cool.  We'll work on it.

Andrew