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" <[email protected]> > To: "'Fossil SCM user's discussion'" > <[email protected]> > 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 [email protected] http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
