[rt-users] Start

2013-12-24 Thread Albert Shih
Hi

In 4.0.x I use inside my search something like 

and Starts  'Today'

to specify the starting date of this ticket is  than today. 

After ugrading to 4.2.1 it's not working anymore. 

Anyone can tell me what's is the new syntax ? 

Thanks lot.

merry christmas

Regards.



-- 
Albert SHIH
DIO bâtiment 15
Observatoire de Paris
5 Place Jules Janssen
92195 Meudon Cedex
France
Téléphone : +33 1 45 07 76 26/+33 6 86 69 95 71
xmpp: j...@obspm.fr
Heure local/Local time:
mar 24 déc 2013 17:32:50 CET


Re: [rt-users] Start

2013-12-24 Thread Alex Vandiver
On Tue, 2013-12-24 at 17:37 +0100, Albert Shih wrote:
 In 4.0.x I use inside my search something like 
 
 and Starts  'Today'
 
 to specify the starting date of this ticket is  than today. 
 
 After ugrading to 4.2.1 it's not working anymore. 

In RT 4.0, this search also found tickets where Starts was not set; this
is no longer true in RT 4.2.  Unfortunately, as this was an
almost-unintended change, there is currently no way to search for
tickets which have no Starts date set.  I've pushed a branch for 4.2.2
which will resolve this; the ticketsql syntax will be 'Starts IS NULL'

 - Alex




Re: [rt-users] Start

2013-12-24 Thread Albert Shih
 Le 24/12/2013 à 12:27:35-0500, Alex Vandiver a écrit
 On Tue, 2013-12-24 at 17:37 +0100, Albert Shih wrote:
  In 4.0.x I use inside my search something like 
  
  and Starts  'Today'
  
  to specify the starting date of this ticket is  than today. 
  
  After ugrading to 4.2.1 it's not working anymore. 
 
 In RT 4.0, this search also found tickets where Starts was not set; this
 is no longer true in RT 4.2.  Unfortunately, as this was an
 almost-unintended change, there is currently no way to search for
 tickets which have no Starts date set.  I've pushed a branch for 4.2.2

OK. 

 which will resolve this; the ticketsql syntax will be 'Starts IS NULL'


I take this moment to say, RT is very very good software.work like a
charm, very few bug, and when a bug appear they are always someone to
answer. 

So thanks you very much and Merry Christmas. 

Regards.

JAS
-- 
Albert SHIH
DIO bâtiment 15
Observatoire de Paris
5 Place Jules Janssen
92195 Meudon Cedex
France
Téléphone : +33 1 45 07 76 26/+33 6 86 69 95 71
xmpp: j...@obspm.fr
Heure local/Local time:
mar 24 déc 2013 21:47:21 CET


Re: [rt-users] Start page is displaied when DB is unavalable

2013-03-29 Thread Asanka Gunasekera
:) thanks Reslan, Regards

Asanka



 From: Ruslan Zakirov r...@bestpractical.com
To: Asanka Gunasekera asanka_gunasek...@yahoo.co.uk 
Cc: RT User List rt-users@lists.bestpractical.com 
Sent: Friday, 29 March 2013, 1:33
Subject: Re: [rt-users] Start page is displaied when DB is unavalable
 
On Thu, Mar 28, 2013 at 10:23 PM, Asanka Gunasekera
asanka_gunasek...@yahoo.co.uk wrote:
 Thank you Ruslan, hope I will not break what is working :) and is this fixed
 on later releases since I am planning on doing an upgrade to the latust

It's not at the moment and I don't know if it's on anybody's radar.

 Best Regards

 
 From: Ruslan Zakirov r...@bestpractical.com
 To: Asanka Gunasekera asanka_gunasek...@yahoo.co.uk
 Cc: RT User List rt-users@lists.bestpractical.com
 Sent: Thursday, 28 March 2013, 20:26
 Subject: Re: [rt-users] Start page is displaied when DB is unavalable

 On Thu, Mar 28, 2013 at 2:59 PM, Asanka Gunasekera
 asanka_gunasek...@yahoo.co.uk wrote:
 Hi I am running RT 4.00 and when trying to connect to RT it gives starter
 page when the  database is not available. How can I stop this behaviour or
 start a page saying that the RT is down when the DB is not available
 Thanks and Regards

 Filed as a bug/feature request [1]. It's not hard to implement. If you
 want to then you should start around line 274 in
 lib/RT/Interface/Web/Handler.pm. Grep for ConnectToDatabase.

 [1] http://issues.bestpractical.com/Ticket/Display.html?id=23332


 --
 Best regards, Ruslan.





-- 
Best regards, Ruslan.

[rt-users] Start page is displaied when DB is unavalable

2013-03-28 Thread Asanka Gunasekera
Hi I am running RT 4.00 and when trying to connect to RT it
gives starter page when the  database is
not available. How can I stop this behaviour or start a page saying that the RT
is down when the DB is not available
Thanks and Regards

Re: [rt-users] Start page is displaied when DB is unavalable

2013-03-28 Thread Ruslan Zakirov
On Thu, Mar 28, 2013 at 2:59 PM, Asanka Gunasekera
asanka_gunasek...@yahoo.co.uk wrote:
 Hi I am running RT 4.00 and when trying to connect to RT it gives starter
 page when the  database is not available. How can I stop this behaviour or
 start a page saying that the RT is down when the DB is not available
 Thanks and Regards

Filed as a bug/feature request [1]. It's not hard to implement. If you
want to then you should start around line 274 in
lib/RT/Interface/Web/Handler.pm. Grep for ConnectToDatabase.

[1] http://issues.bestpractical.com/Ticket/Display.html?id=23332


-- 
Best regards, Ruslan.


Re: [rt-users] Start page is displaied when DB is unavalable

2013-03-28 Thread Asanka Gunasekera
Thank you Ruslan, hope I will not break what is working :) and is this fixed on 
later releases since I am planning on doing an upgrade to the latust

Best Regards



 From: Ruslan Zakirov r...@bestpractical.com
To: Asanka Gunasekera asanka_gunasek...@yahoo.co.uk 
Cc: RT User List rt-users@lists.bestpractical.com 
Sent: Thursday, 28 March 2013, 20:26
Subject: Re: [rt-users] Start page is displaied when DB is unavalable
 
On Thu, Mar 28, 2013 at 2:59 PM, Asanka Gunasekera
asanka_gunasek...@yahoo.co.uk wrote:
 Hi I am running RT 4.00 and when trying to connect to RT it gives starter
 page when the  database is not available. How can I stop this behaviour or
 start a page saying that the RT is down when the DB is not available
 Thanks and Regards

Filed as a bug/feature request [1]. It's not hard to implement. If you
want to then you should start around line 274 in
lib/RT/Interface/Web/Handler.pm. Grep for ConnectToDatabase.

[1] http://issues.bestpractical.com/Ticket/Display.html?id=23332


-- 
Best regards, Ruslan.

Re: [rt-users] Start page is displaied when DB is unavalable

2013-03-28 Thread Ruslan Zakirov
On Thu, Mar 28, 2013 at 10:23 PM, Asanka Gunasekera
asanka_gunasek...@yahoo.co.uk wrote:
 Thank you Ruslan, hope I will not break what is working :) and is this fixed
 on later releases since I am planning on doing an upgrade to the latust

It's not at the moment and I don't know if it's on anybody's radar.

 Best Regards

 
 From: Ruslan Zakirov r...@bestpractical.com
 To: Asanka Gunasekera asanka_gunasek...@yahoo.co.uk
 Cc: RT User List rt-users@lists.bestpractical.com
 Sent: Thursday, 28 March 2013, 20:26
 Subject: Re: [rt-users] Start page is displaied when DB is unavalable

 On Thu, Mar 28, 2013 at 2:59 PM, Asanka Gunasekera
 asanka_gunasek...@yahoo.co.uk wrote:
 Hi I am running RT 4.00 and when trying to connect to RT it gives starter
 page when the  database is not available. How can I stop this behaviour or
 start a page saying that the RT is down when the DB is not available
 Thanks and Regards

 Filed as a bug/feature request [1]. It's not hard to implement. If you
 want to then you should start around line 274 in
 lib/RT/Interface/Web/Handler.pm. Grep for ConnectToDatabase.

 [1] http://issues.bestpractical.com/Ticket/Display.html?id=23332


 --
 Best regards, Ruslan.





-- 
Best regards, Ruslan.


[rt-users] Start ticket ID in 2000

2009-11-02 Thread Rui Vitor Figueiras Meireles

Is there any easy way to make ticket IDs start in a number (eg: 2000), instead 
of starting in 1?
If I manually change the ID of a ticket to 2000 will that do the trick?


Thank you

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

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


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


Re: [rt-users] Start ticket ID in 2000

2009-11-02 Thread Emmanuel Lacour
On Mon, Nov 02, 2009 at 12:40:12PM +, Rui Vitor Figueiras Meireles wrote:
 
 Is there any easy way to make ticket IDs start in a number (eg: 2000), 
 instead of starting in 1?
 If I manually change the ID of a ticket to 2000 will that do the trick?
 
 

here are some tips for this:

http://wiki.bestpractical.com/view/SetStartingId

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

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


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


Re: [rt-users] Start ticket ID in 2000

2009-11-02 Thread Rui Vitor Figueiras Meireles

Thank you very much, it worked!

Rui Meireles


-Original Message-
Date: Mon, 2 Nov 2009 13:50:55 +0100
From: Emmanuel Lacour elac...@easter-eggs.com
Subject: Re: [rt-users] Start ticket ID in 2000
To: rt-users@lists.bestpractical.com
Message-ID: 20091102125055.gb9...@easter-eggs.com
Content-Type: text/plain; charset=us-ascii

On Mon, Nov 02, 2009 at 12:40:12PM +, Rui Vitor Figueiras Meireles wrote:
 
 Is there any easy way to make ticket IDs start in a number (eg: 2000), 
 instead of starting in 1?
 If I manually change the ID of a ticket to 2000 will that do the trick?
 
 

here are some tips for this:

http://wiki.bestpractical.com/view/SetStartingId


-Original Message-
From: Rui Vitor Figueiras Meireles 
Sent: segunda-feira, 2 de Novembro de 2009 12:40
To: 'rt-users@lists.bestpractical.com'
Subject: Start ticket ID in 2000


Is there any easy way to make ticket IDs start in a number (eg: 2000), instead 
of starting in 1?
If I manually change the ID of a ticket to 2000 will that do the trick?


Thank you

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

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


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


[rt-users] start from today

2009-03-09 Thread Albert Shih
Hi all

Sometime I created some ticket with Start in the futur. And I would like to
make «My Ticket» don't show me those tickets until the starting date. 

How can I make search with

Start  «today» 

in «My_ticket» search ? 

Regards.
-- 
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Heure local/Local time:
Lun 9 mar 2009 14:46:23 CET
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


Re: [rt-users] start from today

2009-03-09 Thread Albert Shih
 Le 09/03/2009 à 14:48:07+0100, Albert Shih a écrit
 Hi all
 
 Sometime I created some ticket with Start in the futur. And I would like to
 make «My Ticket» don't show me those tickets until the starting date. 
 
 How can I make search with
 
   Start  «today» 
 
 in «My_ticket» search ? 

I find the solution .

start  'today'

sorry to bothering this mailing list for something so easy.

Regards.

-- 
Albert SHIH
SIO batiment 15
Observatoire de Paris Meudon
5 Place Jules Janssen
92195 Meudon Cedex
Heure local/Local time:
Lun 9 mar 2009 14:58:10 CET
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

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


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


Re: [rt-users] Start ticket number at an arbitrary value

2007-10-26 Thread Stephen Turner


At Thursday 10/25/2007 04:47 PM, you wrote:
Insert a row in the tickets table with id 4999, then the next ticket 
will be 5000.


This may depend on which database you're using. Oracle, for example, 
uses a sequence object for the next id, so in that case you'd need to 
reset the sequence value.


Steve



On 10/25/07, John Arends mailto:[EMAIL PROTECTED][EMAIL PROTECTED]  wrote:
Is anyone aware of a way that I can have my next ticket start at an
arbitrary high value that I select? I'm on a new installation, and I
have created a few test tickets (I believe I'm up to number 4) but if
possible I would like the next ticket to start at 5000.



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


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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


[rt-users] Start ticket number at an arbitrary value

2007-10-25 Thread John Arends
Is anyone aware of a way that I can have my next ticket start at an 
arbitrary high value that I select? I'm on a new installation, and I 
have created a few test tickets (I believe I'm up to number 4) but if 
possible I would like the next ticket to start at 5000.



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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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


Re: [rt-users] Start ticket number at an arbitrary value

2007-10-25 Thread John Arends
That was my initial plan, but I wanted to make sure there wasn't an RT 
sanctioned way, since the general recommendation seems to be to avoid 
messing with the database directly.


I can't imagine this would cause any integrity problems.

Todd Chapman wrote:
Insert a row in the tickets table with id 4999, then the next ticket 
will be 5000.


On 10/25/07, *John Arends* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 
wrote:


Is anyone aware of a way that I can have my next ticket start at an
arbitrary high value that I select? I'm on a new installation, and I
have created a few test tickets (I believe I'm up to number 4) but if
possible I would like the next ticket to start at 5000.





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

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we'll take
up to 20 percent off the price. This sale won't last long, so get in touch today. 
   Email us at [EMAIL PROTECTED] or call us at +1 617 812 0745.



Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


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