Questions tagged [ticket-system]

Ticketing systems are used to keep track of workflow items, typically for support, bug fixes and implementation of new features.

Ticketing systems is a high-level grouping of database systems used to keep track of workflow items. Typical implementations include issue tracking, bug tracking and change tracking systems.

Each ticket, or record, in a ticketing system represents a discrete unit of work, for which the state (for example: unassigned, in progress, finished) is tracked continuously. Tickets are assigned to and can be re-assigned between particular persons or groups, and can be automatically escalated if lack of assignment or progress so requires.

Also see , and

204 questions
383
votes
10 answers

Start a Git commit message with a hashmark (#)

Git treats lines starting with # (hash, number sign, octothorpe, pound sign) as comment lines when committing. This is very annoying when working with a ticket tracking system, and trying to write the ticket number at the beginning of the line,…
knittl
  • 246,190
  • 53
  • 318
  • 364
34
votes
3 answers

Getting curl_error(): 2 is not a valid cURL handle resource while fetching all users from freshdesk api

I am creating my own system to managing all tickets which are comes from freshdesk.com through its API. I am making curl request to fetch data from freshdesk.com. With getting data of related to tickers its works fine but when i am requesting for…
user2393886
  • 832
  • 2
  • 8
  • 17
29
votes
9 answers

What is the best open source help ticket system?

I know of osTicket, are there any other more compelling help ticket systems? My company wants to use one and I am researching them now. I forgot to mention, I will need to install it on our servers...so SaaS (software as a service) doesn't work.
Mircea
15
votes
7 answers

Search matrix for all rectangles of given dimensions (select blocks of seats)

All, I have been trying to work out how to select say 15 tickets within a single block of seats. EDIT: the problem is - how to find all rectangles of given dimensions (say 3x5 for example) of free seats? The below is my table, and the query selects…
Brian
  • 8,418
  • 2
  • 25
  • 32
14
votes
4 answers

Mail gem - how to clean up the body string

I'm trying to read an email using ruby mail gem. But mail.body.decoded returns me not just the body message. How can I clean up this body message and remove unwanted text like: -20cf30433c9a437cc304939017ef\nContent-Type: text/plain;…
newx
  • 595
  • 7
  • 16
13
votes
1 answer

osticket ticket Strip Quoted Reply

I am developing a site with osTicket v1.9.8 ticket system, which works fine, but I would like to know how to accomplish Thread Mail Structure while Agent or admin post a reply back to customer. i.e When osticket admin post a reply back to customer,…
jones
  • 749
  • 7
  • 34
11
votes
3 answers

How can I build a support ticket system with PHP?

I have a custom and simple php/mysql based user system. I'm trying to build a way for members to send product support to our staff (put it in a database & viewed in admin area) and for them to manage these messages. Does anyone know of a good…
Derek
  • 4,864
  • 5
  • 28
  • 38
10
votes
13 answers

Ticketing/tracking system with Subversion integration?

My company uses StarTeam for source control and CR management, but I would really like to switch to Subversion for source control. For those of you that know ClearQuest and ClearCase, StarTeam has the ability to create tickets, which can later be…
senfo
  • 28,488
  • 15
  • 76
  • 106
7
votes
3 answers

PHP / MySQL Ticket Response - Store E-mail repsonse in database?

I am building a basic support request system where the customer can log in and ask a question and an admin can go in and reply and it will set the status to "Responded" and e-mail the customer to let them know someone has responded. My question is..…
Drew
  • 6,736
  • 17
  • 64
  • 96
6
votes
1 answer

Teams in osTicket?

I've just started working on osTicket. I'm digging this ticket system to understand more of it. I read a lot about its feature from official website as well as some forums but still I could not figure out the purpose of teams. Can you explain - with…
Asim
  • 452
  • 5
  • 18
5
votes
6 answers

Online collaborative environment (not only dev oriented)

I've been working with SVN for a couple of years and recently been working on some projects involving Trac. It might seem odd for most of you but I come from design oriented background where those tools are not so often used. For the moment we…
Theo.T
  • 8,905
  • 3
  • 24
  • 38
5
votes
3 answers

Best practice for releasing inventory in a database

I'm building a ticket-selling application which tracks an inventory of tickets, de-activating them when a particular ticket is sold out. I'm wondering what the best practice is for releasing inventory back into the store when an order is abandoned…
Alex Dunae
  • 1,290
  • 3
  • 17
  • 28
4
votes
5 answers

Is there a ticket system that also does project management?

Were looking to roll out a ticket system that also has project management capability. We're currently using Trac but we find that it's really difficult to config and also has very weak support with workflows. Ideally we want a system that has: A…
erotsppa
  • 14,248
  • 33
  • 123
  • 181
4
votes
3 answers

SVN integration with Bug tracking/ticketing software

I was wondering is there any software, that integrates ticketing system(or bug tracking) with SVN, but in a specific way. I want to prohibit any code changes, that does not have ticket (or bug id). For example: Each developer has read-only access…
Sebastian Łaskawiec
  • 2,667
  • 15
  • 33
4
votes
3 answers

SQL: How do I loop through the results of a SELECT statement?

How do I loop through the results of a SELECT statement in SQL? My SELECT statement will return just 1 column but n results. I have created a fictional scenario below complete with the Pseudo code of what I'm trying to do. Scenario: Students are…
Justin
  • 10,667
  • 15
  • 58
  • 79
1
2 3
13 14