[Building Sakai] Logged in User

[Steve Swinsburg]

That won't work for provided users that have no entry in the Sakai user table. 

Maybe the user id map table? Not the best table to store it though. A new table?

As for code, a trigger on the db might be better so that the API doesn't need to change. 

Also, if you only care about current data, the activityservice API might give you what you need. 

Cheers
Steve

Gesendent von meinem iPhone

On 21/02/2013, at 2:55, Charles Severance <csev at umich.edu> wrote:

> My suggestion is that we actually fix this by adding a column to the user table and adding code to keep that data up-to-date.
> 
> Getting it from a join while possible, is poor for performance, and there are subtle security and  issues with not tracking this information.
> 
> I suggest we open an KNL JIRA and make this a feature request. 
> 
> Thoughts?
> 
> /Chuck
> 
> On Feb 20, 2013, at 7:32 AM, Nguni Phakela wrote:
> 
>> Hi All,
>> 
>> How do I find the last time (date) that a user has logged into Sakai?
>> 
>> Cheers,
>> 
>> -- 
>> Nguni Phakela
>> _______________________________________________
>> 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"
> 
> _______________________________________________
> 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"