RTC Query for Truly modified defects daily
![](http://jazz.net/_images/myphoto/7df444bdacda8ed76e33058077cbb01f.jpg)
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
![](http://jazz.net/_images/myphoto/7df444bdacda8ed76e33058077cbb01f.jpg)
You can add another "AND" condition that "creation date is not today".
Comments
![](http://jazz.net/_images/myphoto/7df444bdacda8ed76e33058077cbb01f.jpg)
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