[Rt-devel] RT 3.3 Custom Field question

[Jesse Vincent]

"Show this custom field value when listing current values"

We keep old values around because we show them in ticket history.


On Fri, Nov 19, 2004 at 10:20:20AM -0500, Todd Chapman wrote:
> What does the 'Disabled' field mean for ObjectCustomFieldValues?
> 
> The comment below doesn't mean anything to me...
> 
> CREATE TABLE ObjectCustomFieldValues (
>   id INTEGER NOT NULL  AUTO_INCREMENT,
>   CustomField int NOT NULL  ,
>   ObjectType varchar(255) NOT NULL,         # Final target of the Object
>   ObjectId int NOT NULL  ,                  # New -- Replaces Ticket
>   SortOrder integer NOT NULL DEFAULT 0  ,   # New -- ordering for multiple
> +values
> 
>   Content varchar(255) NULL  ,
>   LargeContent LONGTEXT NULL,               # New -- to hold 255+ strings
>   ContentType varchar(80) NULL,             # New -- only text/* gets searched
>   ContentEncoding varchar(80) NULL  ,       # New -- for binary Content
> 
>   Creator integer NOT NULL DEFAULT 0  ,
>   Created DATETIME NULL  ,
>   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
>   LastUpdated DATETIME NULL  ,
>   Disabled int2 NOT NULL DEFAULT 0 ,        # New -- whether the value was
> +current
>   PRIMARY KEY (id)
> ) TYPE=InnoDB;
> 
> 
> Also, does it indicate that there is an RT bug when both of
> these records are in the table?:
> 
> mysql> select * from ObjectCustomFieldValues where ObjectId=517 and Content='123';
> +------+----------+-------------+---------+---------+---------------------+-----
> +----------+---------------------+------------+--------------+-------------+----
> +-------------+-----------+----------+
> | id   | ObjectId | CustomField | Content | Creator | Created             |
> +LastUpdatedBy | LastUpdated         | ObjectType | LargeContent | ContentType |
> +ContentEncoding | SortOrder | Disabled |
> +------+----------+-------------+---------+---------+---------------------+-----
> +----------+---------------------+------------+--------------+-------------+----
> +-------------+-----------+----------+
> | 6466 |      517 |           1 | 123     |      71 | 2004-11-16 19:12:16 | 71 | 2004-11-16 19:19:15 | RT::Ticket | NULL         | NULL        | |         0 |        1 |
> | 6468 |      517 |           8 | 123     |      71 | 2004-11-16 19:52:34 | 71 | 2004-11-16 19:54:55 | RT::Ticket | NULL         | NULL        | |         0 |        1 |
> | 6473 |      517 |           1 | 123     |      71 | 2004-11-16 20:32:14 | 71 | 2004-11-16 20:32:14 | RT::Ticket | NULL         | NULL        | |         0 |        0 |
> +------+----------+-------------+---------+---------+---------------------+-----
> +----------+---------------------+------------+--------------+-------------+----
> +-------------+-----------+----------+
> 3 rows in set (0.00 sec)
> 
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-devel
> 

--