RT 3.6.1 - customfield single-value freeform adds new record for each value update?

RT Users
1

Hello,

we have upgraded to RT 3.6.1 from 3.0.12.

I used to query the database with external SQL-scripts.
So I found, that RT3.6.1 will store ‘a history of all values’ that a
single-value freeform field was filled with.

Looks to me that this was different in 3.0.12. There I found only the
last given value for that field in the database.

Is there a possibility to prevent RT from adding new records to
ObjectCustomFieldValues each time the user invokes a single-value field
update?

Best Regards,
Olaf Hamann

2

-----Original Message-----

Hello,

we have upgraded to RT 3.6.1 from 3.0.12.

I used to query the database with external SQL-scripts.
So I found, that RT3.6.1 will store ‘a history of all values’ that a
single-value freeform field was filled with.

Looks to me that this was different in 3.0.12. There I found only the
last given value for that field in the database.

Is there a possibility to prevent RT from adding new records to
ObjectCustomFieldValues each time the user invokes a
single-value field
update?

Best Regards,
Olaf Hamann

Olaf,

Did you filter out the deleted values (i.e. where Disabled is not 1)?

Steve

Stephen Turner
Senior Programmer/Analyst - Client Support Services
MIT Information Services and Technology (IS&T)

3

Oh my goodness …!
Thank you very much for your patient reply!

Olaf

Stephen Turner wrote:
…