• NAME
• SYNOPSIS
• DESCRIPTION
• METHODS
  • LimitToEnabled
  • LimitToDeleted
  • FindAllRows
  • LimitAttribute PARAMHASH
  • LimitCustomField
  • Limit PARAMHASH
  • ItemsOrderBy
  • ItemsArrayRef

NAME

  RT::SearchBuilder - a baseclass for RT collection objects

SYNOPSIS

DESCRIPTION

METHODS

LimitToEnabled

Only find items that haven't been disabled

LimitToDeleted

Only find items that have been deleted.

FindAllRows

Find all matching rows, regardless of whether they are disabled or not

LimitAttribute PARAMHASH

Takes NAME, OPERATOR and VALUE to find records that has the matching Attribute.

If EMPTY is set, also select rows with an empty string as Attribute's Content.

If NULL is set, also select rows without the named Attribute.

LimitCustomField

Takes a paramhash of key/value pairs with the following keys:

CUSTOMFIELD - CustomField id. Optional

OPERATOR - The usual Limit operators

VALUE - The value to compare against

Limit PARAMHASH

This Limit sub calls SUPER::Limit, but defaults "CASESENSITIVE" to 1, thus making sure that by default lots of things don't do extra work trying to match lower(colname) agaist lc($val);

We also force VALUE to NULL when the OPERATOR is IS or IS NOT. This ensures that we don't pass invalid SQL to the database or allow SQL injection attacks when we pass through user specified values.

ItemsOrderBy

If it has a SortOrder attribute, sort the array by SortOrder. Otherwise, if it has a "Name" attribute, sort alphabetically by Name Otherwise, just give up and return it in the order it came from the db.

ItemsArrayRef

Return this object's ItemsArray, in the order that ItemsOrderBy sorts it.