RT3: Statistics not plotting graphs (fwd)

Ahhhhh I figured it out
I have to name the custom fields a special way
How was I supposed to know that? :frowning:

Hello,

Could anybody, please, explain me, which special things I have to do do be
able to sort by custom fields. I have this piece of code:

<%INIT>
my $rows = 150;

my $MyTickets = RT::Tickets->new($session{‘CurrentUser’});
$MyTickets->LimitWatcher(TYPE => ‘Requestor’, VALUE =>
session{‘CurrentUser’}->EmailAddress);
$MyTickets->RowsPerPage($rows);
$MyTickets->OrderBy(FIELD => $TicketsSortBy, ORDER => $TicketsSortOrder);
</%INIT>

Sort by any other fields works just fine. But when I try to sort by a custom
field all the tickets disappear and nothing shows up.

Thanks,

Dimitry

Nobody can help me with this? :-(-----Original Message-----
From: Dimitry Faynerman [mailto:dimitry.faynerman@hypermediasystems.com]
Sent: Monday, March 29, 2004 8:22 AM
To: ‘rt-users@lists.bestpractical.com’
Subject: custom fields and new ticket

Hello,

Can anybody, please, explain me how I should work with custom fields when
creating a new ticket. I created them from “Global”/“Custom fields menu”.
I’m able to modify their values from “Basics” tab and I’m able to show their
values from the Display.html (I use my own template).

But the problem is when I create a new ticket, absolutely nothing goes into
TicketCustomFieldValues table.

What am I missing here?

Thanks!

Dimitry

Nobody can help me with this? :frowning:
Nobody knows what you’re actually trying to achieve…
Custom fields can be modified via the web interface (as you’re doing), and via
email (search this list).
What more are you expecting?
Cerion

Nobody knows what you’re actually trying to achieve…
Custom fields can be modified via the web interface (as you’re doing), and
via
email (search this list).
What more are you expecting?
Cerion

Didn’t I clearly explain the problem?
I said: “… absolutely nothing goes into TicketCustomFieldValues table.”
That was what I expected - I expected some recordss in this table.

BTW I found out what the problem was over a week ago. Did you check the
archives?

-----Original Message-----
From: Dimitry Faynerman [mailto:dimitry.faynerman@hypermediasystems.com]
Sent: Monday, March 29, 2004 8:22 AM
To: ‘rt-users@lists.bestpractical.com’
Subject: custom fields and new ticket

Hello,

Can anybody, please, explain me how I should work with custom fields when
creating a new ticket. I created them from “Global”/“Custom fields menu”.
I’m able to modify their values from “Basics” tab and I’m able to show
their values from the Display.html (I use my own template).

But the problem is when I create a new ticket, absolutely nothing goes
into
TicketCustomFieldValues table.

What am I missing here?

Thanks!

Dimitry


The rt-users Archives

RT Training is coming to town this summer!
Sign up for an RT Developer/Administrator class in DC, LA or Frankfurt by
emailing training@bestpractical.com

For more details, check out
http://www.bestpractical.com/services/training.html

The RT Wiki lives at http://wiki.bestpractical.com Read! Join! Contribute!

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

RT Training is coming to town this summer!
Sign up for an RT Developer/Administrator class in DC, LA or Frankfurt by
emailing training@bestpractical.com

For more details, check out
http://www.bestpractical.com/services/training.html

The RT Wiki lives at http://wiki.bestpractical.com Read! Join! Contribute!

Hi, users,

Last few days I was hacking on a solution and have something for you to try.

  1. New release of DBIx::SearchBuilder. You can download it from the
    CPAN near you soon or using
    http://pause.cpan.org/incoming/DBIx-SearchBuilder-1.52.tar.gz .

I really recommend you to run make test against your DB server before
installing it. Do the following:

perl Makefile.PL
make
SB_TEST_MYSQL=db_to_test_in SB_TEST_MYSQL_USER=test_user
SB_TEST_MYSQL_PASS=password make test

Where “db_to_test” is the name of the DB you’re going to test against,
test files will create temporary tables in that DB. To run it safe use
clean DB or DB you use for other experiments, DON"T RUN TESTS ON
ANY DB THAT HAS PRODUCTION DATA
.

Other valid prefixes for ENV vars are SB_TEST_ORACLE, SB_TEST_PG and
SB_TEST_SQLITE.

Once it succeeded you can run make install command.
After installing you have to stop and start your web server
to apply the changes.

  1. As well I attach patch for RT that should add link to titles of
    custom field columns in search results. So you can click those to order
    by a CF and change ordering. To see the change you have to purge mason
    cache, just drop me a note if you don’t know how.

After installing sorting should be correct in almost all
situations, but I know at least one issue when it’s not true. The order
is wrong when you sort by CF X, limit search by this CF and it can
have multiple values. I’m working on a fix for this.

Waiting for your feedback.

Best regards, Ruslan.

RT-3.6.6-allow_sort_by_cf_from_results.patch (440 Bytes)

Hi, new fixed version of DBIx::SearchBuilder on its way to the CPAN.

Tested with Pg 8.3, mysql 5.0, some SQLite and Oracle 10.

Test on other DBs please.On Tue, Apr 1, 2008 at 7:51 AM, Ruslan Zakirov ruz@bestpractical.com wrote:

Hi, users,

Last few days I was hacking on a solution and have something for you to try.

  1. New release of DBIx::SearchBuilder. You can download it from the
    CPAN near you soon or using
    http://pause.cpan.org/incoming/DBIx-SearchBuilder-1.52.tar.gz .

I really recommend you to run make test against your DB server before
installing it. Do the following:

perl Makefile.PL
make
SB_TEST_MYSQL=db_to_test_in SB_TEST_MYSQL_USER=test_user
SB_TEST_MYSQL_PASS=password make test

Where “db_to_test” is the name of the DB you’re going to test against,
test files will create temporary tables in that DB. To run it safe use
clean DB or DB you use for other experiments, DON"T RUN TESTS ON
ANY DB THAT HAS PRODUCTION DATA
.

Other valid prefixes for ENV vars are SB_TEST_ORACLE, SB_TEST_PG and
SB_TEST_SQLITE.

Once it succeeded you can run make install command.
After installing you have to stop and start your web server
to apply the changes.

  1. As well I attach patch for RT that should add link to titles of
    custom field columns in search results. So you can click those to order
    by a CF and change ordering. To see the change you have to purge mason
    cache, just drop me a note if you don’t know how.

After installing sorting should be correct in almost all
situations, but I know at least one issue when it’s not true. The order
is wrong when you sort by CF X, limit search by this CF and it can
have multiple values. I’m working on a fix for this.

Waiting for your feedback.


Best regards, Ruslan.

Best regards, Ruslan.