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

[Łukasz Nowak]

Hello,

Ok - I made it. It is top-posted, sorry.

So - I've got my own table ventisopstate, which is catalogging
operation_state on some portal types.

desc ventisopstate;
+-----------------+---------------------+------+-----+---------+-------+
| Field           | Type                | Null | Key | Default | Extra |
+-----------------+---------------------+------+-----+---------+-------+
| uid             | bigint(20) unsigned | NO   | PRI | NULL    |       |
| operation_state | varchar(255)        | YES  | MUL | NULL    |       |
+-----------------+---------------------+------+-----+---------+-------+

operation_state is one of my workflow's variable name.

I wanted to be able to search/sort - use catalog - for
translated_operation_state and translated_operation_state_title.

That's what I have in my sql_catalog_related_keys:

translated_operation_state |
ventisopstate,translation/translated_message/z_related_translated_operation_state
translated_operation_state_title |
ventisopstate,translation/translated_message/z_related_translated_operation_state_title

My z_related_translated_operation_state:

Arguments:
table_0
table_1

Body:

<dtml-var table_1>.original_message = <dtml-var table_0>.operation_state
 AND <dtml-var table_1>.message_context = "operation_state"
 AND <dtml-var table_1>.language = <dtml-sqlvar
"Localizer.get_selected_language()" type="string">
 AND <dtml-var table_0>.uid = catalog.uid

My z_related_translated_operation_state_title:

Arguments:
table_0
table_1

Body:

<dtml-var table_1>.original_message = <dtml-var table_0>.operation_state
 AND <dtml-var table_1>.message_context = "operation_state_title"
 AND <dtml-var table_1>.language = <dtml-sqlvar
"Localizer.get_selected_language()" type="string">
 AND <dtml-var table_0>.uid = catalog.uid

I wasn't able to do it without directly relating to catalog table
(passing this as argument to not applies). But it is working, query runs
quite fast and its src__=1 looks corrects.

So - this is that solution. Thank you Jerome for tip. Is that good
enough for wikipage, or shall I wait for mentioned somewhere catalog
configuration change?

Regards,
Luke

On Fri, 2008-09-12 at 15:57 +0200, Jérome Perrin wrote:
> 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
> > 
> 
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> http://mail.nexedi.com/mailman/listinfo/erp5-dev
-- 
Łukasz Nowak R&D Ventis http://www.ventis.com.pl/
tel: +48 32 768 16 85 fax: +48 32 392 10 61
``Use the Source, Luke...'' I am only craftsman.