Re: [rt-users] Search Assets by People gives "No assets matching search criteria found."
Hi Martin,
Thanks. Looks like I need to do the upgrade. Wasn't planning on that!
Kind regards,
Tom
Tom Robinson
IT Manager/System Administrator
MoTeC Pty Ltd
121 Merrindale Drive
Croydon South
3136 Victoria
Australia
T: +61 3 9761 5050
F: +61 3 9761 5051
E: tom.robin...@motec.com.au
On 03/11/16 21:30, Martin Wheldon wrote:
> Hi Tom,
>
> Just tried this on my RT 4.4.1 install and it works fine, this is probably
> this bug?
>
> From the release notes of RT 4.4.1
> * Fix searching for people associated with Assets (I#31546)
>
> Best Regards
>
> Martin
>
> On 2016-11-03 00:01, Tom Robinson wrote:
>> Sorry, forgot to mentions I'm using RT4 version 4.4.0
>>
>>
>> On 03/11/16 10:37, Tom Robinson wrote:
>>> Hi,
>>>
>>> I'm trying to search my Assets database by People (Owner, Contact or Held
>>> By) but always get "No
>>> assets matching search criteria found.".
>>>
>>> I think there may be an issue with the created query as I'm seeing an error
>>> in the logs. Anyone know
>>> what is causing this?
>>>
>>> Kind regards,
>>> Tom
>>>
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $args{"GroupsAlias"} in hash
>>> element at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
>>> (/usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm:153)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value
>>> $args{"GroupsAlias"} in hash element
>>> at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
>>> $args{"ALIAS1"} in
>>> concatenation (.) or string at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1086)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value
>>> $args{"ALIAS1"} in concatenation (.)
>>> or string at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value in
>>> string eq at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1282)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value in string eq
>>> at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: DBD::mysql::st execute failed:
>>> You have an error in
>>> your SQL syntax; check the manual that corresponds to your MySQL server
>>> version for the right syntax
>>> to use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain =
>>> 'RT::Asset-Role' ) AND ( Groups_1' at
>>> line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
>>>
>>> ==> messages <==
>>> Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You have
>>> an error in your SQL
>>> syntax; check the manual that corresponds to your MySQL server version for
>>> the right syntax to use
>>> near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND
>>> ( Groups_1' at line 1 at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>>>
>>> ==> httpd/error_log <==
>>> [2409] [Wed Nov 2 23:36:26 2016] [warning]: RT::Handle=HASH(0x8a09ae8)
>>> couldn't execute the query
>>> 'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
>>> CachedGroupMembers_3 ON (
>>> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
>>> .id ) JOIN Groups
>>> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
>>> 'Owner' ) AND (
>>> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
>>> ON (
>>> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
>>> Groups_1.id ) WHERE ( (
>>> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId
>>> = '0' ) ) AND
>>> (main.Catalog = '4') AND (main.Status != 'deleted') ' at
>>> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
>>>
>>> DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
>>> "SELECT COUNT(DISTINCT
>>> main.id) FROM Assets main JOIN CachedGr"...) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm
>>> line 295
>>> DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/SearchBuilder.pm line 993
>>> RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/rt4/lib/RT/Assets.pm line 293
>>> RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>>> /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1471
>>> DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called at
>>>
Re: [rt-users] Search Assets by People gives "No assets matching search criteria found."
Hi Tom,
Just tried this on my RT 4.4.1 install and it works fine, this is
probably this bug?
From the release notes of RT 4.4.1
* Fix searching for people associated with Assets (I#31546)
Best Regards
Martin
On 2016-11-03 00:01, Tom Robinson wrote:
Sorry, forgot to mentions I'm using RT4 version 4.4.0
On 03/11/16 10:37, Tom Robinson wrote:
Hi,
I'm trying to search my Assets database by People (Owner, Contact or
Held By) but always get "No
assets matching search criteria found.".
I think there may be an issue with the created query as I'm seeing an
error in the logs. Anyone know
what is causing this?
Kind regards,
Tom
==> httpd/error_log <==
[2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized
value $args{"GroupsAlias"} in hash
element at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
(/usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm:153)
==> messages <==
Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value
$args{"GroupsAlias"} in hash element
at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
==> httpd/error_log <==
[2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized
value $args{"ALIAS1"} in
concatenation (.) or string at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1086)
==> messages <==
Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value
$args{"ALIAS1"} in concatenation (.)
or string at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
1086.
==> httpd/error_log <==
[2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized
value in string eq at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1282)
==> messages <==
Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value in
string eq at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
==> httpd/error_log <==
[2409] [Wed Nov 2 23:36:26 2016] [warning]: DBD::mysql::st execute
failed: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax
to use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain =
'RT::Asset-Role' ) AND ( Groups_1' at
line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line
586.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
==> messages <==
Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You
have an error in your SQL
syntax; check the manual that corresponds to your MySQL server version
for the right syntax to use
near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role'
) AND ( Groups_1' at line 1 at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
==> httpd/error_log <==
[2409] [Wed Nov 2 23:36:26 2016] [warning]:
RT::Handle=HASH(0x8a09ae8) couldn't execute the query
'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN
CachedGroupMembers CachedGroupMembers_3 ON (
CachedGroupMembers_3.Disabled = '0' ) AND (
CachedGroupMembers_3.GroupId = .id ) JOIN Groups
Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (
Groups_1.Name = 'Owner' ) AND (
Groups_1.Instance = main.id ) JOIN CachedGroupMembers
CachedGroupMembers_2 ON (
CachedGroupMembers_2.Disabled = '0' ) AND (
CachedGroupMembers_2.GroupId = Groups_1.id ) WHERE ( (
CachedGroupMembers_2.MemberId = '22' ) OR (
CachedGroupMembers_3.MemberId = '0' ) ) AND
(main.Catalog = '4') AND (main.Status != 'deleted') ' at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
"SELECT COUNT(DISTINCT
main.id) FROM Assets main JOIN CachedGr"...) called at
/usr/local/share/perl5/DBIx/SearchBuilder.pm
line 295
DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0))
called at
/usr/local/rt4/lib/RT/SearchBuilder.pm line 993
RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called
at
/usr/local/rt4/lib/RT/Assets.pm line 293
RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
/usr/local/share/perl5/DBIx/SearchBuilder.pm line 1471
DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called
at
/var/www/rt4/Asset/Search/index.html line 57
HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "",
"CF.{OS}", "", "CF.{Express
Service Code}", "", "Status", "", "CF.{Asset Number}", ...) called at
/usr/local/share/perl5/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0xa667330),
"!CF.{Asset
Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "",
"Status", "", ...) called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1302
eval {...} called at
/usr/local/share/perl5/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset
Number}", "", "CF.{OS}", "",
"CF.{Express Service Code}", "", ...) called at
Re: [rt-users] Search Assets by People gives "No assets matching search criteria found."
Sorry, forgot to mentions I'm using RT4 version 4.4.0
On 03/11/16 10:37, Tom Robinson wrote:
> Hi,
>
> I'm trying to search my Assets database by People (Owner, Contact or Held By)
> but always get "No
> assets matching search criteria found.".
>
> I think there may be an issue with the created query as I'm seeing an error
> in the logs. Anyone know
> what is causing this?
>
> Kind regards,
> Tom
>
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
> $args{"GroupsAlias"} in hash
> element at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
> (/usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm:153)
>
> ==> messages <==
> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value
> $args{"GroupsAlias"} in hash element
> at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
> $args{"ALIAS1"} in
> concatenation (.) or string at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1086)
>
> ==> messages <==
> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value $args{"ALIAS1"}
> in concatenation (.)
> or string at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value in
> string eq at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1282)
>
> ==> messages <==
> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value in string eq at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: DBD::mysql::st execute failed:
> You have an error in
> your SQL syntax; check the manual that corresponds to your MySQL server
> version for the right syntax
> to use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role'
> ) AND ( Groups_1' at
> line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
>
> ==> messages <==
> Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You have an
> error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use
> near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (
> Groups_1' at line 1 at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: RT::Handle=HASH(0x8a09ae8)
> couldn't execute the query
> 'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
> CachedGroupMembers_3 ON (
> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
> .id ) JOIN Groups
> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
> 'Owner' ) AND (
> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
> ON (
> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
> Groups_1.id ) WHERE ( (
> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId =
> '0' ) ) AND
> (main.Catalog = '4') AND (main.Status != 'deleted') ' at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
> DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
> "SELECT COUNT(DISTINCT
> main.id) FROM Assets main JOIN CachedGr"...) called at
> /usr/local/share/perl5/DBIx/SearchBuilder.pm
> line 295
> DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
> /usr/local/rt4/lib/RT/SearchBuilder.pm line 993
> RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
> /usr/local/rt4/lib/RT/Assets.pm line 293
> RT::Assets::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
> /usr/local/share/perl5/DBIx/SearchBuilder.pm line 1471
> DBIx::SearchBuilder::Count(RT::Assets=HASH(0xa8943c0)) called at
> /var/www/rt4/Asset/Search/index.html line 57
> HTML::Mason::Commands::__ANON__("!CF.{Asset Number}", "", "CF.{OS}",
> "", "CF.{Express
> Service Code}", "", "Status", "", "CF.{Asset Number}", ...) called at
> /usr/local/share/perl5/HTML/Mason/Component.pm line 135
>
> HTML::Mason::Component::run(HTML::Mason::Component::FileBased=HASH(0xa667330),
> "!CF.{Asset
> Number}", "", "CF.{OS}", "", "CF.{Express Service Code}", "", "Status", "",
> ...) called at
> /usr/local/share/perl5/HTML/Mason/Request.pm line 1302
> eval {...} called at /usr/local/share/perl5/HTML/Mason/Request.pm
> line 1292
> HTML::Mason::Request::comp(undef, undef, undef, "!CF.{Asset Number}",
> "", "CF.{OS}", "",
> "CF.{Express Service Code}", "", ...) called at
> /usr/local/rt4/lib/RT/Interface/Web.pm line 696
>
Re: [rt-users] Search Assets by People gives "No assets matching search criteria found."
Trying to sift through this SQL query, I've reformatted for a bit of clarity:
SELECT COUNT(DISTINCT main.id)
FROM Assets main
JOIN CachedGroupMembers CachedGroupMembers_3
ON ( CachedGroupMembers_3.Disabled = '0' )
AND ( CachedGroupMembers_3.GroupId = .id )
JOIN Groups Groups_1
ON ( Groups_1.Domain = 'RT::Asset-Role' )
AND ( Groups_1.Name = 'Owner' )
AND ( Groups_1.Instance = main.id )
JOIN CachedGroupMembers CachedGroupMembers_2
ON ( CachedGroupMembers_2.Disabled = '0' )
AND ( CachedGroupMembers_2.GroupId = Groups_1.id )
WHERE ( ( CachedGroupMembers_2.MemberId = '22' )
OR ( CachedGroupMembers_3.MemberId = '0' ) )
AND (main.Catalog = '4')
AND (main.Status != 'deleted'
OR main.Status != 'deleted'
OR main.Status != 'deleted')
I notice in the first JOIN there appears to be an orphaned '.id'. Is there
something missing there?
AND ( CachedGroupMembers_3.GroupId = .id )
To what should that .id be associated?
Also, how would one go about repairing this?
Kind regards,
Tom
On 03/11/16 10:37, Tom Robinson wrote:
> Hi,
>
> I'm trying to search my Assets database by People (Owner, Contact or Held By)
> but always get "No
> assets matching search criteria found.".
>
> I think there may be an issue with the created query as I'm seeing an error
> in the logs. Anyone know
> what is causing this?
>
> Kind regards,
> Tom
>
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
> $args{"GroupsAlias"} in hash
> element at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
> (/usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm:153)
>
> ==> messages <==
> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value
> $args{"GroupsAlias"} in hash element
> at /usr/local/rt4/lib/RT/SearchBuilder/Role/Roles.pm line 153.
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value
> $args{"ALIAS1"} in
> concatenation (.) or string at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1086)
>
> ==> messages <==
> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value $args{"ALIAS1"}
> in concatenation (.)
> or string at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1086.
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: Use of uninitialized value in
> string eq at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:1282)
>
> ==> messages <==
> Nov 3 10:36:26 marshal RT: [2409] Use of uninitialized value in string eq at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 1282.
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: DBD::mysql::st execute failed:
> You have an error in
> your SQL syntax; check the manual that corresponds to your MySQL server
> version for the right syntax
> to use near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role'
> ) AND ( Groups_1' at
> line 1 at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
> (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
>
> ==> messages <==
> Nov 3 10:36:26 marshal RT: [2409] DBD::mysql::st execute failed: You have an
> error in your SQL
> syntax; check the manual that corresponds to your MySQL server version for
> the right syntax to use
> near ') JOIN Groups Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND (
> Groups_1' at line 1 at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
>
> ==> httpd/error_log <==
> [2409] [Wed Nov 2 23:36:26 2016] [warning]: RT::Handle=HASH(0x8a09ae8)
> couldn't execute the query
> 'SELECT COUNT(DISTINCT main.id) FROM Assets main JOIN CachedGroupMembers
> CachedGroupMembers_3 ON (
> CachedGroupMembers_3.Disabled = '0' ) AND ( CachedGroupMembers_3.GroupId =
> .id ) JOIN Groups
> Groups_1 ON ( Groups_1.Domain = 'RT::Asset-Role' ) AND ( Groups_1.Name =
> 'Owner' ) AND (
> Groups_1.Instance = main.id ) JOIN CachedGroupMembers CachedGroupMembers_2
> ON (
> CachedGroupMembers_2.Disabled = '0' ) AND ( CachedGroupMembers_2.GroupId =
> Groups_1.id ) WHERE ( (
> CachedGroupMembers_2.MemberId = '22' ) OR ( CachedGroupMembers_3.MemberId =
> '0' ) ) AND
> (main.Catalog = '4') AND (main.Status != 'deleted') ' at
> /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
> DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x8a09ae8),
> "SELECT COUNT(DISTINCT
> main.id) FROM Assets main JOIN CachedGr"...) called at
> /usr/local/share/perl5/DBIx/SearchBuilder.pm
> line 295
> DBIx::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
> /usr/local/rt4/lib/RT/SearchBuilder.pm line 993
> RT::SearchBuilder::_DoCount(RT::Assets=HASH(0xa8943c0)) called at
>
