[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Fmsystem-commits] [17145] helpdesk: filter on id
From: |
sigurdne |
Subject: |
[Fmsystem-commits] [17145] helpdesk: filter on id |
Date: |
Mon, 9 Oct 2017 15:28:46 -0400 (EDT) |
Revision: 17145
http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=17145
Author: sigurdne
Date: 2017-10-09 15:28:46 -0400 (Mon, 09 Oct 2017)
Log Message:
-----------
helpdesk: filter on id
Modified Paths:
--------------
trunk/helpdesk/inc/class.sotts.inc.php
Modified: trunk/helpdesk/inc/class.sotts.inc.php
===================================================================
--- trunk/helpdesk/inc/class.sotts.inc.php 2017-10-09 18:27:53 UTC (rev
17144)
+++ trunk/helpdesk/inc/class.sotts.inc.php 2017-10-09 19:28:46 UTC (rev
17145)
@@ -349,8 +349,10 @@
if($query)
{
$query = $this->db->db_addslashes($query);
- $querymethod = " $where subject $this->like
'%$query%'";
+ $querymethod = " $where (
phpgw_helpdesk_tickets.id = " . (int) $query;
+ $query = $this->db->db_addslashes($query);
+ $querymethod .= " OR subject $this->like
'%$query%')";
}
$sql = "SELECT DISTINCT phpgw_helpdesk_tickets.* ,
phpgw_helpdesk_views.id as view {$result_order_field} FROM
phpgw_helpdesk_tickets"
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Fmsystem-commits] [17145] helpdesk: filter on id,
sigurdne <=