[TYPO3] 'wfqbe' how to search date?

[Mauro Lorenzutti]

Hi,

 > Hi,
 >
 > I am currently trying to integrate wfqbe in my custom made extension 
'graveyard'. Problem is that dates are stored in UNIX TIMESTAMP format 
while search string is a normal date e.g. dd-mm-yyyy. Through 
documentation I know that a hook is used for that purpose.
 >
 > "ProcessSubstituteSearchParametersClass: this can be used to 
manipulate search parameters from a search form before executing the 
results query. For example, this is useful to convert a date parameter 
from a “dd-mm-yyyy” format to a timestamp before executing a query."
 >
 > But unfortunatly I was unable to do it.
 >
 >

[...]

 > By the ways issue_date is a field containing date in unix timestamp 
format. Please help me!
 >
 > Thanks in advance
 >
 > Junaid Mansoor Sootwala


You can avoid using hooks by using proper DBMS functions. For example, I 
created a search form with 3 fields (day,month,year) and I inserted this 
string in the where clause of my query record:

UNIX_TIMESTAMP('###WFQBE_YEAR###-###WFQBE_MONTH###-###WFQBE_DAY### 
00:00:00')

This will convert the human date in a timestamp value and can be used to 
search inside timestamp fields. Pay attention to the UNIX_TIMESTAMP 
function: this works with mysql, I don't know if it works with every DBMS.

Regards,

-- 
Mauro Lorenzutti


e-mail:  mauro.lorenzutti at webformat.com

---------------------------------------------------------
WEBFORMAT srl | Corte Europa, 12 | I-33097 SPILIMBERGO PN
     Tel +39-0427-926.389  --  Fax +39-0427-927.653
       info at webformat.com  --  http://www.webformat.com
---------------------------------------------------------