Doubt : obtaining the original creation date of a FAQ record – is it possible?
Dear Thorsten / dear All
Does phpMyFAQ’s DB store permanently - and in a non-modifiable way - the original creation date of a FAQ record?
We need to create a report with the number and the question text of FAQ records created on 2009 and 2010 (separately).
Some 2009's FAQs were reviewed in 2010.
We tried several direct MySQL SQL queries on the DB tables/fields (datum, solution_id, revision_id, …)
without consistent results.
Is it possible to obtain this kind of reports?
Software and versions :
phpMyFAQ - 2.6.13
Database Server - MySQL
Database Client Version - 5.1.54
Database Server Version - 5.5.8
PHP - 5.3.4
Thanking in advance
Kind regards
2011-01-06
pt20100201
Doubt : obtaining the original creation date of a FAQ record
Moderator: Thorsten
-
- Posts: 134
- Joined: Mon Feb 01, 2010 2:11 pm
- Location: Porto . Portugal
- Contact:
Doubt : obtaining the original creation date of a FAQ record
Last edited by pt20100201 on Fri Jan 07, 2011 10:58 am, edited 1 time in total.
Re: Doubt : obtaining the original creation date of a FAQ re
Hi,
you can do this by analyzing the faqadminlog table...
I know there's a fixed creation date missing in the faqdata table. Maybe I'll add it in 2.7
bye
Thorsten
you can do this by analyzing the faqadminlog table...
I know there's a fixed creation date missing in the faqdata table. Maybe I'll add it in 2.7
bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
amazon.de Wishlist
-
- Posts: 134
- Joined: Mon Feb 01, 2010 2:11 pm
- Location: Porto . Portugal
- Contact:
Re: Doubt : obtaining the original creation date of a FAQ re
Dear ThorstenThorsten wrote:you can do this by analyzing the faqadminlog table...
I know there's a fixed creation date missing in the faqdata table. Maybe I'll add it in 2.7
Thanks for your quick answer.
We must analyse the faqadminlog table a little more deeper...
The "fixed creation date" is important - even for those that don’t need to present reports.
Please continue your good work.
Kind regards
2011-01-07
pt20100201