I know this is an old thread but I have a related question. I am quering the tables directly in SQL and I have noted if I I do a pure
select * from Cases where created on >= date (or created_on >= and created_on <= date
I get alot of results. With many being copied (is_copy > 0). If I add
and is_copy = 0
I get a much more reasonable number.
It almost seems that everytime a case is updated, a new record is written into the case table. This makes the results not to be accurate as if I add in “is_copy = 0” then I will drop any cases that ARE copied to a new project/section. If I remove it - then I get al of the updates thru the days. I want the cases created and copied to a new procect/section alone between dates.
How can I get the information I would like to provide to my boss?