Pascal Voitot wrote:
hello, I would like to write some scripts which do some more complex SQL extraction requests using for example $xwiki.search(sql)... no modif of the DB, just extraction for presentation... I would prefer not to be forced to code a new Java module just for this...
But this function is protected by programming rights... So I must give programming rights to allow people to view this page... I find a bit disturbing because programming rights have a "sensitive" meaning in my head...
What's your point of view about this? What's the lightest, cleverest and fairest way to allow this? Any advice? :)
You could rewrite your query... I usually select the documents that contain the data I'm interested in (using searchDocuments), and then display the data from those documents. It is slower, indeed, but I don't need programming rights. If too much data is involved, and performance is important, then I use programming rights. -- Sergiu Dumitriu http://purl.org/net/sergiu/