[Erp5-dev] using ComplexQuery and choosing proper tables

[Łukasz Nowak]

Hello,

Take a look at this snippet:

kw = {}
from Products.ZSQLCatalog.SQLCatalog import Query,ComplexQuery
query = ComplexQuery(
  Query(**{'movement.start_date' : '>=2008/10/10'}),
  Query(**{'movement.start_date' : '<=2008/10/10'}),
)
kw.update(**query.asSQLExpression())
context.portal_catalog(**kw)

It raises error:

Error Type: OperationalError 
Error Value: (1054, "Unknown column 'movement.start_date' in 'where
clause': SELECT DISTINCT\n catalog.path, catalog.uid \nFROM\n catalog AS
catalog \nWHERE \n 1 = 1 \n AND (((catalog.security_uid IN (4, 5, 6, 7,
8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25,
26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43,
44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 60, 61, 62,
63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79)) OR
(((((((catalog.viewable_owner = 'ERP5TypeTestCase'))))))))) AND (1) AND
(((((((movement.start_date >= '2008/10/10'))))) AND
(((((movement.start_date <= '2008/10/10')))))))\nLIMIT 1000") 

I've dig through SQLCatalog product code, but I wasn't able to convince
portal_catalog to use movement table too in its query. Passing
from_table_list = 'movement' didn't help me.

Question: How to force portal_catalog to use more tables using
Query/ComplexQuery features?

Regards,
Luke

-- 
Łukasz Nowak IT Specialist email at lnowak.com http://lnowak.com/
Skype: Shufla jid: shufla at jabster.pl
``Use the Source, Luke...''