Re: [fossil-users] Username in report query

2014-09-30 Thread Tomek Kott
] Username in report query Message-ID: BEFE4B10C1B04381BD8A8527EA3BAB04@LACHRYMOSE Content-Type: text/plain; charset=US-ASCII Tomek Kott wrote: Is there a way to get the current username into the report dynamically? Or, can I use TH1 within the query code? The following might

[fossil-users] Username in report query

2014-09-29 Thread Tomek Kott
Hi there, Is there a way to get the current username into the report dynamically? Or, can I use TH1 within the query code? I'm guessing the answer is no for security reasons. I just tried it -- I was trying to filter on the $login variable that should always be accessible (i.e. WHERE creator

Re: [fossil-users] Username in report query

2014-09-29 Thread Joe Mistachkin
Tomek Kott wrote: Is there a way to get the current username into the report dynamically? Or, can I use TH1 within the query code? The following might work: SELECT title AS 'Summary' FROM ticket WHERE status = 'Open' AND assignee = $login It