Hello everyone, I have a problem that due to my inexperience in tryton I don’t know how to solve it and I didn’t find a similar module. I have to plan jobs. And it is required to be loaded as follows.
I created the following table to store the data: job; month_number; quantity
I can think of two solutions:
Have 12 columns of months and by means of a field pass the months offset value to it.The problem I have is that I don’t know how to pass this displacement value to my tablequery (I have implemented this, both the obtaining of the data by tablequery, as well as the write method to save the data).
To have a tablequery with variable columns. The problem here I do not know if it is possible from tryton.
Thank you very much for your response. I will check what you sent me. The problem is that the number of months depends on the project, it can be from 5 months to 36 months for example, there is no limit of duration.
This rocks! It improved the performance a lot, I had done it with 12 joins.
I saw that with context_model I can filter the results, so in this case I can choose from which month I will start showing the results, but I saw that it applies to act_windows, I wanted to know if I can do the same for a view, since I want to show these results as a One2Many field, from another view.
I add a screenshot of how I want the interface to look like
As a context, the idea of the module is to see all the tasks to be done and to load which ones are going to be done and how many of them are going to be done in a specific month. It is proposed in this way so that visually it is easy to plan the tasks for the user.