Fun with CF order (3.8)

Hi all,

We’ve slowly been adding custom fields as our installation has matured,
and I’m now trying to go back and tidy them up a bit but am running into
trouble.

  1. Changing the order of custom fields doesn’t seem to affect existing
    tickets? (Even with logout/log-in, or cycling RT)

  2. I had a custom field on several queues that has been superseded by
    a global CF of the same name, but I cannot seem to unselect the queue-
    specific version of the CF, which I am hoping would cause the field to heed
    its global ordering. If I disable the Ticket-CF, the field does not display at
    all in queues where the Ticket-CF was initially used…

A cursory search turned up nothing in the usual places, nor the CustomFields
table.
Cambridge Energy Alliance: Save money. Save the planet.

Jerrard,

I believe there is a fix either in recent RT or DBIx::SB. Heavily
depends on DB, RT and DBIx::SB versions combination, tricky SQL.On Thu, Oct 22, 2009 at 8:38 PM, Jerrad Pierce jpierce@cambridgeenergyalliance.org wrote:

Hi all,

We’ve slowly been adding custom fields as our installation has matured,
and I’m now trying to go back and tidy them up a bit but am running into
trouble.

  1. Changing the order of custom fields doesn’t seem to affect existing
    tickets? (Even with logout/log-in, or cycling RT)

  2. I had a custom field on several queues that has been superseded by
    a global CF of the same name, but I cannot seem to unselect the queue-
    specific version of the CF, which I am hoping would cause the field to heed
    its global ordering. If I disable the Ticket-CF, the field does not display at
    all in queues where the Ticket-CF was initially used…

A cursory search turned up nothing in the usual places, nor the CustomFields
table.

Cambridge Energy Alliance: Save money. Save the planet.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

I believe there is a fix either in recent RT or DBIx::SB. Heavily
depends on DB, RT and DBIx::SB versions combination, tricky SQL.
I’m running the latest SearchBuilder (1.56), a somewhat stale RT
(3.8.1, will upgrade to 3.8.6 after it’s been out awhile) and unfortunately
my distribution’s older MySQL (4.1.22)…

Cambridge Energy Alliance: Save money. Save the planet.

I believe there is a fix either in recent RT or DBIx::SB. Heavily
depends on DB, RT and DBIx::SB versions combination, tricky SQL.
I’m running the latest SearchBuilder (1.56), a somewhat stale RT
(3.8.1, will upgrade to 3.8.6 after it’s been out awhile) and unfortunately
my distribution’s older MySQL (4.1.22)…
Problem persists in “3.8.6”; updated codebase, have not yet upgraded db.

I’m not sure I understand how it’s configuration dependent though,
when the UI provides
a mechanism for explicitly dictating the order of custom fields.
Cambridge Energy Alliance: Save money. Save the planet.