If I do the relations with the +UB index and put 2016-10-01 as the start date and 2016-10-20 as the end date for a specific project, do I get that project in my result set if I do the collect with sdate 2016-10-15 and end date 2016-11-15?
On Mon, Dec 12, 2016 at 1:01 PM, Alexander Burger <a...@software-lab.de> wrote: > On Mon, Dec 12, 2016 at 11:12:22AM +0100, Henrik Sarvell wrote: > > This looks like the one I need, I want all projects whose date range > > has any kind of overlap with the given date range. > > How do you think about the '+UB' tree solution I suggested in my follow-up > mail? > > > (class +Proj +Macropisobj) > > ... > > (rel sDate (+UB +Aux +Ref +Date) (eDate)) > > (rel eDate (+Date)) > > > > Then a 'collect' would find the range directly: > > > > (collect 'sDate '+Proj (list Sdate Sdate) (list Edate Edate)) > > I think that is much more elegant and efficient. > > - Alex > -- > UNSUBSCRIBE: mailto:picolisp@software-lab.de?subject=Unsubscribe >
