<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>I didn't get any useful help from mailing list .</div><div><br></div><div>RT 3.6.3</div><div><br></div>I extracted sql query ( 'CF.{Approval}' LIKE '1. Pending' ) :<br><br>SELECT COUNT(DISTINCT <a href="http://main.id/">main.id</a>) FROM (((Tickets main LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON ((ObjectCustomFields_1.ObjectId = '0')) AND( ObjectCustomFields_1.ObjectId = main.Queue)) LEFT JOIN CustomFields CustomFields_2 ON ( CustomFields_2.id = ObjectCustomFields_1.CustomField)) LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3 ON ((ObjectCustomFieldValues_3.ObjectId = <a href="http://main.id/">main.id</a>)) AND( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id) AND( (ObjectCustomFieldValues_3.Disabled = '0')) AND( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket'))) WHERE ((CustomFields_2.Name = 'Approval')) AND ((main.EffectiveId = <a href="http://main.id/">main.id</a>)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) AND ( ( (ObjectCustomFieldValues_3.Content LIKE '%1. Pending%') ) )<br><br>result : <br>+-------------------------+<br>| COUNT(DISTINCT <a href="http://main.id/">main.id</a>) |<br>+-------------------------+<br>| 0 |<br>+-------------------------+<br><br>Then i modified query a little removed:<br>(ObjectCustomFieldValues_3.Content LIKE '%1. Pending%')<br>and<br>(CustomFields_2.Name = 'Approval'))<br><br>changed from:<br>SELECT COUNT(DISTINCT <a href="http://main.id/">main.id</a>) <br>to <br>SELECT *<br><br>query:<br>SELECT * FROM (((Tickets main LEFT JOIN ObjectCustomFields ObjectCustomFields_1 ON ((ObjectCustomFields_1.ObjectId = '0')) AND( ObjectCustomFields_1.ObjectId = main.Queue)) LEFT JOIN CustomFields CustomFields_2 ON ( CustomFields_2.id = ObjectCustomFields_1.CustomField)) LEFT JOIN ObjectCustomFieldValues ObjectCustomFieldValues_3 ON ((ObjectCustomFieldValues_3.ObjectId = <a href="http://main.id/">main.id</a>)) AND( ObjectCustomFieldValues_3.CustomField = CustomFields_2.id) AND( (ObjectCustomFieldValues_3.Disabled = '0')) AND( (ObjectCustomFieldValues_3.ObjectType = 'RT::Ticket'))) WHERE ((main.EffectiveId = <a href="http://main.id/">main.id</a>)) AND ((main.Status != 'deleted')) AND ((main.Type = 'ticket')) order by main.LastUpdated desc limit 100 ;<br><br><br>some result:<br><br>| id | EffectiveId | Queue | Type | IssueStatement | Resolution | Owner | Subject | InitialPriority | FinalPriority | Priority | TimeEstimated | TimeWorked | Status | TimeLeft | Told | Starts | Started | Due | Resolved | LastUpdatedBy | LastUpdated | Creator | Created | Disabled | id | CustomField | ObjectId | SortOrder | Creator | Created | LastUpdatedBy | LastUpdated | id | Name | Type | Description | SortOrder | Creator | Created | LastUpdatedBy | LastUpdated | Disabled | LookupType | Repeated | Pattern | MaxValues | id | ObjectId | CustomField | Content | Creator | Created | LastUpdatedBy | LastUpdated | ObjectType | LargeContent | ContentType | ContentEncoding | SortOrder | Disabled |<br>+-------+-------------+-------+--------+----------------+------------+-------+---------------------------+-----------------+---------------+----------+---------------+------------+--------+----------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------+---------------------+---------+---------------------+----------+------+-------------+----------+-----------+---------+---------+---------------+-------------+------+------+------+-------------+-----------+---------+---------+---------------+-------------+----------+------------+----------+---------+-----------+------+----------+-------------+---------+---------+---------+---------------+-------------+------------+--------------+-------------+-----------------+-----------+----------+<br>| 22285 | 22285 | 6 | ticket | 0 | 0 | 91191 | Juniper | 20 | 39 | 22 | 0 | 0 | open | 0 | 2008-02-14 08:24:01 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | 2008-02-24 01:13:50 | 1970-01-01 00:00:00 | 620 | 2008-02-14 08:24:01 | 50067 | 2008-02-13 20:18:20 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |<br>| 22269 | 22269 | 53 | ticket | 0 | 0 | 93603 | Account | 10 | 29 | 19 | 0 | 30 | open | 0 | 2008-02-13 10:04:11 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | 2008-02-17 16:01:13 | 1970-01-01 00:00:00 | 5786 | 2008-02-14 07:00:43 | 93260 | 2008-02-12 16:01:13 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |<br>| 22286 | 22286 | 47 | ticket | 0 | 0 | 50067 | Server reboot | 10 | 29 | 14 | 0 | 60 | open | 0 | 2008-02-14 04:13:11 | 1970-01-01 00:00:00 | 1970-01-01 00:00:00 | 2008-02-19 02:50:52 | 1970-01-01 00:00:00 | 5786 | 2008-02-14 07:00:30 | 96040 | 2008-02-14 02:50:52 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |<br><br><br>Is this some kind of bug ? There shouldn't be so many NULLs <br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">-- </div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">Arkadiusz Jakubas</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; ">Arces Network, LLC</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 12px/normal Helvetica; "><a href="http://www.arces.net">http://www.arces.net</a></div></div></div></span> </div><br></body></html>