RTC Query for Truly modified defects daily
How can I build in the web RTC a query that will pull defect data for defects that have been truly modified? Currently when i create the query to pull modified date = today it shows the defect i created but did NOT modify, because creation date = modified date at the time of creation. Modified date = today and creation date is not today won't work i don't believe because it exclude defects that were both created today and modified today.
That is the part i cant figure out So if i do modified date=today and creation date not = today it will exclude the ones i created earlier in the day and decided to modify later on in that day . If modified date was truly the date when you modified the defect OR there was a filter for "creation date not equal to modified date" I believe it would be solved
That is the part i cant figure out So if i do modified date=today and creation date not = today it will exclude the ones i created earlier in the day and decided to modify later on in that day . If modified date was truly the date when you modified the defect OR there was a filter for "creation date not equal to modified date" I believe it would be solved
One answer
You can add another "AND" condition that "creation date is not today".
Comments
Will it exclude defects that were both created today and modified today? That is the part i cant figure out So if i do modified date=today and creation date not = today it will exclude the ones i created earlier in the day and decided to modify later on in that day . If modified date was truly the date when you modified the defect OR there was a filter forĀ "creation date not equal to modified date" I believe it would be solved