Irony: I can join 20 tables using MidgardQuerySelect, but have big difficulties to create one simple 1=1 condition....
posted to #midgard 19.03.2010 (en)
Irony: I can join 20 tables using MidgardQuerySelect, but have big difficulties to create one simple 1=1 condition....
@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.
@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.
Copyright Rohea Oy 2010 | Mobile version | Feedback | API | Terms of Service | Applications and tools