public function testGetListViewQueryCreatedBy() { require_once "include/ListView/ListViewDisplay.php"; include "modules/Notes/metadata/listviewdefs.php"; $displayColumns = array('NAME' => array('width' => '40%', 'label' => 'LBL_LIST_SUBJECT', 'link' => true, 'default' => true), 'CREATED_BY_NAME' => array('type' => 'relate', 'label' => 'LBL_CREATED_BY', 'width' => '10%', 'default' => true)); $lvd = new ListViewDisplay(); $lvd->displayColumns = $displayColumns; $fields = $lvd->setupFilterFields(); $query = $this->note->create_new_list_query('', 'id="' . $this->note->id . '"', $fields); $regex = '/select.* created_by_name.*LEFT JOIN\\s*users jt\\d ON\\s*notes.created_by\\s*=\\s*jt\\d\\.id.*/si'; return $this->assertRegExp($regex, $query, "Unable to find the created user in the notes list view query: {$query}"); }