WQL for My Tickets+discussion

Great idea - feel free to do it! --John


We made cards like this once for developers. See Lewis Hoffman+my current tickets (my current tickets+*right+*structure) and Lewis Hoffman+all tickets (all tickets+*rform). I think they were just using +assigned_to (as opposed to who created the card) and didn't include support tickets or Ideas, which this would need.

  --Ethan McCutchen.....Thu Sep 24 08:06:04 -0700 2009


Latest right now ... That's odd. Should the comment widget ever be pre-populated? I just left a comment on another ticket, and when I opened another discussion, the widget had the text from my comment on the last one.  Ok, so I added this accidentally, edited the discussion page so remove it, save, then add an comment with the widget, edit again ... This is here in the buffer.  I close and open again ... It seemed to be gone, but then I edit again and I still have this to save (I'm expecting the autosave error ...)

 

Yes, I got the error, and here was the comment I wanted to add:

I'm stil not quite getting WQL. What did I do [http://wiki.noubel.com/wagn/Practical_questions+named_for|here]?

  --Gerry Gleason.....Fri Sep 25 06:17:56 -0700 2009


I now see the WQL in the "inclusions" tab on the trunk card I'm trying to implement this for. here

  --Gerry Gleason.....Fri Sep 25 07:52:12 -0700 2009


I'm debugging now. Added some logging to search and found out it was searching for type "FAQEntry" not "FAQ Entry", which is correct. This card was renamed as some point from FAQEntry to FAQ_Entry.

  --Gerry Gleason.....Fri Sep 25 08:41:27 -0700 2009


Ok, looks lie maybe mysql version: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

  --Gerry Gleason.....Fri Sep 25 08:50:09 -0700 2009


Ethan helped me with the WQL, and I was able to finally get this right. The working search is here now:http://wiki.noubel.com/wagn/in_category+*rform

WQL: {"type": "FAQ_Entry",

"right_plus": ["category",{"refer_to":"_self"}]}

  --Gerry Gleason.....Sun Oct 04 05:03:51 -0700 2009