Forum Discussion
wilson_smyth
7 years agoPost Patron
Formula.Firewall issue: Passing query based parameter into a query
I have a list of countries in a database.
This list is populated from a sql query.
I then make this list into a parameter.
I then use this parameter in teh WHERE clause of another filter. I now get the error:
Formula.Firewall: Query 'Q1' (step 'Source') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
Its basically not letting me use a parameter based on a query, as a filter in another query.
is there any way around this besides hardcoding the list of parameter values?
1 Reply
- v-cherch-msftMicrosoft Employee
Hi wilson_smyth
You may have a look at this blog.Below is the similar post for your reference.
Regards,
Cherie