Re: [sakai-dev] Query to find all the resources uploaded by a user

classic Classic list List threaded Threaded
1 message Options
Miguel Pellicer Carro Miguel Pellicer Carro
Reply | Threaded
Open this post in threaded view
|

Re: [sakai-dev] Query to find all the resources uploaded by a user

Hi Cillie, a bit dirty query that may work for you (MySQL), the performance will be really poor.

SELECT * FROM sakai.content_resource where binary_entity like '%CHEF:creator%your_user_internal_id%';

Miguel


El 01/02/2018 a las 12:57, [hidden email] escribió:
Hallo

I need to find all the resources uploaded by a certain user Is there a query for this?

Thanx so much
Ciellie
--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.

-- 
-----------------------------------------------
Miguel Pellicer
CTO at EDF

Website: http://www.entornosdeformacion.com/
LinkedIn: https://www.linkedin.com/in/mpellicer-edf
Office Phone: +34 - 96 381 35 75
-----------------------------------------------

--
You received this message because you are subscribed to the Google Groups "Sakai Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/a/apereo.org/group/sakai-dev/.