Project

General

Profile

Forums » Help »

RedmineDbWhereClause example not working in 1.0

Added by Lukas Heiniger over 13 years ago

Hi

I've upgraded our system to 1.0. Before (0.8), we used a customized version of Redmine.pm to authenticate svn users which would check the role of a user before it allows commiting.
It seems like this can now be done via RedmineDbWhereClause and there's even a (commented) example line in Redmine.pm that should do exactly what I need:

## Optional where clause (fulltext search would be slow and
## database dependant).
# RedmineDbWhereClause "and members.role_id IN (1,2)"@

However, since role_id isn't a column of members anymore and since I'm not very familiar with SQL I can't get this to work.
I'd be glad if somebody could help.

Lukas


Replies (1)

RE: RedmineDbWhereClause example not working in 1.0 - Added by Felix Schäfer over 13 years ago

I don't know what 0.8 did, but in 1.0.0 Redmine.pm actually checks if the user has the "View repository" permission for read and the "Commit to repository" permission for write access, maybe that is all you need :-)

    (1-1/1)