Re: [fossil-users] Username in report query

2014-09-30 Thread Tomek Kott 
Thanks Joe, 

I had tried creator = '$login' but somehow failed to try it without the 
single quotes.

Tomek

 Date: Mon, 29 Sep 2014 16:39:04 -0700
 From: Joe Mistachkin sql...@mistachkin.com
 To: 'Fossil SCM user's discussion'
   fossil-users@lists.fossil-scm.org
 Subject: Re: [fossil-users] 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 work:
 
   SELECT
   title AS 'Summary'
   FROM ticket
   WHERE status = 'Open' AND assignee = $login
 
 It should be noted that there are no quotes around the $login
 parameter used in the above query.
 
 --
 Joe Mistachkin
 
 
 
  ___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

[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 is '$login') where 'creator' is a column in my ticket schema. 

Any thoughts how to accomplish this so users can look at the tickets they 
created would be great!

Thanks,

Tomek
  ___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users

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 should be noted that there are no quotes around the $login
parameter used in the above query.

--
Joe Mistachkin

___
fossil-users mailing list
fossil-users@lists.fossil-scm.org
http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users