Home Discussions Questions & Answers Dynamically Converting Hardcoded Values in Discoverer SQL

Dynamically Converting Hardcoded Values in Discoverer SQL

Avatar photoCustomer August 25, 2024 at 3:23 am

When importing Discoverer SQL, we frequently encounter hardcoded filter values (literals). Is there a profile that automatically converts these literals into proper bind variables during the import process?

Viewing 4 reply threads
  • Author
    Replies
    • Support August 26, 2024 at 9:25 am  

      Yes, you can use the profile option ‘Blitz Report Discoverer Import Literals as Binds’. When set to ‘Yes’, Blitz Report automatically replaces literals with binds during Discoverer import.

    • Avatar photoCustomer August 27, 2024 at 4:19 am  

      What is the default setting for this profile?

    • Support August 27, 2024 at 11:20 am  

      The default setting is ‘No’.

    • Avatar photoCustomer August 29, 2024 at 12:40 pm  

      Does this only affect Discoverer Worksheet imports?

    • Support August 30, 2024 at 7:55 pm  

      The profile is listed under the Discoverer import settings and applies specifically to the conversion process of Discoverer SQLs.

Viewing 4 reply threads
  • You must be logged in to reply to this post.

Login with: