On 6 de gener de 2018 2.06.53 CET, Roei Erez <roeie...@gmail.com> wrote: >Hi, > >We have a system with tests, each Test has a many2one field of User who >is its executor and a time that the test execution took. >We would like to show a tree view that shows average time per test and >when click on a test it is like a pivot table that opens the users and >show the total per user. > > >Name | Average Time > >+Test1 | 2 hours > User1 1 hours > User2 | 1 hours > > >We saw such tree views in the client but we would like to implement >that without inserting real rows into the database for this tree view >but rather query the information from the existing Test model table >(using table query maybe?)
Yes you should use a new model which defines the table_query method. This method must return a python-sql query with the computed data. In adition to the displayed data you must compute the id, create_uid, create_date, write_uid and write_date. In order to open the records detail you can use the tree_open keyword which will trigger a new action. This action will recieve the id of the clicked record on the active_id keyword. So it mus have a domain like: [('some_field', '=', Eval('active_id'))] In order to show only the related records on the target model. > >Appreciate if someone can help here, or refer me to an example of such >requirements. >Thanks. -- Enviado desde mi dispositivo Android con K-9 Mail. Por favor, disculpa mi brevedad. -- You received this message because you are subscribed to the Google Groups "tryton-dev" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton-dev/6372D961-F7EC-4192-998A-AC8ADDF489B2%40koolpi.com.