In version 1.10, I can't figure out where to edit SQL to add our custom data fields we created for custom forms. I've removed a couple to make room, but I'm just not versed enough to figure it out. I'm hoping for a pointer or two.Thanks!
I found this thread, but I don't see yet where to add the column. I have the database field now. Just not the heading.Page 7 http://forum.osticket.com/d/discussion//a-better-ticket-list/p7
The data we have is actually an OSTicket "list". The data is stored in ticket__cdata as "xx,buildingname" where I want to retrieve the building name, not the number xx.
I was able to add the column header at line 37 "$queue_columns = array(....."
So 1.10 hasn't been released yet.Also I'm not real clear on what it is you are trying to do. If you want to add your custom list, why wouldn't you just add it to the Ticket Details form?
I want to add the custom list data from the tickets form to the front page list of tickets. We collect what school the person is in and we want that to show on the main page.We are using RC-3.Thanks for replying.
I was able to create a manual array of building names to compare with the numbers.Here's what I did.Created $schools array with the xx number and school initials.I added a column to the $queue_columns array in the order I wanted it. added cdata__school to $tickets->values that I found in the databaseGot rid of unwanted columns with unset($queue_columns); unset($queue_columns);and then added a <td> in the ticket table pulling back the school initials $school = strtoupper($schools);
Ah that makes total sense. Your doing a stand alone page. As a side note the CDATA table is a temporary table and you should probably take the information from the actual tables.
That data doesn't seem stored anywhere else without doing an SQL query. It's hard for me to decipher how the queries are generated. Can I grab that list data from a ticket without an additional query?Thanks for responding, btw!
You would have to perform an SQL query.
I'll have to look into that later. The coding on this site is a little more advanced than I am to figure out where the sql is being written. How temporary is the table data?
I'm not sure how often it gets dumped and re-generated. I seem to recall Jared posting something about it a while ago (and my memory of this post is fuzzy at best).
