Author Topic: Note API sort (Read 1381 times)

jimurl · November 28, 2011, 04:09:57 pm

Does the Note API support sorting? I am trying this with Smarty:

{crmAPI var="ContactNoteS" entity="Note" action="get" version="3" entity_id="$contactId" sort="modified_date DESC"}

In the api explorer on my site, I tried this:
/civicrm/ajax/rest?json=1&debug=on&entity=Note&action=get&sequential=1&sort=modified_date&entity_id=26196

but get this at the top of the results:
"is_error":0,
   "undefined_fields":["sort"],
   "version":3,
   "count":2,
   "values":[{
...
...

Eileen · November 28, 2011, 04:37:49 pm

It supports 'option.sort' or 'options' => array('sort');

(all the ones based on _civicrm_api3_basic_get(); support that syntax).

jimurl · November 29, 2011, 02:34:05 pm

that does work on the API explorer; but within a smarty template, this :

{crmAPI var="ContactNoteS" entity="Note" action="get" version="3" entity_id="$contactId" option.sort="modified_date DESC"}

is still not sorting them in reverse chronological order. Am I not referring to the sort member of the option array correctly?

xavier · November 30, 2011, 12:28:19 am

smarty has issues with dot in the names.

I think I implemented a workaround replacing with underscore. Can you try option_sort= ?

X+

jimurl · November 30, 2011, 08:13:46 am

That was totally it! Thank to both of you. Here is what worked: option_sort="modified_date DESC"

xavier · December 01, 2011, 06:19:01 am

Glad you sorted it out.

If you could modify the wiki and clarify if needed, that'd be useful for the other users.

X+

CiviCRM Community Forums (archive)

News:

Author Topic: Note API sort (Read 1381 times)

jimurl

Note API sort

Eileen

Re: Note API sort

jimurl

Re: Note API sort

xavier

Re: Note API sort

jimurl

Re: API sort results syntax

xavier

Re: Note API sort