[Erp5-dev] own workflow state catalogged in own table, its translation - how to?

[Jérome Perrin]

Le vendredi 12 septembre 2008 à 14:58 +0200, Łukasz Nowak a écrit :
> Hello,
> 
> On Fri, 2008-09-12 at 14:23 +0200, Jérome Perrin wrote:
> > Le jeudi 11 septembre 2008 à 11:55 +0200, Łukasz Nowak a écrit :
> > > Hello,
> > > 
> > > We are using our own workflow state - operation_state.
> > > 
> > > I created my own table for this state in catalog: ventisopstate.
> > > 
> > > Searching/sorting is working for this operation_state column. So far so
> > > good.
> > > 
> > > But I wanted to be able to sort/search by this state translated title.
> > > 
> > > So I've copy&pasted:
> > >  * z_related_translated_validation_state
> > > => z_related_translated_operation_state
> > > 
> > >  * z_related_translated_validation_state_title =>
> > > z_related_translated_operation_state_title
> > > 
> > > Modified both scripts, updated sql_catalog_related_keys.
> > 
> > Hello,
> > 
> > What did you add in sql_catalog_related_keys ?
> > My guess is that you should add ventisopstate table in the related key
> > definition, so that the query builder adds it in the FROM clause.
> > Maybe something like:
> > 
> > translated_operation_state_title
> > | ventisopstate/translation/translated_message/z_related_translated_operation_state_title
> 
> I did have:
> 
> translated_operation_state |
> translation/translated_message/z_related_translated_operation_state
> 
> translated_operation_state_title |
> translation/translated_message/z_related_translated_operation_state_title
> 
> 
> After changing to:
> translated_operation_state |
> venitsopstate/translation/translated_message/z_related_translated_operation_state
> 
> translated_operation_state_title |
> ventisopstate/translation/translated_message/z_related_translated_operation_state_title

Then z_related_translated_operation_state_title method will receive
table_0 and table_1 arguments. table_0 will
be "related_ventisopstate_0" or whatever alias the query generator
associated to ventisopstate table, and table_1 the alias for
translation table. Then you'll have to use <dtml-var table_0> instead
of "ventisopstate", and <dtml-var table_1> instead of
"translation" (or maybe it was <dtml-var table_0>).

Jérome

> only part of traceback changed to:
> 
> OperationalError: (1054, "Unknown column
> 'related_ventisopstate_0.translation' in 'where clause': SELECT\n
> COUNT(DISTINCT catalog.uid) FROM\n catalog AS catalog WHERE\n 1 = 1\n
> AND (1) AND (1) AND (1) AND (1) AND (1) AND (1) AND (1) AND (1) AND (1)
> AND (1) AND (((((catalog.portal_type = 'Production Order'))))) AND (1)
> AND (((((related_ventisopstate_0.translation = 'finished'))))) AND
> (((catalog.security_uid IN (147, 148, 149, 150, 151, 152, 153, 154, 155,
> 156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169,
> 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183,
> 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196)) OR
> (((((((catalog.viewable_owner = 'ERP5TypeTestCase'))))))))) AND (1) AND
> (1) AND (1) AND (((((catalog.parent_uid = '1152'))))) AND (1)\nLIMIT 1")
> 
> Regards,
> Luke
>