Does anyone know, is it possible to data item value as render variable for another page?
I have a simple SQL query, which returns me results into a list like:
id | checkbox1 | checkbox2 |
1 | - | - |
2 | + | - |
3 | - | + |
4 | - | - |
i need to have a render variable for another page which uses checkbox1 and checkbox2 as values. But trying doing this i receive only error. I wrote an expression for variable:
[myquery].[checkbox1] ='+'. however it works within same list...
Is it possible to make it work like this?
checkbox1 has many values as it comes from a list. obviously it will not work on a variable as the variable requires only 1 value. you might need to rethink your design
Create a new query called "page whatever render"
In that query add a filter [checkbox1]='+' and [id]=2 or whatever you need.
Add a list to the page you want hidden, and put the results from that query in the list. On the list properties there's a property called "render page when empty". Set that to no, and set the box type to none.
When the list is empty, the query is returning no results, then it will cause the page to not render.
Quote from: CognosPaul on 13 Mar 2019 04:59:54 PM
Create a new query called "page whatever render"
In that query add a filter [checkbox1]='+' and [id]=2 or whatever you need.
Add a list to the page you want hidden, and put the results from that query in the list. On the list properties there's a property called "render page when empty". Set that to no, and set the box type to none.
When the list is empty, the query is returning no results, then it will cause the page to not render.
Thanks! Worked great for me