Clarity

  • 1.  Saved report parameters

    Posted Jan 15, 2016 12:54 PM

    I am looking to write a query to find out how many users have reports where they have saved the parameters. Unfortunately, the tech ref manual is a bit vague on this and I do not have the time to go digging. So if anyone has the information it would be greatly appreciated.

     

    Thanks!



  • 2.  Re: Saved report parameters

    Posted Jan 18, 2016 02:32 AM

    select * from cmn_attribute_value_sets where name = 'SavedParamName'

    Other tables that you can use are -- cmn_attribute_values, cmn_attributes,cmn_business_objects