I'm stupid, I think I can do this in the SQL query :P 2010/7/22 Daniel França <[email protected]>
> 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.
