[Building Sakai] SURROGATEKEY in MFR_OPEN_FORUM_T

[Zhen Qian]

Thanks for the tips, Bryan!

- Zhen


On Wed, Mar 20, 2013 at 4:30 PM, Bryan Holladay <holladay at longsight.com>wrote:

> the surrogatekey is the ID for the level above it.
>
> So, Forum's surrogate key is Area's ID.  Topic's surrogate key is forum's
> ID (of=open forum, pf=private form).  Message's surrogate key is for
> Topic's ID.
>
> Correct, msgcntr doesn't delete anything, it just orphans the data.  The
> best way to re-attach a deleted Forum/Topic/or Message is by looking at the
> event history.  It will give you the ID of the Forum/Topic/or Message that
> was deleted.  Then just look up that Forum/Topic/or Message and re-set it's
> surrogate key to it's correct parent and it will be back in the UI
>
> -Bryan
>
>
> On Wed, Mar 20, 2013 at 4:16 PM, Zhen Qian <zqian at umich.edu> wrote:
>
>> HI, Sakai Developers:
>>
>> Both MFR_OPEN_FORUM_T and MFR_MESSAGE_T contain a field called
>> "surrogatekey". What is that field used for?
>>
>> When a forum or topic gets deleted, the surrogatekey is set to null. So
>> if we want to recover the forum, how can we find out the original
>> surrogatekey?
>>
>> Thanks,
>>
>> - Zhen
>>
>> _______________________________________________
>> 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/20130320/1966abbf/attachment.html