Product Category View

select * from cns_mst_productcat where type is NULL order by sort_order
select * from cns_mst_productcat where ref_id = #url.txtref_id# select table_name from reference where category_id=#txtref_id# select * from #rs_reference_sel_table_name.table_name# where exist <> 'N' order by sort_order
  Choose Product Category  
  Product ID  
  ProductCategory ID   #cat_id#


select external_field,table_name,internalfield,Notations,unit_of_measurement,image from reference where category_id=#txtref_id# order by format select product_id from #rs_reference.table_name# where exist <> 'N' order by sort_order select product_id as currproduct_id from #rs_reference.table_name# where product_id='#rs_table_name_sel.product_id#' and exist<>'N' select product_id from #rs_reference.table_name# where exist <> 'N' order by sort_order
select ref_id from cns_mst_product where product_id='#msproduct_id#' and cat_ref_id=#txtref_id# select * from #rs_reference.table_name# where product_id='#msproduct_id#'
Product ID - #External_Field#
Notation
- #Notations#
Units -
  #msproduct_id# #msproduct_id#   #msproduct_id# - -  #Evaluate(fieldvalue)#  #Evaluate(fieldvalue)#  #Evaluate(fieldvalue)#
The property page has not been included