Demantra - Worksheet assigned Series

Worksheet assigned Series

SELECT DISTINCT q.query_name "Worksheet Name"
  --,gt.TABLE_LABEL "Level Name"
  ,
  cf.computed_title "Series Name"
FROM active_series a ,
  computed_fields cf ,
  queries q ,
  groups g
  --,group_tables gt
  --,queries_for_users qfu
  --,user_id ui
WHERE 1                =1
AND a.query_id         = q.query_id
AND a.forecast_type_id = cf.forecast_type_id
AND g.query_id         =q.query_id
  -- and g.group_table_id = gt.group_table_id
  --and q.query_id = qfu.query_id
  -- and qfu.user_id = ui.user_id
AND q.query_name = 'Worksheet Name' ;