User Tools

Site Tools


docs:tips_n_tricks:rt.html

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
docs:tips_n_tricks:rt.html [17.07.2012 13:22 CEST]
peter [Local Config on Debian Systems]
docs:tips_n_tricks:rt.html [30.09.2013 15:09 CEST] (current)
peter [Queries]
Line 15: Line 15:
 ===== Configuration ===== ===== Configuration =====
 ==== Queries ==== ==== Queries ====
 +=== Alignment ===
 To align a field containing ''​_''''​_id_''''​_''​ (which will be aligned to the right by default) to the left, add ''/​ALIGN:​left''​ to the field definition in the advanced query editor. To align a field containing ''​_''''​_id_''''​_''​ (which will be aligned to the right by default) to the left, add ''/​ALIGN:​left''​ to the field definition in the advanced query editor.
  
 Example: Example:
   '​__Status__ [<a href="​__WebPath__/​Ticket/​Modify.html?​id=__id__&​amp;​Status=deleted">​delete</​a>​]/​TITLE:​Status (Delete)/​ALIGN:​left',​   '​__Status__ [<a href="​__WebPath__/​Ticket/​Modify.html?​id=__id__&​amp;​Status=deleted">​delete</​a>​]/​TITLE:​Status (Delete)/​ALIGN:​left',​
 +  ​
 +=== Time formats ===
 +
 +As found (verbatim) at the [[http://​requesttracker.wikia.com/​wiki/​TicketSQL|RT Wiki]]:
 +
 +//There are at least three valid date formats://
 +
 +  * ''​ '​today'​ ''​ //uses today'​s date as the date value//
 +  * //''​ 'x days ago' ''​where x is some integer value (e.g.''​ '8 days ago' ''​)//​
 +  * //'​YYYY-MM-DD'​ absolute day in the format year-month-date (e.g.''​ '​2013-09-30'​ ''​)//​
 +  * //''​ 'n seconds'​ '',''​ 'n minutes'​ '',''​ 'n hours' '',''​ 'n days' '',''​ 'n weeks' ''​ are dates in the future relative to the current date, ie current_date + n minutes. May be negative, eg ''​ '-2 days' ''​ is two days in the past.// ​
 ===== Glossary ===== ===== Glossary =====
 __Offline__:​\\ __Offline__:​\\
docs/tips_n_tricks/rt.html.txt · Last modified: 30.09.2013 15:09 CEST by peter