Hi everyone,
I have a question about the where format in an @SELECT binding/tv.
Following situation:
Pages list a datagrid table with values from a new table within modx DB. I fill/update this table with automatic import of an excel file.
The pagetitle of my page = the same value as one of the columns in my new DB.
Now I want to fill the datagrid automatically by setting the default value to:
@SELECT * FROM {prefix}.modx_informatica WHERE Pakket="[+pagetitle+]"
Since my Pakket value of the DB is the same as my pagetitle, this would make my datagrid tv automatic. Would be easier when adding a new document --> so that I don’t have to change the value of my WHERE clause ...
How could I solve this? Can I use pagetitle as value in the WHERE clause?
Thx for any help!
