get_limited_search()

Oahu Developer's Manual

Introduction Administration Settings Posting User Groups Message Groups Procedures
add_instructor_to_course add_message_group_members add_message_poll_item add_message_poll_vote add_message_to_usergroup add_message_vote add_student_to_course add_ta_to_course add_user_to_group create_message create_message_group create_message_reply create_message_thread create_user_group create_usergroup_thread db_add_user db_admin_activate_user db_admin_add_admin db_admin_add_user db_admin_create_course db_admin_deactivate_user db_admin_delete_admin db_init_user db_login db_set_global_setting delete_message delete_user_from_course delete_user_from_group edit_message get_active_courses get_all_courses get_course get_limited_search get_limited_thread_messages get_limited_usergroup_threads get_message get_message_group_members get_message_poll_votes get_message_threads get_message_votes get_my_active_courses get_my_all_courses get_my_messagegroups get_my_usergroups get_setting_for_course get_user get_user_settings get_usergroup_members get_usergroup_threads get_users_in_course local_login_create_user local_login_get_user local_login_validate mark_message_as_read mark_message_as_unread mark_thread_as_read mark_thread_as_unread remove_message_from_usergroup search_messages self_enroll_student set_course_default_setting set_course_default_tsetting set_group_member_type set_school_default_setting set_system_default_setting set_system_default_tsetting set_user_default_setting set_user_default_tsetting set_user_setting set_user_tsetting update_course_settings

get_limited_search()

Parameters

Token(character varying)
Criteria(character varying)
Limit(integer)
Offset(integer)

Returns

Success or a list of messages

Description

Takes an input criteria and uses it to search for specific messages. The criteria include
CourseID
UserGroupID
MessageGroupID
IsThread // if it exists in the list the results are limited to only OP of threads
CreationTimeLTE //This is when the message was created LTE means less than or equal so "Message"."CT" <= CreationTimeLTE
CreationTimeGTE // Greater than or equal
ChildCountGTE // Number of children the message has
ChildCountLTE
ScoreGTE // the message score based on user votes
ScoreLTE
Search criteria would look something like: search_messages('briankey','{"CourseID":"2","UserGroupID":"43","ScoreLTE":"2","CreationTimeGTE":"2018-10-24"}')

Errors

1 - Invalid Session.
2 - Invalid search Criteria.
3 - Cannot read group.

Related functions