[Building Sakai] How to hide course sites programatically via sql queries.

[Alexandre Ballesté]

We had a similar requirement time ago. We needed to hide some sites from 
site tool bar and more sites popup menu from all users but keeping them 
published. We did a modification to the portal more site menu. 
(MoreSiteViewImpl.java) to not adding the sites on the menu if they were 
of type 'hidden'.  Maybe you could try something like that. If you take 
a look to this class you could find a new way to filter sites that you 
don't want to show.

Cheers.

On 01/22/2013 12:11 PM, Jehan Badshah wrote:
> Dear Alexandre
>
> if it is not possible through sql queries then how can we do it using 
> webservice.
>
> Thanks
>
> On Tue, Jan 22, 2013 at 3:55 PM, Alexandre Ballesté 
> <alexandre.balleste at udl.cat <mailto:alexandre.balleste at udl.cat>> wrote:
>
>     Hi
>
>     I believe that it's not possible to do that using SQL queries. If I am
>     not confused, the value that determines if a site is hidden or not in
>     user's preferences is inside a column where its value is a xml. The
>     element value that has that information is also encoded into base64.
>     Could anybody confirm that?
>
>     Cheers
>
>     Alex
>
>
>     --
>     Alexandre Ballesté Crevillén  alexandre.balleste at udl.cat
>     <http://udl.cat>
>     =====================
>     University of Lleida
>     Information and Communication Systems Service
>     Analyst / Programmer
>     Twitter: @sinmsinm
>
>     Tlf: +34 973 702148 <tel:%2B34%20973%20702148>
>     Fax: +34 973 702130 <tel:%2B34%20973%20702130>
>     =====================
>
>     _______________________________________________
>     sakai-dev mailing list
>     sakai-dev at collab.sakaiproject.org
>     <mailto:sakai-dev at collab.sakaiproject.org>
>     http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
>     TO UNSUBSCRIBE: send email to
>     sakai-dev-unsubscribe at collab.sakaiproject.org
>     <mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a
>     subject of "unsubscribe"
>
>
>
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130122/7830c4d8/attachment.html