mehrdad posted a review on Rufus

mehrdad posted a comment on discussion Help

in search page we can set some parameters and search! as describe here https://ifdefined.com/doc_bug_tracker_queries.html how can I obtain query that make in search page? thanks

mehrdad posted a comment on discussion Help

in search page i set some parameters, and as you know this action make query. now the question is how can I see this query? thanks

mehrdad posted a comment on discussion Help

hi how can i create query that count total number of specific state of each bug? i have field that call "env" it means multiple environmens like: dev, test, opr, .... i want to write query that show how many time "env" status change to test? like this, below bug state of "env" 5 times change to the "test": bug_id | count send to test 10 | 5 thanks

mehrdad posted a comment on discussion Help

hi how can I write sql query that filter bugs by date? e.g. need to get bugs from 3 months ago. thanks

mehrdad modified a comment on discussion Help

hi i want to create report table like this: bugid | short_desc | project | reported_by | chktest | status count (test) | date of latest status change to (test) | status count (fail) | count of days that status was in (test) | date of status was set (done) FYI: 1- I us from "status" as group name, example: dev , test, opr ,... . also as status like: fail cancel, done,... 2- count: mean total number that "status" change to "test". 3- date: date that "status" change to "done". thanks

mehrdad modified a comment on discussion Help

hi i want to create report table like this: bugid | short_desc | project | reported_by | chktest | status count (test) | date of latest status change to (test) | status count (fail) | count of days that status was in (test) | date of status was set (done) FYI: 1- I us from "status" as group name, example: dev , test, opr ,... . also as status like: cancel, done,... 2- count: mean total number that "status" change to "test". 3- date: date that "status" change to "done". thanks

mehrdad posted a comment on discussion Help

hi i want to create report table like this: bugid | short_desc | project | reported_by | chktest | status count (test) | date of latest status change to (test) | status count (fail) | count of days that status was in (test) | date of status was set (done) ---------- | ---------- | ------ | ---------- | ------ | ---------- | ------ | ---------- | ------ | ---------- | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell | Cell...