Add search field to reports

Any progress on this?

I am interested in this as well.
Although we can always do a Ctrl-F and search, but it's not the same, specially if there are multiple pages.

Thank you, will try it soon.

The attached patch does the following:

1. Adds an option on Report Criteria - Display Search Form.
2. If the above option is selected, a collapsible fieldset titled Search Report is displayed on the report output page.
3. The user can search All Columns or select a specific column for a value.
4. Search results are display in the report output.
5. The Search fieldset is only displayed in page view.

The patch was created in Beta5.

Please leave feedback!

I'm unable to apply this patch.
I'm new to Cygwin and after issuing the command
patch -p0 < 299414.patch

it's telling me:
bash: patch: command not found

any easier way to apply this patch? it's too long to do it manually.

Thanks Jim.

I applied the patch, but unfortunately the search only works under FireFox but not in IE 8, Chrome and Opera.

Thank you for the feeback.

The fix to exclude hidden columns is simple enough...

However, I don't understand why it only works in FF. When I tried to display your page in FF, I could not get the search column to drop down...

I have noted another issue - the search form does not work in a cached page. This may be the problem you are running into. Unless someone can think of a better idea, I think I will only display the search form to authenticated users - maybe I could check $GLOBALS['conf']['cache'] and display if caching is disabled (0).

I replaced the files with the original beta5 files, so no traces of any patch.
Now even if we click on any of the column-headers, it's not sorting in that order. I'm not sure if this functionality worked before or not. Did anyone test this sorting?

Reopening, as the search field doesnt work at all here with 6.x-2.0-rc1, using postgresql database.

I'm viewing the report as admin (with firefox, fwiw), and regardless of what i put in the search field (and in the dropdown column selection) all submissions are shown. This is with default drupal install, i didn't specifically enable caching, and it's the same whether i configure filters or not.

There's also a 'Display Report Filter Form' checkbox option on the report criteria tab which does nothing (i looked at the code). Maybe it should be hidden/removed until it's implemented.

Sorting works fine. The filters themselves work fine.

Oh, i just found where it comes from. In fact it will only work on english websites :)

Fix is easy: in webform_report_search_form_submit(), replace 'Search' by t('Search') in the check for $form_state['values']['op']. Bam, it works. There could probably be a cleaner solution..

Your patch works for me, thanks.

Using FireFox browser with the February 4th version of 6.x-2.x-dev and a special PHP code that was provided. When I do a search, it comes with the following error:
if (function_exists('ip2cc_get_country') && function_exists('theme_countryicons_icon')) { $headers[5] = 'Country Name'; $headers[6] = 'Country Code'; $headers[7] = 'Country Icon'; foreach($rows as $i => $row) { $ip = $row[4]['data']; $c = ip2cc_get_country($ip); $rows[$i][5]['data'] = $c->country_name; $rows[$i][6]['data'] = $c->country_code2; $rows[$i][7]['data'] = theme_countryicons_icon($c->country_code2); } }

If you go back and hit refresh the search works and displays the correct rows. However the error above stays above the header of the site.

The search doesn't work at all for IE 8 but displays the same error.

Tried it on two different sites with the same issue.

Yes, that was it, I changed the PHP code and it is working now under FireFox, however IE 8 still doesn't provide any results, just gives the full list.

The code will be change to disable the search form for anonymous users if site caching is enabled. If you want to change this behaviour, site caching will need to be disabled or the module can be altered to turn off site caching under certain conditions.