Hey Winter,
f_subject is the Title of the FAQ entry, f_field1 through f_field6 are other
fields within the FAQ entry (solution, problem, symptom... etc),
unfortunately I can not identify these for you as we are currently only
using f_field3 (solution) and f_subject (we put our FAQ questions as the
title of each entry).
If you wish to find out what f_field 1 through 6 represent in your situation
I would recommend doing a short test with limit set to 1. Attempting a
'select f_subject, f_field1, f_field2, f_field3, f_field4, f_field5,
f_field6 from faq_item' with limit 1 as CVS then opening this file in excel
or openoffice you can correlate each each variable with a column in the
spreadsheet, for example f_subject would be column 1, f_field1 column 2 and
so on...
Then you would know which columns are of interest to you and change your
select query based on that information.
You are correct in assuming the limit correlates with the amount of articles
that will be returned at once, that is why I indicated you should set the
limit at or above 74, since you have indicated you have 74 FAQ entries you'd
like to extract.
Lukasz
On Wed, Mar 16, 2011 at 7:16 AM, Silver springs
Hi Lukasz,
Thanks for your reply on the FAQ article help.
Im not sure if I understand what you said about the f_subject and other fields. Please let me know what are these f_subject, f_field1 etc .. What do these attributes represent when I select them ? Could you please tell me what they mean in terms of an individual FAQ article ?
I see that if I select the output to CVS, I get an output in excel format . Do you mean setting the limit to above 74, it downloads more than 74 FAQ articles ?
Please help me understand these questions.
Winter.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs