Storing freetext data when adding an article.

[kerryrsmith]

I want to be able to find out when a freetext value is set when a note is added to a ticket. If I select an item in one of the freetext fields that I've enabled on the note screen & create an article, when I query the article in the database the field is empty. Is this the correct behaviour? If so, is there another way of doing this?

[crythias]

article freetext will work with articles.

[kerryrsmith]

Does that mean the freetext is stored when posting a reply, rather than using the notes screen?

[kerryrsmith]

To clarify. If I add a note to a ticket and populate the freetext2 field & then run the following in Excel, I get 0 rows returned:

SELECT article_0.id, article_0.ticket_id, article_0.article_type_id, article_0.article_sender_type_id, article_0.a_from, article_0.a_reply_to, article_0.a_to, article_0.a_cc, article_0.a_subject, article_0.a_message_id, article_0.a_in_reply_to, article_0.a_references, article_0.a_content_type, article_0.a_body, article_0.incoming_time, article_0.content_path, article_0.a_freekey1, article_0.a_freetext1, article_0.a_freekey2, article_0.a_freetext2, article_0.a_freekey3, article_0.a_freetext3, article_0.valid_id, article_0.create_time, article_0.create_by, article_0.change_time, article_0.change_by
FROM otrs.article article_0
WHERE (article_0.create_time>{ts '2013-03-11 14:00:00'}) AND (article_0.a_freetext2 Is Not Null)

[crythias]

Does that mean the freetext is stored when posting a reply, rather than using the notes screen?

no.

I mean the type of freetext determines where it's stored (ticket or article).
If it's a ticket freetext, it gets stored in the ticket table.
If it's an article freetext, it gets stored with the article that is used to fill the field. If that's a reply, it will be that and only that reply. If it's a note, it will be that and only that note.