Development issueshttps://lab.civicrm.org/groups/dev/-/issues2022-12-04T05:03:21Zhttps://lab.civicrm.org/dev/core/-/issues/380Exporting Results from Related Contact Search Gives "No Records to Export" Me...2022-12-04T05:03:21ZguyiacExporting Results from Related Contact Search Gives "No Records to Export" MessageOn civicrm.org, I was trying to export the employers of people who attended CiviCamp Hartford 2017. I used the Advanced Search, chose CiviCamp Hartford 2017 in the Event tab, and Related Contacts - Employer in the "Display Results As" dr...On civicrm.org, I was trying to export the employers of people who attended CiviCamp Hartford 2017. I used the Advanced Search, chose CiviCamp Hartford 2017 in the Event tab, and Related Contacts - Employer in the "Display Results As" dropdown. I get 82 results to display. However when I select all 82 records and try to export them, I get the "no records to export" message. Same result on the dmaster demo site.
![image](/uploads/adb4206a1de036dd2371400e72a7f13a/image.png)https://lab.civicrm.org/dev/financial/-/issues/37Can't search by check number for checks entered with "Record Payment"2021-10-19T05:02:37ZJonGoldCan't search by check number for checks entered with "Record Payment"Someone reported this [on Stack Exchange](https://civicrm.stackexchange.com/q/27989/12), and it's pretty easy to replicate with their steps: "when you edit a pending pay later contribution, add a check number, change status to complete a...Someone reported this [on Stack Exchange](https://civicrm.stackexchange.com/q/27989/12), and it's pretty easy to replicate with their steps: "when you edit a pending pay later contribution, add a check number, change status to complete and then i go to search contributions, enter the payment method and search by check number i get no result."
`check_number` is a field both in `civicrm_contribution` and `civicrm_financial_trxn`. I suspect this is for historical reasons rather than anything anyone considers correct in 2019.
* To solve the immediate issue, "Find Contributions" should search the check number field of related financial transactions rather than the contribution itself.
* I think there's a strong argument that `civicrm_contribution.check_number` should be deprecated altogether, but that's a much larger issue.https://lab.civicrm.org/dev/core/-/issues/773Proposal: Don't allow deleting custom fields that are used in a smart group2022-11-07T05:03:58ZJonGoldProposal: Don't allow deleting custom fields that are used in a smart groupI'm inspired by [this SE question](https://civicrm.stackexchange.com/questions/28713/how-to-troubleshoot-expected-one-customfield-but-found-0-error/28731). I can't think of a reason why we'd allow someone to delete a custom field used i...I'm inspired by [this SE question](https://civicrm.stackexchange.com/questions/28713/how-to-troubleshoot-expected-one-customfield-but-found-0-error/28731). I can't think of a reason why we'd allow someone to delete a custom field used in a smart group. The downside is we'd need to use an unindexed search on `civicrm_saved search` (e.g. `LIKE %"custom_1"%`) but I'm guessing that most folks don't have thousands of smart groups, and this would happen fairly infrequently.https://lab.civicrm.org/dev/core/-/issues/867Expose line item name on search2023-04-30T05:03:21ZmaduraExpose line item name on search## Problem
On Advanced Search and Find Contributions there is currently no field to search for the line items. If an admin wants to be able to search for the contacts or contributions based on line items information there is no other se...## Problem
On Advanced Search and Find Contributions there is currently no field to search for the line items. If an admin wants to be able to search for the contacts or contributions based on line items information there is no other search parameters available.
## Proposed Solution
Introduce the "line item name" field in search.
Technical Steps:
- Add a new field to contribution search form and in postprocess, handle it and add suitable where clauses using existing fields as reference.
- Add a new textfield for line item search in CRM_Contribute_BAO_Query::buildSearchForm()
- In CRM_Contribute_BAO_Query::whereClauseSingle add logic for including condition for line item name.https://lab.civicrm.org/dev/core/-/issues/910Ability to Search contribution record using Transaction Date vs Date Received2022-11-08T05:03:39ZsunilAbility to Search contribution record using Transaction Date vs Date ReceivedRight now we can search contribution using 'Date Received' Field, But when Payment is received via check/ or paid through offline credit card (after few days) then the Transaction Date and Date Received may not be same.
During the Recor...Right now we can search contribution using 'Date Received' Field, But when Payment is received via check/ or paid through offline credit card (after few days) then the Transaction Date and Date Received may not be same.
During the Record your payment process, We keep old Receive Date as it is and add new entry in 'civicrm_financial_trxn' table with 'trxn_date' as current date.
If we want to search record when actual Transaction date then expected contribution record does not show in result.
e.g. cross check the payment processor transaction date and civicrm contribution record. transaction date will get matched with processor record and receive date is quite old (when record is created).https://lab.civicrm.org/dev/financial/-/issues/59[Unreleased regression] Undefined method when viewing Contribution Batch Sear...2019-09-04T14:42:48ZJonGold[Unreleased regression] Undefined method when viewing Contribution Batch Search screenThis exists on `master` but not the `5.13` branch.
To replicate: Go to **Contributions » Accounting Batches » New Batch**, then press **Save** on the next screen.
You'll receive an "Undefined Method" error:
```
[29-May-2019 21:24:28 U...This exists on `master` but not the `5.13` branch.
To replicate: Go to **Contributions » Accounting Batches » New Batch**, then press **Save** on the next screen.
You'll receive an "Undefined Method" error:
```
[29-May-2019 21:24:28 UTC] PHP Fatal error: Uncaught Error: Call to undefined method CRM_Financial_Form_BatchTransaction::addSearchFieldMetadata() in /srv/www/wpcvmaster/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Query.php:945
Stack trace:
#0 /srv/www/wpcvmaster/wp-content/plugins/civicrm/civicrm/CRM/Financial/Form/BatchTransaction.php(134): CRM_Contribute_BAO_Query::buildSearchForm(Object(CRM_Financial_Form_BatchTransaction))
#1 /srv/www/wpcvmaster/wp-content/plugins/civicrm/civicrm/CRM/Core/Form.php(606): CRM_Financial_Form_BatchTransaction->buildQuickForm()
#2 /srv/www/wpcvmaster/wp-content/plugins/civicrm/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#3 /srv/www/wpcvmaster/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Financial_Form_BatchTransaction), 'display')
#4 /srv/www/wpcvmaster/wp-content/plugins/civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Financial_Form_Bat in /srv/www/wpcvmaster/wp-content/plugins/civicrm/civicrm/CRM/Contribute/BAO/Query.php on line 945
```
I assume this is because a method got shifted to another file.
**Note** When someone tried to replicate this, it didn't occur until they cleared their cache. I'm assuming that's why this isn't happening on the demo sites.5.15.0https://lab.civicrm.org/dev/core/-/issues/1002Search displaying Related Contacts produces fatal error2019-06-03T22:21:46ZtommyboboSearch displaying Related Contacts produces fatal errorAs @DaveD mentioned here https://lab.civicrm.org/dev/core/issues/380#note_17294
In 5.13.4 when an advanced search is set to display Related Contacts it produces a fatal error. I have tested on two sites and Dave got the same error on dm...As @DaveD mentioned here https://lab.civicrm.org/dev/core/issues/380#note_17294
In 5.13.4 when an advanced search is set to display Related Contacts it produces a fatal error. I have tested on two sites and Dave got the same error on dmaster.demo.
```
Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id LEFT JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
WHERE displayRelType.relationship_type_id = 1
AND displayRelType.is_active = 1
AND (contact_a.is_deleted = 0)
GROUP BY sort_name
ORDER BY sort_name asc [nativecode=1054 ** Unknown column 'displayRelType.relationship_type_id' in 'where clause']
[type] => DB_Error
[user_info] => SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id LEFT JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
WHERE displayRelType.relationship_type_id = 1
AND displayRelType.is_active = 1
AND (contact_a.is_deleted = 0)
GROUP BY sort_name
ORDER BY sort_name asc [nativecode=1054 ** Unknown column 'displayRelType.relationship_type_id' in 'where clause']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT LEFT(contact_a.sort_name, 1) as sort_name
FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id LEFT JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
WHERE displayRelType.relationship_type_id = 1
AND displayRelType.is_active = 1
AND (contact_a.is_deleted = 0)
GROUP BY sort_name
ORDER BY sort_name asc [nativecode=1054 ** Unknown column 'displayRelType.relationship_type_id' in 'where clause']"]
)
```5.14.0https://lab.civicrm.org/dev/core/-/issues/1048(regression) Search Builder syntax error when "Groups" "is empty"2019-06-27T00:13:42ZJonGold(regression) Search Builder syntax error when "Groups" "is empty"This is new in 5.13.0 and was reported here. It's easy to replicate from the screenshot:
https://civicrm.stackexchange.com/questions/31083/in-civicrm-rel-5-14-the-search-builder-no-longer-provides-some-results
This regression occurs as ...This is new in 5.13.0 and was reported here. It's easy to replicate from the screenshot:
https://civicrm.stackexchange.com/questions/31083/in-civicrm-rel-5-14-the-search-builder-no-longer-provides-some-results
This regression occurs as a result of [PR 13603](https://github.com/civicrm/civicrm-core/pull/13603) which is intended to fix core#726.5.15.0https://lab.civicrm.org/dev/core/-/issues/1074Remove from groups is action is broken when searching of contacts within a group2019-06-30T00:07:10ZseamusleeRemove from groups is action is broken when searching of contacts within a groupWhen you get a list of contacts within a group by going to contacts -> manage groups -> contacts and then go and select a contact and then select contacts - remove from groups it fails on a DB syntax error. However doing a similar thing ...When you get a list of contacts within a group by going to contacts -> manage groups -> contacts and then go and select a contact and then select contacts - remove from groups it fails on a DB syntax error. However doing a similar thing via advanced search works. It looks like the prevNextCache is not getting populated sensibly
Error and backtrace
```
[to_string] => [db_error: message="DB Error: syntax error" code=-2 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT *
FROM civicrm_contact
WHERE (id IN ())
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 3]"]
)
Jun 26 08:02:55 [info] $backTrace = #0 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Error.php(952): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(922): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB.php(985): PEAR_Error->__construct("DB Error: syntax error", -2, 16, (Array:2), "SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n [nativecode=1064 ** You ha...")
#3 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-2, 16, (Array:2), "SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n [nativecode=1064 ** You ha...")
#4 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR->_raiseError(Object(DB_mysqli), NULL, -2, 16, (Array:2), "SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n [nativecode=1064 ** You ha...", "DB_Error", TRUE)
#5 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/common.php(1907): PEAR->__call("raiseError", (Array:7))
#6 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/mysqli.php(933): DB_common->raiseError(-2, NULL, NULL, "SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n [nativecode=1064 ** You ha...", "1064 ** You have an error in your SQL syntax; check the manual that correspon...")
#7 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/mysqli.php(403): DB_mysqli->mysqliRaiseError()
#8 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/common.php(1216): DB_mysqli->simpleQuery("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n")
#9 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/DataObject.php(2415): DB_common->query("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n")
#10 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/DB/DataObject.php(1607): DB_DataObject->_query("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n")
#11 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/DAO.php(439): DB_DataObject->query("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n")
#12 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/DAO.php(1414): CRM_Core_DAO->query("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n", TRUE)
#13 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Utils/SQL/Select.php(517): CRM_Core_DAO::executeQuery("SELECT *\nFROM civicrm_contact\nWHERE (id IN ())\n", (Array:0), TRUE, NULL, FALSE, TRUE, FALSE)
#14 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Contact/Form/Task.php(491): CRM_Utils_SQL_Select->execute()
#15 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Contact/Form/Task.php(272): CRM_Contact_Form_Task::getSelectedContactNames()
#16 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Contact/Form/Task.php(91): CRM_Contact_Form_Task::preProcessCommon(Object(CRM_Contact_Form_Task_RemoveFromGroup))
#17 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Form.php(590): CRM_Contact_Form_Task->preProcess()
#18 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Display.php(92): CRM_Core_Form->buildForm()
#19 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Display->perform(Object(CRM_Contact_Form_Task_RemoveFromGroup), "display")
#20 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Contact_Form_Task_RemoveFromGroup), "display")
#21 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Controller.php(351): HTML_QuickForm_Page->handle("display")
#22 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Core_Controller->run((Array:3), (Array:0))
#23 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Invoke.php(85): CRM_Core_Invoke::runItem((Array:14))
#24 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:3))
#25 /home/seamus/buildkit/build/47-test/sites/all/modules/civicrm/drupal/civicrm.module(444): CRM_Core_Invoke::invoke((Array:3))
#26 /home/seamus/buildkit/build/47-test/includes/menu.inc(527): civicrm_invoke("group", "search")
#27 /home/seamus/buildkit/build/47-test/index.php(21): menu_execute_active_handler()
```5.15.0https://lab.civicrm.org/dev/core/-/issues/3271Regression: Can't use operators to filter contact subtypes other than "Is One...2022-04-22T15:53:19ZJonGoldRegression: Can't use operators to filter contact subtypes other than "Is One Of"This is introduced by core#544, which introduces a hard-coded `LIKE` where the code should allow for different operators.
[A commit based on 5.14 is here](https://github.com/MegaphoneJon/civicrm-core/commit/625b0b06e64d02883614e31bb4ef7...This is introduced by core#544, which introduces a hard-coded `LIKE` where the code should allow for different operators.
[A commit based on 5.14 is here](https://github.com/MegaphoneJon/civicrm-core/commit/625b0b06e64d02883614e31bb4ef79825a1b8ad2#diff-d355cdb00cea3915a3cf306c6c08f6a6L2131) and hopefully I (or someone) will have time to merge and add tests in the near future.5.16.0https://lab.civicrm.org/dev/core/-/issues/1098Slow performance on activity search2020-08-28T04:32:05ZeileenSlow performance on activity searchI did some digging into this long term problem & have some code - basically the issue is actually when the 'acl' is applied it joins onto the option value table for activity type with a bad join.
However, it raises a couple of questions...I did some digging into this long term problem & have some code - basically the issue is actually when the 'acl' is applied it joins onto the option value table for activity type with a bad join.
However, it raises a couple of questions as to the right way to fix
I've added code comments into the PR at https://github.com/civicrm/civicrm-core/pull/15016 pointing to where I think we need to gohttps://lab.civicrm.org/dev/core/-/issues/1128Primary email search fails2022-01-21T09:08:37ZandyburnsPrimary email search failsI get this error when searching for any email address in advanced search or search builder.
https://pastebin.com/6LRJDyt1
The 1-address alias is not defined, so it fails. In advanced search it does not let me select the location type f...I get this error when searching for any email address in advanced search or search builder.
https://pastebin.com/6LRJDyt1
The 1-address alias is not defined, so it fails. In advanced search it does not let me select the location type for the email. However, in search builder it does and it still fails. I tested this on the demo https://wpmaster.demo.civicrm.org/ and email search works there. I have disabled all civi extensions and it still fails.
WP 5.2.1 and Civi 5.13.4 multisite. Anyone else seeing this?
I had posted to SE https://civicrm.stackexchange.com/questions/30973/email-search-failure without resolving.https://lab.civicrm.org/dev/core/-/issues/1173Searching with Tags in Activities not working2020-12-22T01:26:14ZBari PollardSearching with Tags in Activities not workingUsing Tags to search within Activities now isn't working.
Tested on sites running 5.15.1 and DMaster Demo running 15.17.alpha1
Created a Tag set for Activites - Testing search tags
Created a set of tags for tag set - One, Two, Three
C...Using Tags to search within Activities now isn't working.
Tested on sites running 5.15.1 and DMaster Demo running 15.17.alpha1
Created a Tag set for Activites - Testing search tags
Created a set of tags for tag set - One, Two, Three
Created meeting activty with Tag attached
Searched Activities for anything with Tag
No results.https://lab.civicrm.org/dev/core/-/issues/1179Default Contact Search Profile should be respected for contact searches2023-03-09T05:03:24ZyashodhaDefault Contact Search Profile should be respected for contact searches*Default Contact Search* Profile should be respected for contact searches including *Edit Smart Group Criteria*.
Steps to replicate :
* Create a profile configured to be used in *Search Views*.
* Make this profile as *Default Contact S...*Default Contact Search* Profile should be respected for contact searches including *Edit Smart Group Criteria*.
Steps to replicate :
* Create a profile configured to be used in *Search Views*.
* Make this profile as *Default Contact Search Profile*.
* Go to Basic, Advanced Search/Builer, all the results have profile fields listed as column headers if use force=1.
![adv_force](/uploads/278a0cbf0c9107c3ea326218821b36da/adv_force.png)
* Create a smart search and go to Contacts and use force=1. Profile fields not shown.
![smart_group](/uploads/9f76dc3c1d961181bd713624392dcc9d/smart_group.png)yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/1211Add option to search by date not set2023-01-16T05:03:34ZyashodhaAdd option to search by date not setCurrently in CiviCRM, for date fields you can either search by date range or for some fields explictly there is an option to filter by NULL/NOT NULL.
![contrib_search](/uploads/f6d1e0474fb4fcceefac4f0fdd5d58e2/contrib_search.png)
The op...Currently in CiviCRM, for date fields you can either search by date range or for some fields explictly there is an option to filter by NULL/NOT NULL.
![contrib_search](/uploads/f6d1e0474fb4fcceefac4f0fdd5d58e2/contrib_search.png)
The option to filter by NULL/NOT NULL should be available for all date fields in the filter drop down fields.
I have already added this option in reports and it looks like it could helpful for other date search screens as well.![contri_date+null](/uploads/dd4cfc311620ae952ab237e4abee7767/contri_date+null.png)yashodhayashodhahttps://lab.civicrm.org/dev/core/-/issues/1217Error on action with multiple event names filter for Find participants search2020-01-22T09:41:28ZfrancescbassasError on action with multiple event names filter for Find participants searchSame problem described at [Email - schedule/send via CiviMail" with multiple event names filter](https://lab.civicrm.org/dev/core/issues/469) but for **Find participants** search.
**Steps to reproduce**
1. Go to **Events > Find partici...Same problem described at [Email - schedule/send via CiviMail" with multiple event names filter](https://lab.civicrm.org/dev/core/issues/469) but for **Find participants** search.
**Steps to reproduce**
1. Go to **Events > Find participants**
1. Select **two events** on **Event Name** field and click to **Search** button
1. Select **All records** and click **Actions** button
1. Click on **Group - create smart group**
1. Enter a name in the **Name** field
1. Click **Save Smart Group**
1. An error screen appears with a message like
`3,2 is not of the type Int`
Reported at SE [How do you create a Smart Group with participants from multiple events](https://civicrm.stackexchange.com/q/31712/104)https://lab.civicrm.org/dev/core/-/issues/1246Fatal Error in "Search Builder" if "Household" Contact type is disabled.2019-09-13T03:49:45ZmarcusjwilsonFatal Error in "Search Builder" if "Household" Contact type is disabled.On upgrading to CiviCRM 5.17.0 we noticed that a Fatal Error was thrown when accessing "Search Builder", relating to Null values in arrays in CRM/Core/BAO/Map.php.
We tracked the issue down to the "Household" contact type, which we had ...On upgrading to CiviCRM 5.17.0 we noticed that a Fatal Error was thrown when accessing "Search Builder", relating to Null values in arrays in CRM/Core/BAO/Map.php.
We tracked the issue down to the "Household" contact type, which we had disabled for the two client sites throwing these errors (these two clients never use Household contact type, so we'd used CiviAPI to disable this contact type).
When we re-enabled Household contact type the Fatal error was resolved.
It feels like the Search Builder shouldn't break when Household contact type is disabled, so logging this for a fix.5.17.4colemanwcolemanwhttps://lab.civicrm.org/dev/core/-/issues/1257Make Relationship Description searchable (Paid Feature2019-10-16T13:44:06Zfabian_SYSTOPIAMake Relationship Description searchable (Paid Feature**Overview**
Relationships provide a "description" field which is nicely displayed in the relationship tab of a contact. However, it is currently not possible to search for those descriptions using any regular CiviCRM search.
**Scope**...**Overview**
Relationships provide a "description" field which is nicely displayed in the relationship tab of a contact. However, it is currently not possible to search for those descriptions using any regular CiviCRM search.
**Scope**
User should have the possibility to search for contacts with certain descriptions in the relationship. The advanced search should offer a possibility to search for relationship descriptions.
**Note**
I originally posted this on CiviCRM's Jira but it probably git lost in migration so I am re-posting it here. We have a customer who may fund this so it would be great to get an estimate from the core team. We would be able to test the improvement.https://lab.civicrm.org/dev/core/-/issues/1350Ignoring exception thrown by nullHandler: -2, DB Error: syntax error2019-11-23T22:35:45ZmfbIgnoring exception thrown by nullHandler: -2, DB Error: syntax errorAdvanced search can result in DB errors; it appears the bug is in CRM/Core/PrevNextCache/Sql.php
Steps to reproduce:
1. Fire up CiviCRM 5.18.4
1. Visit advanced search @ civicrm/contact/search/advanced
1. Click Address Fields and enter...Advanced search can result in DB errors; it appears the bug is in CRM/Core/PrevNextCache/Sql.php
Steps to reproduce:
1. Fire up CiviCRM 5.18.4
1. Visit advanced search @ civicrm/contact/search/advanced
1. Click Address Fields and enter 1600 under the Street Address field.
1. Click Search; search completes successfully.
1. Check your error log for "$backTrace = #0..." and "Ignoring exception thrown by nullHandler: -2, DB..."
I think what happens is `%` is automatically tacked on to make it a "LIKE" search, and this results in `%1600` in the query.. the %1 parameter is then filled, resulting in invalid SQL.
The DB error is e.g.:
```
1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'civicrm search 9dcac50894b9b820a311612b44525018_1779'600%' ) AND (contact_a.is_' at line 2
```
The query is e.g.:
```
INSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data)
SELECT DISTINCT 'civicrm search 9dcac50894b9b820a311612b44525018_1779', contact_a.id, contact_a.sort_name FROM civicrm_contact contact_a LEFT JOIN civicrm_address ON ( contact_a.id = civicrm_address.contact_id AND civicrm_address.is_primary = 1 ) WHERE ( civicrm_address.street_address LIKE ''civicrm search 9dcac50894b9b820a311612b44525018_1779'600%' ) AND (contact_a.is_deleted = 0) LIMIT 0, 500
```https://lab.civicrm.org/dev/core/-/issues/1354Proposal: Add customfield search in Campaign dashboard2023-01-01T05:03:25ZVangelisPProposal: Add customfield search in Campaign dashboardOn a regular basis I got some requests to have the customfields that are being assigned into Campaigns, exposed to the search of the campaign dashboard so that users can filter by those customfields.
I've already started working a littl...On a regular basis I got some requests to have the customfields that are being assigned into Campaigns, exposed to the search of the campaign dashboard so that users can filter by those customfields.
I've already started working a little bit on this issue myself, that is, to add all associated customfields on the campaign's dashboard filter search, is there any interest on this feature ?
Cheers