Gepubliceerd
2007-10-28 19:29
We have had a few requests from folks to extend the search code with their own SQL queries while taking advantage of the tasks available with search (print, mailing labels, export, smart groups, adding to group etc). This has been on our list of things to do, but we had not made any progress. Some example where this would be useful are:
- Give me the set of all household's who have a household member residing in district X. More details here. The search form can be set to just include a text box for the household name and a multi-select element for the district to restrict the search criteria
- Give me the set of contact(s) who have donated more than an input amount in this date range.
- Various combinations of AND/OR/NOT which civicrm search does not handle.
- Cannot integrate with tables not part of the current search
- Form elements are restricted to current search form elements
- The where clause is influenced by the current query builder
- Cannot have conditional sql based on input values
Filed under
Comments
I'm deeply interested in further development concerning the advanced searches. CiviCRM is really great but the major shortcoming we face is the lack of really advanced searches (especially the AND/OR possibility) along with the fact that we can't build labels (or export contacts) of individuals with theor Ooganisation name. I guess such a custom search would address both issues at the same time. The link does not seem to work for now. Is it possible to check it in order I can have a closer glance? CiviCRM really rocks!
sorry, i restructured the code a bit and broke the links. the links are now fixed
lobo
Solr, with its faceting and full-text indexing capabilities, would be a very powerful replacement.
i did a mockup on this a few months ago, and wrote a few thoughts at: http://civicrm.org/node/104
i suspect i'll move this into production in 2.1
lobo