Changes to rules after 5.4 Install
I'm in the planning phase for the upgrade of our K1000 to version 5.4. Due to the changes in the table structure for the custom rules I'm trying to figure out how much time I'll need to update my custom rules that reference the current CUSTOM_FIELD_VALUE* columns in the HD_TICKET table. From what I understand any rules that reference these columns will need to be updated to refer to the new table that will store the custom fields and their values.
Has anyone gone through this process? If so, could you provide some details related to the table structure so that I can do some advanced planning? I have already exported all of my rules so that I can begin to determine which need updated but I'd like to have an idea of how difficult some of them will be in advance.
Community Chosen Answer
Sorry IT took me so long to get back to you Chuck, Geez with the holidays and 5.4 roll-out and all I've just totally let this drop off my radar! You probably already found the answer elsewhere but just for the threads continuity and the benefit of others here goes....
The joins for these tables is as follows
HD_TICKET.ID = HD_TICKET_CHANGE.HD_TICKET_ID
HD_TICKET.<file_name> = HD_FIELD.HD_TICKET_FIELD_NAME
Hope this helps with the new DB structure