Filter TeamRaiser getParticipants by personalPagePrivate

Romany Nassief

How can I filter by personalPagePrivate with TeamRaiser getParticipants call?



Please let me know which values should I use with "list_filter_column" and "list_filter_text" parameters.

Daniel Hartanto

Hi Romany



I believe that getParticipants API gives a true/false within the returned result for private personal page.



If that's the case, perhaps you could tap into the loop to only show the "true" or "false" result category accordingly instead of using the filtering parameter.



Check for "personalPagePrivate" returned value on your JSON or XML object



Note: The 'built-in' Filtering parameter value through the use of "list_filter_column" are trivial at best from what I have worked / seen. This is in terms of whether one should use a prepended alias (i.e. "t.column name" or not, or sometimes the alias is different from different case and not advertised which only Convio engineers are aware of; thus most of the time you ended up reaching out to Support only to find out whether the filtering opt. works or not in specific cases)



Details on that API is available at: http://open.convio.com/api/#teamraiser_api.getParticipants_method.html



regards,

Daniel

Noah Cooper

You'd want to use &list_filter_column=private_page&list_filter_text=0.