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? :-)
You would have to alter the core source to add that as an available drop down in the queue columns, and populate it.
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='<p>Gå ned og kigge på glasset sammen med Finn. </p>', ticket_id= 16875 ON DUPLICATE KEY UPDATE field='<p>Gå ned og kigge på glasset sammen med Finn. </p>']
Unknown column 'field' in 'field list'<br /> <br />
Its because its gets updated and therefore a duplicate, is there another way to add this site note or better data source to use?
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.
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
