[Rt-devel] Problem with CF for Users

[Björn Schulz]

Hi Kevin,

Am 08.02.11 17:40, schrieb Kevin Falcone:
> On Tue, Feb 08, 2011 at 02:49:17PM +0100, Björn Schulz wrote:
>> Hi all,
>>
>> we've a problem with custom fields for users on rt 3.8.8.
> 
> It is worth noting that Tickets_Overlay.pm has a LimitCustomField but
> Users is falling back to the generic code in RT::SearchBuilder.
> I suggest a ->BuildSelectQuery to confirm what the sql is doing, but
> if I had to guess, I'd suspect that Users isn't skipping disabled OCFV
> records, which means that the old value for that user is found.

sql is doing everything right.

mysql> select Customfield, ObjectType, ObjectId, Content, Disabled from
 ObjectCustomFieldValues where ObjectType ='RT::User' and
Customfield=126  and ObjectId=1227122;
+-------------+------------+----------+---------+----------+
| Customfield | ObjectType | ObjectId | Content | Disabled |
+-------------+------------+----------+---------+----------+
|         126 | RT::User   |  1227122 | A9428   |        1 |
|         126 | RT::User   |  1227122 | A9488   |        0 |
+-------------+------------+----------+---------+----------+
2 rows in set (0.00 sec)

Do you thing this is a bug?

Cheers,
 Björn

> 
> -kevin
>