|
Post by rayancaleb on Jan 30, 2018 15:02:03 GMT 3
Hi, I am trying to link the MySQL database to write my own queries. First thing I have to do is understand the database. I am assuming the most of the tables are standard with every installation and the ones I mentioned will be in everyones installation. I see there is a table called ost_ticket__cdata which has the information related to a ticket. There is another table which is called ost_list_items which has ID and description which is used in the Ticket form to choose options for the ticket like OS version, model number, etc.... In the ost_ticket__cdata table some records show the ID from the list and some show the ID with the description. As an example, one record will show 92 and the next will show 92, Windows 7. However in the Web interface, both of these will show only Windows 7. I am very familiar with relational databases and I can't understand why the system would save the description in the cdata table if it has the ID which links to the other table. But more perplexing is how can the interface show correctly, yet some records are saved with the ID and description and some with only the ID. Is there an issue with how this program was setup or is there a way to fix this. Please help. Thanks! I didn't find the right solution from the Internet. References: osticket.com/forum/discussion/87860/database-issuesPromotional Campaign Examples
|
|