thanks, now it's ok, but there's someway to define specific reports to user groups? like this: User Group Manager has acces to report 1 and 2, and User Group Developer has access to report 1 only?
Best Regards, Daniel França On Wed, Jul 21, 2010 at 9:37 AM, Ethan Jucovy <[email protected]>wrote: > 2010/7/21 Daniel França <[email protected]> > >> no, it can be a report too =) but I need that the user can't modify that. >> how I do that in Report? >> I'm new at Trac and I saw some docs about Reports, but all of them say to >> use SQL(that I know), but I don't where I've to put my SQL in Trac =x >> > > As an admin user go to http://your-trac-site/report (or click "View > Tickets" > "Available Reports") and you'll see the list of available > reports. Click "create new report" and you can put a SQL query in the form > there. > > Trac comes with some sample reports to show you how to write them. IIRC > report #8 will give you the template you need here - "Active tickets, mine > first." If you click on report 8 and then click "Edit report" (or "Copy > report" if you want to keep the sample pristine) you'll see that it uses a > special variable $USER which is dynamically filled in with the logged-in > user's username when the report is viewed. You should be able to fiddle > with that report's SQL until it gives you what you want. > > To prevent the users from changing the query, you could assign the > "REPORT_MODIFY" permission in Admin > Permissions. Or, rather, make sure > you *don't* assign the REPORT_MODIFY permission to your regular users. > > Caveat: Trac's core devs have semi-deprecated the SQL reports function. > They have no specific plans to actually remove it, but they put their energy > into improving the query module instead. Personally I still much prefer the > power and flexibility of the reports. (And I have a soft spot for them; I > basically first learned SQL by trial-and-error on Trac reports when I needed > stuff.) > > -Ethan > > On Wed, Jul 21, 2010 at 9:23 AM, Ethan Jucovy <[email protected]>wrote: >> >>> Is it important that it be a custom query? IIRC this would be supported >>> out of the box if you could use a report instead. >>> >>> 2010/7/20 Daniel França <[email protected]> >>> >>>> Hi all, >>>> There are some way to create custom queries specific for a user, and >>>> doesn't allow him to change the query? >>>> >>>> Best Regards, >>>> Daniel França >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Trac Users" group. >>>> To post to this group, send email to [email protected]. >>>> To unsubscribe from this group, send email to >>>> [email protected]<trac-users%[email protected]> >>>> . >>>> For more options, visit this group at >>>> http://groups.google.com/group/trac-users?hl=en. >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "Trac Users" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]<trac-users%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/trac-users?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Trac Users" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<trac-users%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/trac-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Trac Users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<trac-users%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/trac-users?hl=en. > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
