synonyms-view.xql

DB Query file

Related Files

• packages/categories/www/cadmin/synonyms-view.xql
• packages/categories/www/cadmin/synonyms-view.tcl
• packages/categories/www/cadmin/synonyms-view.adp

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>
<queryset>

<fullquery name="get_synonyms">
      <querytext>
      
    select s.synonym_id, s.name as synonym_name, l.label as language
    from category_synonyms s, ad_locales l
    where l.locale = s.locale
    and s.category_id = :category_id
    and s.synonym_p = 't'
    [template::list::orderby_clause -orderby -name synonyms]

      </querytext>
</fullquery>

 
</queryset>