CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Possible typo in templates/CRM/Contact/Form/Search/Custom/ActivitySearch.tpl ?
Pages: [1]

Author Topic: Possible typo in templates/CRM/Contact/Form/Search/Custom/ActivitySearch.tpl ?  (Read 461 times)

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Possible typo in templates/CRM/Contact/Form/Search/Custom/ActivitySearch.tpl ?
November 05, 2013, 01:47:17 pm
When using the custom search ActivitySearch, it seems as though it supports the activity date in the result columns but it doesn't appear. Looking at the tpl file it looks like it references the array member ".SORT" instead of ".sort" and so it doesn't output it. Just wondering if anybody knows if this is on purpose or not, like the intention was to comment it out instead of removing it.

It looks like it got changed here, so maybe worked in 3.0 but not 3.1 or later:
http://issues.civicrm.org/jira/browse/CRM-5542?page=com.atlassian.streams.streams-jira-plugin:activity-stream-issue-tab

We only use this custom search because of http://issues.civicrm.org/jira/browse/CRM-9065, but based on the fix version there that's obviously a hard one to fix.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Possible typo in templates/CRM/Contact/Form/Search/Custom/ActivitySearch.tpl ?
November 05, 2013, 02:00:56 pm

hey dd:

the main issue that reason was punted was due to a non-scalable schema design with regard to activities and contacts (3 left joins each on civicrm_activity* and civicrm_contact) to involve all participants. In 4.4, we've fixed the schema issue using one table for all activity contacts called civicrm_activity_contact, so fixing that issue and making activity search scalable is now possible (or so we think)

if i had to guess the .SORT was a typo / unintentional upper casing, so i would lower case it and see if it works

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: Possible typo in templates/CRM/Contact/Form/Search/Custom/ActivitySearch.tpl ?
November 05, 2013, 02:08:19 pm
Ok thanks. It does work just there's also a hardcoded date format that's incompatible with excel when exported, and there's other fields that look like they're supposed to be there and are there when exported but not on screen. So I was wondering if it was worth fixing - there's probably more buried in there too once I get into it.

I'll get around to a PR but in the meantime in case anyone else is searching.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Possible typo in templates/CRM/Contact/Form/Search/Custom/ActivitySearch.tpl ?

This forum was archived on 2017-11-26.