(For some reason, my message was cut off in the previous post.)
All -
I would like to get opinions on repairing my database using SQL. If
there is a more graceful way to accomplish this using the RT perl
modules (RT::CachedGroupMembers, etc) any help is appreciated.
>From the "RT Essentials" book, we find that in
CachedGroupMembers:
id == any incremental value
GroupId == requestor group id
MemberId == MemberId in question (requestor)
Via == usually equal to the CachedGroupMembers id
ImmediateParentId == requestor group id
Disabled == 0
I'm going to work from the values in Ticket #1 (see previous message).
insert into CachedGroupMembers values ('', '52', '34', '', '52', '0');
** And Voila! ** The requestor appears in the regular Search as
expected, and is searchable by requestor in Query Builder.
And here is what it looks like in the end:
mysql> select * from CachedGroupMembers where GroupId='52' and
MemberId='34' and ImmediateParentId='52';
+-------+---------+----------+------+-------------------+----------+
| id | GroupId | MemberId | Via | ImmediateParentId | Disabled |
+-------+---------+----------+------+-------------------+----------+
| 81550 | 52 | 34 | 0 | 52 | 0 |
+-------+---------+----------+------+-------------------+----------+
Should the Disabled status be pulled from Principals? (select Disabled
from Principals where id = '34')
Any opinions on making these modifications is appreciated.
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
