Tools

piotras said

piotras  

Irony: I can join 20 tables using MidgardQuerySelect, but have big difficulties to create one simple 1=1 condition....

4 comments

piotras posted to #midgard 19.03.2010 (en)

4 comments

Bottom

indeyets  

Well, maybe you just don't need it ;)

indeyets commented on posted to #midgard 19.03.2010 (en)

piotras  

@indeyets I hoped so, but there's need to have "fallback" condition when there's no constraint specified by user. Basic query is built as base constraint group - `cond AND cond' (1=1 AND deleted=0). Though no idea what should be fallback when one includes deleted objects.

piotras commented on posted to #midgard 19.03.2010 (en)

indeyets  

@piotras but why do you need fallback? can't you just use single condition there? or empty condition when it is not needed at all?

indeyets commented on posted to #midgard 19.03.2010 (en)

piotras  

@indeyets I could do this. But this is very complicated to implement (and I am afraid error prone). Basically our query is: 'user_part AND deleted=0 AND some_workspace_stuff AND something else'. To do this, you have to create initial 'AND' "group". If you do not want, you have to initialize base GDA operations and expression in few places which is bad.

piotras commented on posted to #midgard 19.03.2010 (en)

Login or register to leave a comment

Publicity
These messages are public and can be seen by anyone.