M
MonTpython
I am working on a form driven database that essentially looks for date
conflicts in between existing projects and new proposed projects. The key
function of takes a new proposed project date range and filters out all
facilities that have any existing project happening within that time frame.
The problem that I am having is that after following the advice I received
here in the much earlier design stages, I have changed from having each
existing project query separately and pass the results to the next project
query, to where now all existing projects are filtered simultaneously within
one massive query.
Everything works great when the user selects a handful of projects to test
against, but if they select more than just a few it begins to filter out
legitimate project candidates. I have looked at the ones being filtered out
and verified that they are properly formatted, and that each filter works
perfectly on its own.
Is there a likely culprit or am I doomed to piece out all 65 components of
the query and daisy chain them so that they run in series how I had it before
(I know it works that way, it’s just so much more of a pain to work with and
so much slower)
Any help or advice would be much appreciated.
Thanks,
MonT
conflicts in between existing projects and new proposed projects. The key
function of takes a new proposed project date range and filters out all
facilities that have any existing project happening within that time frame.
The problem that I am having is that after following the advice I received
here in the much earlier design stages, I have changed from having each
existing project query separately and pass the results to the next project
query, to where now all existing projects are filtered simultaneously within
one massive query.
Everything works great when the user selects a handful of projects to test
against, but if they select more than just a few it begins to filter out
legitimate project candidates. I have looked at the ones being filtered out
and verified that they are properly formatted, and that each filter works
perfectly on its own.
Is there a likely culprit or am I doomed to piece out all 65 components of
the query and daisy chain them so that they run in series how I had it before
(I know it works that way, it’s just so much more of a pain to work with and
so much slower)
Any help or advice would be much appreciated.
Thanks,
MonT