Am 07.02.2017 um 18:57 schrieb Cédric Krier: > On 2017-02-07 18:22, Ul wrote: > >> I see the main Problem in filtering the records to decide witch records >> to show because they belong in this 'in-heritage'-tree. >> My approch would be a loop starting at the 'root'-lot looking up the >> lots that went into the production that produced the root-lot. and doing >> the same with the lots in the result and again with this results until >> every lot in the tree is processed that came out of a production. > > I do not understand what is this "filtering" problem. > The reason why I did see this problem with filtering was that I have only very basic knowledge of SQL and I underestimated it's power. After you stating that there is no problem I was reading more about SQL and finally came across WITH RECURSIVE, that should do what i need.
Having up/down trees in the base would be a nice feature, but at the moment i don't have the capacities to participate in development. But of course you can get the code i write for my module if it helps. After all I'm not a experienced programmer, just learning by doing whatever I need. -- You received this message because you are subscribed to the Google Groups "tryton" group. To view this discussion on the web visit https://groups.google.com/d/msgid/tryton/24f892c2-f5ed-e9e9-ce54-0dba7ee18ab7%40gmx.de.
