Set latest journal(log) id when an issue updated (in a issues table)
Our staff want to know who made last updating for the issue on issue listing page.
Though issue list has lastupdate record, but does not have the name of last update user.
First I tried to handle our staff's request, like this.
# find laslatest journal by issue id def lastupdate_user(id) lastJournal = Journal.find(:last, :conditions => ["journalized_id= ?", id], :order => :created_on, :include => :user) if lastJournal != nil return lastJournal.user end end
But above is quite poor, and I'm afraid that this may cause some performance issues.
If allowed, please add the column to issue table, and set the latest log (journal) id of the issue iself when updating.