CiviCase Drupal Views Case Type

[pmoz]

Thanks Pete.

That too is interesting.  Here's what I get when I paste your link in.  When I hit enter after pasting, the address changes to civicrm/a/#/caseType and I see this table.

[petednz]

yes i see the same thing you do on demo, which is on 4.5.x - ours is on 4.4.x

http://d45.demo.civicrm.org/civicrm/a/#/caseType

your profile says you are on 4.4.x too - which is it?

[pmoz]

My profile version actually refers to a different company.

This site is on 4.5.3.  I definitely should have been clearer about that.

[demeritcowboy]

If you change where it says Label in sites\all\modules\civicrm\drupal\modules\views\components\civicrm.case.inc to say title instead, does it work then?

[petednz]

sounds like there needs to be some work done on Views for 4.5 - you could probably add a JIRA ticket - preferably with a patch if you can - esp if it is as trivial as it might be. We probably won't be pushing our clients up to 4.5 till the new year as there is just too much risk of things like this hitting us across 50+ sites which is why we put a fair bit of effort in to the LTS.

[pmoz]

Changed "Label" to "title" and it appears to be functioning.  Never thought I'd be so happy to see All Displays staring me in the face.

I'll dig around and see if there are any other issues with case views.

The civicrm.case.inc header does say

CiviCRM version 4.4

.

I haven't tried any other civi views on this install which is my only one with 4.5.3.  When I get a moment, I'll poke around with the other views and see if I run into any similar issues.

Thanks.

[pmoz]

Scratch that, can't get to site at all now.

All pages give DB Error: no such field.

Update:
After some gagging, we're back up.

Update:
Still gagging with "No such field"

Truncating all cache tables fixed it.

[pmoz]

Just updated to 4.5.6 and this issue is still present.

Had to change lines 96 and 105 in the Case Type section, change Label to title.

Then went to drupal cache tables and truncated all of them.

[adamtk]

Made the change with no luck. v4.6.2

I truncated the cache tables manually too, to be sure, after updating the file:
truncate cache_form; truncate cache_field; truncate cache_filter; truncate cache_image; truncate cache_menu; truncate cache_page; truncate cache_path;  truncate cache_rules; truncate cache_update; truncate cache_views;

I've noticed in the case dashlet, the case type isn't shown in open cases... nor on the job dashboard when showing job count by status.. yet the count is correct.

The case_type_id appears to be valid and linked in the database.. so it would appear until I perform further investigation the code needs updating in a few places.

[adamtk]

Seems some custom files were causing the issue, referring to the old table column name.. Will need to update them.