[rt-users] ObjectCustomFieldValues weirdness

[Kenneth Crocker]

Stephen,


	Well, it could be a couple of things. First, and simplest, is the one 
with the earliest creation date may be disabled. You didn't show that 
field from the DataBase so I can't say for sure that is it. When a user 
changes the value for a CF (defined as "select one value") on a ticket, 
it keeps the old record and flags it as disabled and then creates a new 
one for the new value. You could find out about this by looking at your 
transaction table. It would most likely show there, since those kind of 
changes can be seen in a ticket's history.
	The other possibility is that the Custom Field was defined as "Select 
Multiple Values" and the user selected a single value and then selected 
another, or selected both at the same time. Either way, you will end up 
with two records for the same Custom Field for the same ticket and both 
will be enabled. Hope this helps.

Kenn
LBNL

On 3/3/2009 9:12 PM, Stephen Cochran wrote:
> I should add that the two results do have different Created values:
> 
> +-------+----------+----------+---------------------+---------------------+
> | id    | ObjectId | Content  | LastUpdated         | Created             |
> +-------+----------+----------+---------------------+---------------------+
> | 24363 |    80487 | Email    | 2009-02-25 13:23:16 | 2009-02-23 14:20:58 |
> | 24544 |    80487 | Hardware | 2009-02-25 13:23:16 | 2009-02-25 13:23:16 |
> +-------+----------+----------+---------------------+---------------------+
> 2 rows in set (0.00 sec)
> 
> 
> 
> On Wed, Mar 4, 2009 at 12:06 AM, Stephen Cochran 
> <stephen.a.cochran.lists at cahir.net 
> <mailto:stephen.a.cochran.lists at cahir.net>> wrote:
> 
> 
>     Any idea why I'd be seeing the following in the
>     ObjectCustomFieldValues table:
> 
>     mysql> select id, CustomField, ObjectType, ObjectId, Content,
>     LastUpdated from ObjectCustomFieldValues where Objectid = 80487 and
>     CustomField = 5;
>     +-------+-------------+------------+----------+----------+---------------------+
>     | id    | CustomField | ObjectType | ObjectId | Content  |
>     LastUpdated         |
>     +-------+-------------+------------+----------+----------+---------------------+
>     | 24363 |           5 | RT::Ticket |    80487 | Email    |
>     2009-02-25 13:23:16 |
>     | 24544 |           5 | RT::Ticket |    80487 | Hardware |
>     2009-02-25 13:23:16 |
>     +-------+-------------+------------+----------+----------+---------------------+
>     2 rows in set (0.00 sec)
> 
>     Two rows being inserted at exactly the same time with different
>     Contents?
> 
>     FWIW, came across this while pulling out TimeTaken info from the
>     Transactions table and mapping it to a Category custom field. Was
>     getting duplicates that it took me a while to track down.
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com