get_research_request()

Description

Retrieves a research request by its reference number, returning its details including name, description, deadline, contact information, user assignment, status, and custom fields.

Parameters

ColumnTypeDefaultDescription
$ref int The reference number of the research request to retrieve.

Return

array|false An associative array with the research request details if found, or false if no request exists.

Location

include/research_functions.php lines 135 to 148

Definition

 
function get_research_request($ref)
{
    $rr_sql = "SELECT rr.ref,rr.name,rr.description,rr.deadline,rr.email,rr.contact,rr.finaluse,rr.resource_types,rr.noresources,rr.shape,
                    rr.created,rr.user,rr.assigned_to,rr.status,rr.collection,rr.custom_fields_json,
                    (select u.username from user u where u.ref=rr.user) username, 
                    (select u.username from user u where u.ref=rr.assigned_to) assigned_username from research_request rr where rr.ref=?";
    $rr_parameters = array("i",$ref);

    $return = ps_query($rr_sql, $rr_parameters);
    if (count($return) == 0) {
        return false;
    }
    return $return[0];
}

This article was last updated 4th April 2025 21:35 Europe/London time based on the source file dated 17th January 2025 17:40 Europe/London time.