news-callback-procs.xql

DB Query file

Related Files

• packages/news/tcl/news-callback-procs.xql
• packages/news/tcl/news-callback-procs.tcl

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>

  <fullquery name="callback::merge::MergePackageUser::impl::news.update_from_news_approval">
    <querytext>	
      update cr_news
      set approval_user = :to_user_id
      where approval_user = :from_user_id
    </querytext>
  </fullquery>	
  
  <fullquery name="callback::merge::MergeShowUserInfo::impl::news.getaprovednews">
    <querytext>	
      select news_id, lead
      from cr_news 
      where approval_user = :user_id
    </querytext>
  </fullquery>	

</queryset>