[rt-users] TicketCustomFieldValues = ObjectCustomFieldValues ?

[Mike Patterson]

I just came across another snag in my migration (3.4.2 -> 3.4.5) migration

slap my wrist for not using RT's API...
however we already have a bunch of reports calling on the mysql database 
table TicketCustomFieldValues and I don't want overhaul all those pages 
just yet.

Can I simply substitute the table name ObjectCustomFieldValues for 
TicketCustomFieldValues in our non-api aware code or is there something 
more complicated that I need to be aware of?

Browsing around the database it looks fairly similar..

Thanks,
Mike

some code snippets below:
---------------------------
$sql = "SELECT TicketCustomFieldValues.CustomField, 
TicketCustomFieldValues.Content FROM TicketCustomFieldValues";
$conditions = " WHERE (TicketCustomFieldValues.CustomField = 9) AND 
(TicketCustomFieldValues.Content IS NOT NULL)";
$group_by = ' GROUP BY TicketCustomFieldValues.Content ';
$order_by = ' ORDER BY TicketCustomFieldValues.Content ';

$sql = "SELECT COUNT(Tickets.Id) AS Created FROM Tickets, 
TicketCustomFieldValues";
$conditions = " WHERE (Tickets.Id = TicketCustomFieldValues.Ticket) AND 
(Tickets.Id = Tickets.EffectiveId) AND 
(TicketCustomFieldValues.CustomField = 9) AND 
(TicketCustomFieldValues.Content = '{$vars['department']}') AND 
(Tickets.Id IS NOT NULL) AND (" . $this->exclude_rt_queues('id') . ") AND ";
$group_by = "";

$sql = "SELECT SUM(CASE WHEN Tickets.Status = 'resolved' THEN 1 ELSE 0 
END) AS Resolved FROM Tickets, TicketCustomFieldValues";
$conditions = " WHERE (Tickets.Id = TicketCustomFieldValues.Ticket) AND 
(Tickets.Id = Tickets.EffectiveId) AND 
(TicketCustomFieldValues.CustomField = 9) AND 
(TicketCustomFieldValues.Content = '{$vars['department']}') AND 
(Tickets.Id IS NOT NULL) AND (" . $this->exclude_rt_queues('id') . ") AND ";
$group_by = "";

-- 
Mike Patterson
Systems Manager
UC Berkeley Extension