[TYPO3-english] wfqbe and rawquery and preProcessQueryStructure

[Mauro Lorenzutti]

Hi Cathy,

if your select statement has uid=17, you should replace the following line:

plugin.tx_wfqbe_pi1.customQuery.27 {

with this one:

plugin.tx_wfqbe_pi1.customQuery.17 {

Otherwise your TS configuration will not be applied to the select query.

Regards,
-- 

Mauro Lorenzutti

CTO / Software Architect
mauro.lorenzutti at webformat.com
Tel.   +39-0427-926.389

WEBFORMAT srl -- www.webformat.com
Via S. Francesco d'Assisi, 6 -- 20122 MILANO
Corte Europa, 12 - 33097 Spilimbergo (PORDENONE)

TYPO3 Certified Integrator



Il 17/08/2010 23.06, Cathy Stephens ha scritto:
> Hi Mauro
>
> I have tried your suggestion but something is wrong.  No matter how I
> try to change the typoscript (and I have tried several variations), it
> does not seem to do anything to the query.
>
> My custom select statement (record #17) is:
>   WHERE Station = '###WFQBE_STATION###'   ###WFQBE_DAY###
>
> Then built a search record (#27) from the select record (#17). Used
> both markers above.  Set to select fields and pulled dynamically.  So
> have two fields - Station (WFQBE_STATION) and Day (WFQBE_DAY).
>
>
> The Typoscript on the page where the query is inserted:
>
> [globalVar = GP:tx_wfqbe_pi1|DAY !=  ]
> plugin.tx_wfqbe_pi1.customQuery.27 {
>       DAY = TEXT
>       DAY.data = ###WFQBE_DAY###
>       DAY.stdWrap.wrap = AND Day='|'
> }
>
> Where 27 is the id of the query record.  And what I see in the debug is this:
> ...WHERE Station = 'College' Thursday
>
> The marker is being picked up but it is not being wrapped. Same
> behavior without that additional typoscript.  If the first field is
> selected (Station) and I leave Day blank, then I get results filtered
> by Station.  But does not work when you add a day.  I even tried
> setting the global to DAY = Thursday.  Then modified the typoscript so
> value would be  "and day='Thursday'" but this had no effect either
> when Thursday was selected in form.
>
> I see what you are trying for and would be great if it worked but I am
> missing something I think.
>
> Thank you,
> Cathy Stephens
>
>
> This hook is useful in QBE queries only, not in raw queries, sorry :-(
>
>    
>> If so, any thoughts how to work around this so I can get the empty
>> query fields stripped out?
>>
>>      
> You can work via typoscript / PHP:
>
> SELECT * FROM table WHERE field1='###WFQBE_field1###' AND
> field2='###WFQBE_field2###'
>
> can be modified as follows:
>
> SELECT * FROM table WHERE field1='###WFQBE_field1###' ###WFQBE_field2###
>
> and via typoscript you can do something like this:
>
> [globalVar = GP:tx_wfqbe_pi1|field2 != ]
> plugin.tx_wfqbe_pi1.customQuery.123 {
>      field2 = TEXT
>      field2.data = ###WFQBE_field2###
>      field2.stdWrap.wrap = AND field2='|'
> }
> [end]
>
> Not tested but it should work. In any case this is just an idea on how
> to customize you raw queries.
>
> I hope this will help you.
>
> Regards,
> --
>
> Mauro Lorenzutti
>
>
>