3

For example, I have a membership report /civicrm/report/instance/103 and I want to filter to only show rows where the value of a custom field with id of 65 is 'abc'

9

http://example.org/civicrm/report/instance/103?reset=1&force=1&custom_65_value=abc should do it.

Note that you can also pass an operator to define the type of filtering you want to do, In this case, for example, adding &custom_65_op=has means that the filter would be 'custom field 65 contains the string 'abc'.

Right clicking on the relevant field in the report and then choosing inspect will open up a window where you can find the appropriate values for different operations.

  • 1
    Took me a while to figure this out - thought it was worth an auto q+a – michaelmcandrew Jun 7 '18 at 21:50
  • Another way to get the configured values is to create a report with all filters etc, then check the table civicrm_report_instance, and then form_values from that report. All configured values are saved there and are ready to be set via URL. Seemed to be easier for me than inspecting ... – Phil_B Aug 3 '18 at 11:45
  • @Phil_B - interesting! – michaelmcandrew Jun 25 at 14:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.