Hello, Steve,
I have a relationships.ini where I use customs SQL which left join with another table. On the list, I can see the all of fileds out the two tables. And I follow the visibility:tableA.somefiled=hidden but the somefield is still shown in the list. I have tried two options in relationships.ini as below:
1. [somerelations]
tableA.r_id="$r_id"
tableA.code=tableB.code
visibility:tableB.description=hidden
2. [somerelations]
__sql__ = "SELECT tableB.title, tableA.others from tableA where tableA.code=tableA.code and tableA.r_id='$r_id'"
visibility:tableB.description=hidden
I still get all the fileds from both tableA and tableB.
Any suggestion?