RTC Query Logic
![]() Hello,
|
2 answers
![]() I don't know why you made it so complicated. RTC will translate the query to an SQL statement and execute it. And that's it. How the SQL statement is executed depending on the database vendor, but the result should be the same.
select distinct t1.ITEM_ID, t1.STATE_ID, t1.ID |
![]() Donald,
|
Comments
All I know is that full text search will always be executed first. The rest, they should be constructed into one single SQL query. I don't see any passing happening.
Can you give a more detailed example to explain your logic? Say ((Summary contains "test") AND (Type is Defect)), or something like that.
Not realizing that there is a screen shot. Attached here: