Question

How to create a Quick report / SQL with a dynamic FROM statement

  • 24 February 2022
  • 1 reply
  • 220 views

Badge +1

I am trying to use select * from <report_id> where result_key = &result_key to create a quick report for a user given result_key AND report_id as input parameters. (example report_id : Cust_Age_Analysis_Rep)

it is not possible to give an input parameter for the from view/table.

What are the possible options to solve this issue?


This topic has been closed for comments

1 reply

Userlevel 7
Badge +18

Hi @Warren Pietersz,

 

Not sure if this can be done in the application since it introduces a major security vulnerability as it allows the user to directly enter the value of the table name which would make your query susceptible to SQL injection.