|
I need to be able to export Trac tickets from a report or custom query to Excel, including the ticket description. The catch is that the description must be formatted as defined by the wiki syntax rather than displaying the raw text.
Started by Ryan Taylor on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Hi, you can just go to "View Tickets the description "unformatted" as a ....
Hope this helps.
Better luck saving the whole HTML report, isolating the html table, and importing it as html file in Excel : It keeps well all the formatting.
|
|
How do I query for all trac tickets related to a user. i.e. all tickets for which the tickets were once assigned, assigned now, created , etc etc
Started by Quintin Par on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For assigned once/now, look for rows where ....
Some SQL required.
Example:
SELECT p.value AS __colorCreate custom queries to the ticket_change table.
For created tickets, just query by reporter in the ticket table.
|
|
London 2012 Logo | 2012 london olympics | london Olympics | London 2012 Mascot | london olympics Mascot
Table Size FlagsRussia Table Flag [Model: TABLE13] - £4.40 :
Powered by Zen Cart :: The Art of E-Commerce Accessibility information
Login in
...
Started by loaglottronn on
, 1 posts
by 1 people.
Answer Snippets (Read the full thread at pacificfans):
|
Ask your Facebook Friends
|
A non-railfan friend, after seeing the high sleeper fares on Amtrak site asked me a question to which I don't have an answer, hopefully someone can help me out- on the Big Five LD western trains (EB, CZ, SWC, TE/SL, CS), what is the ratio of purchases...
Started by Texan Eagle on
, 12 posts
by 11 people.
Answer Snippets (Read the full thread at amtraktrains):
One major head count is revenue tickets....
I've wondered this myself.
Even though he up enough points to get a free ticket across the country.
When he got off, he left his ticket stub on the table.
ticket anyway instead of BC ).
|
|
Hi I have a MySQL table, let's say it is a helpdesk ticketing system. It has a CLOSED column, which I want to index. 99% of time, I will need to only select on OPEN tickets, so something like
"SELECT * FROM TICKET_TABLE where CLOSED='N'; "
And over time...
Started by MySQL Newbie on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
One option ....
To make or area.
"SELECT * FROM TICKET_TABLE FORCE INDEX in the case closed='Y', full table scan(which is not using index) will be faster than using index.
You can force mysql to use your index by doing e.g .
Easily.
|
|
Hi,
I wrote this code based off a school assignment I had last year which, was in Oracle. However, I can't figure out how to calculate the total number of tickets regardless of whether a ticket is added or subtracted.
vb Code: Dim person_table As person...
Started by Nightwalker83 on
, 23 posts
by 6 people.
Answer Snippets (Read the full thread at com):
TicketID ) The total ticket_table(ticket(1)).ticketID = 2 ticket_table(ticket(2)).ticketID....
TicketID )
with
vb Code: tickets += ( ticket_table ( i ) .
= ( ticket_table ( i ) .
|
|
Season Tickets and Match day tickets Let's hope they freeze the prices.
The last time we had a feel good season like this was in our first year in the premiership when they screwed all the good will up with massive match day price hikes.
Started by MarkLatic on
, 7 posts
by 5 people.
Answer Snippets (Read the full thread at footymad):
For a season ticket for Colchester united re: Season Tickets and Match day tickets 'upthalaticsNo1re: Season Tickets and Match day tickets I thought the prices at Wigan for season tickets were very low in comparison....
|
|
I am using C# and ASP.NEt to create a web application where I need to insert/view data. I created my own class that stores values for a "Ticket" or a support ticket. My question is, how can I grab the values from the SQL table with the tickets and store...
Started by Yakattak on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
You should.
Or even better, use the Console.WriteLine() with code to to create new instances of Ticket and add them to a ticket list.
The results for a DataTable, and copying the data row data to your Ticket class.
|
|
I have a "Tickets" table with somewhat following structure (removed unnecessary columns)
int | string | int | ID | Window | Count | 0 | Internet | 10 | 1 | Phone | 20 | 2 | Fax | 15 | 3 | Fax | 10 | 4 | Internet | 5 | . | . | . | . | . | . |
And I have...
Started by Hemant on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Var tickets = (from t in db.Tickets select t).Distinct();
[EDIT(); // occurences
How about:
var tickets = db.Tickets.Select(t => t.Window).Distinct();
I prefer to only is:
var tickets = (from t....
It's as simple as that.
Result.
|
|
I run the risk of palm-to-forehead here, but I can't quite figure out how to do this with Rails' ActiveRecord sugar.
I have a tickets table that has two columns ( submitter_id and assignee_id ) that should each reference a different user from the users...
Started by localshred on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Name => 'Ticket', :foreign_key => 'submitter_id' has_many :tickets_assigned, :class_name => :assigned_tickets, :class_name => "Ticket", :foreign_key => "assignee_id" has_many :submitted_tickets, :class....
|
