| chat.freenode.net #tryton log beginning Tue Feb 6 00:00:01 CET 2018 | ||
| 2018-02-06 00:04 <csotelo> ay suggest for this kind of quesy? | ||
| 2018-02-06 00:04 <csotelo> I was thinking that child_of could help, but I need the inverse result | ||
| 2018-02-06 00:13 <cedk> csotelo: I understand nothing | ||
| 2018-02-06 00:39 -!- JosDzG(~Thunderbi@177.238.97.34) has joined #tryton | ||
| 2018-02-06 01:13 -!- csotelo(~csotelo@181.64.241.195) has joined #tryton | ||
| 2018-02-06 01:17 -!- JosDzG(~Thunderbi@177.238.97.34) has joined #tryton | ||
| 2018-02-06 01:52 -!- JosDzG(~Thunderbi@177.238.97.34) has joined #tryton | ||
| 2018-02-06 01:59 -!- thaneor(~ldlc6@179.26.83.89) has joined #tryton | ||
| 2018-02-06 03:42 -!- csotelo(~csotelo@181.64.241.195) has joined #tryton | ||
| 2018-02-06 06:55 -!- zmijunkie(~Adium@i577B3A8B.versanet.de) has joined #tryton | ||
| 2018-02-06 07:53 -!- _2cadz(~2cadz@212-198-245-154.rev.numericable.fr) has joined #tryton | ||
| 2018-02-06 08:06 -!- cdchapman(~perturbed@73.98.169.172) has joined #tryton | ||
| 2018-02-06 08:17 -!- nicoe(~nicoe@2a02:578:858c:500:ee55:f9ff:fe7b:f7ac) has joined #tryton | ||
| 2018-02-06 08:41 -!- cdchapman(~perturbed@73.98.169.172) has joined #tryton | ||
| 2018-02-06 08:42 -!- zmijunkie(~Adium@b2b-78-94-52-226.unitymedia.biz) has joined #tryton | ||
| 2018-02-06 08:57 -!- mrichez(~smuxi@mail.saluc.com) has joined #tryton | ||
| 2018-02-06 08:58 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | ||
| 2018-02-06 09:01 -!- rpit(~rpit@p200300C88F351C0056EE75FFFE0DD3C7.dip0.t-ipconnect.de) has joined #tryton | ||
| 2018-02-06 09:22 -!- cedk(~ced@gentoo/developer/cedk) has joined #tryton | ||
| 2018-02-06 10:05 -!- nicoe(~nicoe@209.119-78-194.adsl-static.isp.belgacom.be) has joined #tryton | ||
| 2018-02-06 10:15 <csotelo> good morning dear comunity, cedk . I was working last day on trying to find a way to solve my issue related to no child query [ https://pastebin.com/XDJXnugM ] using field = None, unfortunately it works on a relation ship related fields, no on the father model, any suggest | ||
| 2018-02-06 10:19 -!- nicoe(~nicoe@209.119-78-194.adsl-static.isp.belgacom.be) has joined #tryton | ||
| 2018-02-06 10:22 <pokoli> csotelo: not sure to understand what you are trying to achieve | ||
| 2018-02-06 10:22 <pokoli> csotelo: using [('one2many', '=', None)] on the parent model, will return all the parents that have no related records | ||
| 2018-02-06 10:22 <csotelo> pokoli, hi, I am trying to build a query like https://stackoverflow.com/questions/6839500/need-sql-query-to-find-parent-records-without-child-records | ||
| 2018-02-06 10:24 <csotelo> pokoli, I see why my query was no working :( I have not a One2Many, just the Many2One. | ||
| 2018-02-06 10:26 <pokoli> csotelo: if you have a Many2One on the children model, you can add a One2Many on the parent using this field | ||
| 2018-02-06 10:27 <pokoli> csotelo: and then our domain will work | ||
| 2018-02-06 10:27 <csotelo> pokoli, thanks a lot. | ||
| 2018-02-06 10:27 <pokoli> csotelo: IIRC tryton will generate the second query of the stackoverflow first answer | ||
| 2018-02-06 10:31 <csotelo> pokoli, by the way, is there a way to see the result query on a Model.search? | ||
| 2018-02-06 10:35 <pokoli> csotelo: yes, Model.search([], query=True) will return the python-sql query for the search | ||
| 2018-02-06 10:35 <csotelo> thanks! | ||
| 2018-02-06 11:19 -!- nicoe(~nicoe@209.119-78-194.adsl-static.isp.belgacom.be) has joined #tryton | ||
| 2018-02-06 11:19 <csotelo> pokoli, by the way, It works asI was specting | ||
| 2018-02-06 11:33 -!- LordVan(~LordVan@gentoo/developer/LordVan) has joined #tryton | ||
| 2018-02-06 12:15 -!- mariomop(~quassel@181.93.206.162) has joined #tryton | ||
| 2018-02-06 12:17 -!- yangoon(~mathiasb@i59F4D428.versanet.de) has joined #tryton | ||
| 2018-02-06 12:24 -!- Artem(5d491808@gateway/web/freenode/ip.93.73.24.8) has joined #tryton | ||
| 2018-02-06 12:25 <Artem> Hello. Is there any way how to set up a default warehouse for Sale in case there are more then 1 Locations with type Warehouse? Thanks | ||
| 2018-02-06 12:26 <pokoli> Artem: not by default, but it can be done on third party module | ||
| 2018-02-06 12:27 <pokoli> Artem: what's your use case? | ||
| 2018-02-06 12:27 <Artem> Pokoli, thanks. Got it. | ||
| 2018-02-06 12:50 <Artem> Pokoli: the use case is for the online sale with Nereid module: once the sale order is processed for the web shop sale, the warehouse should be defined for such online Sale. The company has two warehouse locations. | ||
| 2018-02-06 12:52 <pokoli> Artem: and both warehouses are used to deliver online sales? | ||
| 2018-02-06 12:53 <cedk> Artem: you probably need a strategy to decide which warehouse to use for each order | ||
| 2018-02-06 12:57 <Artem> Pokoli: no, there is only one warehouse is used for the online sale. Just need to customize the online sale warehouse for the sales, which are going through online shop. | ||
| 2018-02-06 13:00 <pokoli> Artem: in this case you can add a field on the webshop table to indicate which warehouse should be used, but if you want to be generic probably a better solution should be found | ||
| 2018-02-06 13:01 <pokoli> For example another criteria will be to use for the warehouse that is nearest to the customer location | ||
| 2018-02-06 13:16 -!- hedererjs(~hedererjs@dig50-1-78-222-206-45.fbx.proxad.net) has joined #tryton | ||
| 2018-02-06 13:27 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | ||
| 2018-02-06 13:42 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | ||
| 2018-02-06 13:46 -!- yangoon(~mathiasb@i59F4A5BD.versanet.de) has joined #tryton | ||
| 2018-02-06 13:59 -!- thaneor1(~ldlc6@r186-48-40-104.dialup.adsl.anteldata.net.uy) has joined #tryton | ||
| 2018-02-06 14:09 -!- csotelo(~csotelo@179.43.97.56) has joined #tryton | ||
| 2018-02-06 14:16 <Artem> Pokoli: thanks for these ideas. Will look through them. | ||
| 2018-02-06 14:27 -!- catonano`(~user@151.45.63.119) has joined #tryton | ||
| 2018-02-06 14:36 -!- yangoon1(~mathiasb@i59F4DA89.versanet.de) has joined #tryton | ||
| 2018-02-06 15:16 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | ||
| 2018-02-06 16:33 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has left #tryton | ||
| 2018-02-06 16:33 -!- Timitos(~kpreisler@host-88-217-184-172.customer.m-online.net) has joined #tryton | ||
| 2018-02-06 16:51 -!- nicoe(~nicoe@host-85-201-184-151.dynamic.voo.be) has joined #tryton | ||
| 2018-02-06 16:51 -!- cdchapman(~perturbed@73.98.169.221) has joined #tryton | ||
| 2018-02-06 18:23 -!- _2cadz(~2cadz@82.64.14.213) has joined #tryton | ||
| 2018-02-06 18:55 -!- Telesight(~anthony@4dae0c97.ftth.telfortglasvezel.nl) has joined #tryton | ||
| 2018-02-06 20:00 -!- catonano(~catonano@151.45.63.119) has joined #tryton | ||
| 2018-02-06 20:20 -!- cdchapman(~perturbed@73.98.169.160) has joined #tryton | ||
| 2018-02-06 22:00 -!- semarie(~semarie@unaffiliated/semarie) has joined #tryton | ||
| 2018-02-06 22:12 -!- zmijunkie(~Adium@i577B3A8B.versanet.de) has joined #tryton | ||
| 2018-02-06 22:14 -!- cdchapman(~perturbed@73.98.169.130) has joined #tryton | ||
| 2018-02-06 23:15 -!- catonano`(~user@151.45.63.119) has joined #tryton |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!