[Resolved] Show Internal post inline with subject

Energy

Im trying to figure out how to show internal post as a note in the front page. But in the columns page i can't seem to find the right one.

Right now i made a custom column with a note and it works fine.

So i would like that when and internal post is made the first few lines would show on the "note" page.
Is this possibel? :-)

ntozier

You would have to alter the core source to add that as an available drop down in the queue columns, and populate it.

Energy

I didnt alter the core, but just used the new queues and added this note columns.

I used the primary data source "Note".

It works fine the first time we add a side note. But everytime we edit the note it gives out and DB Error #1054.
[INSERT INTO ostNy_ticket__cdata SET field='Gå ned og kigge på glasset sammen med Finn. ', ticket_id= 16875 ON DUPLICATE KEY UPDATE field='Gå ned og kigge på glasset sammen med Finn. ']
Unknown column 'field' in 'field list'

Its because its gets updated and therefore a duplicate, is there another way to add this site note or better data source to use?

KevinTheJedi

@Energy

You must have a custom field called Note as Note is not the same as Internal Note. Internal Note is a built-in core field of the helpdesk whereas Note is most likely a custom field you or one of your admins created. With this being said, I'll try to recreate this by creating a custom field called Note, add this to a ticket, update the field, add this field as a queue column, update the field again, and see if I get the same error.

Cheers.

Energy

KevinTheJedi

Yes i did, and i found out why i got the error or atleast how not to get it.
I didnt add a variable, didnt think it was necessary to add. But after adding note in variable i get no DB error anymore