Re: [rt-users] ObjectCustomFieldValues weirdness

2009-03-04 Thread 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

Re: [rt-users] ObjectCustomFieldValues weirdness

2009-03-04 Thread Stephen Cochran
Disabled was the column I missed thanks. Now I won't get double matches/count on some report queries by Category! On Wed, Mar 4, 2009 at 1:29 PM, Kenneth Crocker kfcroc...@lbl.gov wrote: Stephen, Well, it could be a couple of things. First, and simplest, is the one with the earliest

[rt-users] ObjectCustomFieldValues weirdness

2009-03-03 Thread Stephen Cochran
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;

Re: [rt-users] ObjectCustomFieldValues weirdness

2009-03-03 Thread Stephen Cochran
I should add that the two results do have different Created values: +---+--+--+-+-+ | id| ObjectId | Content | LastUpdated | Created | +---+--+--+-+-+ |