A better ticket list!: Page 10

A better ticket list!

vk247

@[deleted]Regarding the label which it grabs the data from the form on ticket-view.inc.phpIf the variable and label is the same on various forms will it grab the data regardless of the form used?

AlexYoung

is this easy to do on the develop-next version?

Kushelbek

Hi All!How i can add custom field in 1.10 RC Version?Thanks!

dv452013

hi how can you export the entire ticket details .. i.e list all form_entry_value as colums to the ticket_id (rows)i am very lost and confused .. tried using JOINS but each entry is listed as a row, i.e each ticket_id has x-number of rows

Kushelbek

Hi all!If you need modify you staff list (osTicket v1.10-RC.1) , you need to go at line 279 and add: $tickets->values('lock__staff_id', 'staff_id', 'isoverdue', 'team_id', 'ticket_id', 'number', 'cdata__subject', 'cdata__CUSTOM', 'user__default_email__address', 'source', 'cdata__', 'cdata__', 'status_id', 'status__name', 'status__state', 'dept_id', 'dept__name', 'user__name', 'lastupdate');

Of course you need to add <td> after line 501 (for ex): <td> <?php echo $T; ?> </td>

With best wishes Evgeniy =)P.S. Srry 4 my Eng =)

chiefer

Sorry, would you be able to elaborate on this a little bit. I am trying to make a column for my ticket_status information custom list in 1.10 rc.Thanks

Kushelbek

@chiefer, can you show me screenshot, where list(in ticket.inc.php or ticket-view.inc.php) you want to see?

chiefer

'cdata__CUSTOM' Do I need to replace this with something to reference my custom list?Where should the <td> go exactly? I am uncertan. I have a clean install.Thanks

Kushelbek

@chiefer okey. Are you use 1.10-rc 1 version? If yes, first time look on you DB and find table ost_ticket__cdata, then find desired column(for exp): blank then go to the ../include/staff/ticket.inc.php(279 line)and do next(for exp): blank next step on this file - line 500: blank I hope explained available =)Chears, EvgeniyP/S Srry 4 my eng

chiefer

Thanks, it worked!

Kushelbek

@chiefer you are wellcome =)

radeon79

Hi Kushelbek i have added 2 new column to my ticket view, is work but the name of column is not present, how to add this information?in the attached the problem.

[tickets.inc.php.7z](https://forum.osticket.com/assets/files/migrated/FileUpload/5a/56cb4ef45534453f23ab82a329a285.7z)

Kushelbek

Hi @[deleted], im fixed you file. See at line 433, 434 =)

[tickets.inc.php.7z](https://forum.osticket.com/assets/files/migrated/FileUpload/d6/9499599ee6d7e2d717da247ab6e652.7z)

chiefer

Hi again,I would now like to move my added columns in between some of the existing columns and actually delete some of the existing columns too. I am now using RC2. Is this possilbe @[deleted]Thanks

Kushelbek

Hi @[deleted], it's possible, you need to move them to where you want and comment or delete unnecessary column =)

Ashton

I'm sure someone has asked for this before, but I can't seem to find it. I'd like a column that lists department, and the ability to sort by that column. I assume I can just modify the file for that, but since people here seem so nice, I thought I'd ask if anyone minded pointing me in the right direction.

Kushelbek

@[deleted] what version do you use?

Ashton

I'm currently using version 1.9.12I'm not sure if this is the solution or not, but we have a bunch of teams that handle things, and I can't figure out how to get them the information they need effectively.

Kushelbek

@[deleted], if i'm understand right, you need to output custom column.../include/staf/ticket.inc.php line 257.' ,cdata.priority as priority_id, cdata.subject, cdata.YOU_CUSTOM as custom_id, pri.priority_desc, pri.priority_color';and add after line 499 <td>

pfurches

This question is more for the moderators and devs.

Do you have any plans with 1.10 or later to add this ability as an editable form in the UI similar to the way you can now edit status fields? Or has an enhancement request for this already been made?

« Previous Page Next Page »