Search by _profile_ids, order by profile_id
Jamroom Developers
Hi, I'm using jrCore_list in a template to search by multiple _profile_ids and order by _profile_id but getting an error in the activity log "you must include the _profile_id field in your search criteria to order_by it".
I'm sure I can sort it out in the template, but should it be working, or am I just missing something obvious?
{jrCore_list module="ujStatement" search="_profile_id in `$_user['user_linked_profile_ids']`" order_by="_profile_id numerical_asc" template="list.tpl" tpl_dir="ujManager"}
From the activity log:
Array
(
[0] => error: you must include the _profile_id field in your search criteria to order_by it
[1] => ujStatement
[2] => Array
(
[jrcore_list_function_call_is_active] => 1
[search] => Array
(
[0] => _profile_id in 3, 5, 6, 7, 8, 9, 10
[1] => _profile_id in (SELECT `_item_id` FROM jr_jrprofile_item_key WHERE `key` = 'profile_quota_id' AND `value` IN(1))
)
[order_by] => Array
(
[_profile_id] => numerical_asc
)
[template] => select_statements_to_zip.tpl
[tpl_dir] => ujManager
[module] => ujStatement
)
[3] => Array
(
[jrcore_list_function_call_is_active] => 1
[search] => Array
(
[0] => _profile_id in 3, 5, 6, 7, 8, 9, 10
)
[order_by] => Array
(
[_profile_id] => numerical_asc
)
[template] => select_statements_to_zip.tpl
[tpl_dir] => ujManager
[module] => ujStatement
)
)
updated by @ultrajam: 10/02/22 11:48:08PM