Correct API syntax for custom CiviCase field

[allenthehusband]

I'm trying to get the value of a custom field on to a CiviCase activity screen (using \templates\CRM\Case\Form\Activity.tpl).  I've tried calling the API using both Case and CustomValue entities, but have been unsuccessful thus far.  Here are the bits of info relevant to my custom field, titled 'Background Check'.

From our Custom Data screen(s), the custom group ID to which our field belongs is 15.  The ID of the custom field itself is 44.
From our API parameters page (URL/civicrm/api/doc#case), the field is custom_44.
From our mySQL database, the custom group table is civicrm_value_ministry_application_15.  The column name is background_check_44.

I've used the API explorer with both Case and CustomValue, but the closest I've gotten is with CustomValue:

Code: [Select]

/civicrm/ajax/rest?entity=CustomValue&action=get&debug=1&sequential=1&json=1&entity_id=$caseId&return.custom_44=1
In the explorer with the above code, I can at least get the values to populate for "entity_id", "latest", "id" and "0", but the trouble is that when I use the Smarty equivalent of that call, I get an error message saying that the return.custom_44=1 is not expected syntax.

When I've used the Contact API on other TPL files, I had to use (for example) "&return=custom_7" and it worked great, but I've tried "&return=custom_44" with both the Case and CustomValue entities, and neither return the relevant info.

I feel like I have all the pieces I would need to get the value of the field, I just don't know the proper syntax to use for a call to the Case API.  Can someone point me in the right direction?  Thanks so much!

[Coleman Watts]

I think in smarty you can just say return=custom_44

[allenthehusband]

Coleman, thanks so much for your quick reply.  Here's what I've just put into my TPL file, but it does not return the value.  Any ideas?

Code: [Select]

{crmAPI var='result' entity='Case' action='get' sequential=1 case_id=$caseId return=custom_44}
{foreach from=$result.values item=Case}
{$Case.background_check_44.field_value}
{/foreach}

[allenthehusband]

I've also tried

{$Case.background_check_44}
{$Case.custom_44}

with no luck.  I'm stumped.

[Coleman Watts]

That param is a string. Strings need to be quoted. So, return='custom_44'

[sandeepmohanty]

I am getting ajax error while i am adding case type as field in drupal view. I am using drupal version 7.34 and civicrm version 4.5.5. It shown in screen-shot.

[Coleman Watts]

That's a views issue not an api issue. Can you try clearing your caches? Are you using the latese version of CiviCRM?

[sandeepmohanty]

That's a views issue not an api issue. Can you try clearing your caches? Are you using the latese version of CiviCRM?

Yes i cleared views caches and drupal caches. I am using civicrm 4.5.5 version and drupal views version is 3.10

[petednz]

seems the above user may have clicked on 'report to moderator'

sandeep was that on purpose or just an accident?