I created a list and added a couple items to it updated the form to inlcude the list, I created a dummy ticket and chose one of the items from the list. Tried to then search in the advanced search by choosing the item I had selected in the list. returned no results. Looked in the admin dashboard and the this is what I see.DB Error #1052 Column 'school' in where clause is ambiguous---- Backtrace ----#0 (root)/include/mysqli.php(177): osTicket->logDBError('DB Error #1052', '[SELECT ticket....')#1 (root)/include/ajax.tickets.php(253): db_query('SELECT ticket.t...')#2 (root)/include/ajax.tickets.php(264): TicketsAjaxAPI->_search(Array)#3 : TicketsAjaxAPI->search()#4 (root)/include/class.dispatcher.php(145): call_user_func_array(Array, Array)#5 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('search', Array)#6 (root)/include/class.dispatcher.php(120): Dispatcher->resolve('search', Array)#7 (root)/include/class.dispatcher.php(38): UrlMatcher->dispatch('/tickets/search', NULL)#8 (root)/scp/ajax.php(186): Dispatcher->resolve('/tickets/search')#9 {main}
As you can see my list is school, Any help would be much appreciated. Thanks