Xataface Forums

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?

Try just:

Code: Select all

visibility:description=hidden


Tried but still shown.

Steve,

It only work without tableB.

Isn't that what I said in my previous reply? Did you get it working?

Steve,

It works. Thank you.

How about the order of these fields?

Hi! I'm having the same problem in trying to hide the tables fields listed in the relationship.ini from appearing in lower section of the find form.
Upon adding the relationships.ini. The related tables appears at the second section of the find form.

In my case I'm trying to build a database for a car park season card which is assigned to a car park bay.

Below is my relationships.ini

[Card]
card.BayID = "$BayID"
bay.BayID = card.BayID
section:visible=0
visibility:description=hidden

The above configuaration did not hide the related tables.

Please advice.

Is this something that I've done wrong?
Can anyone with a solution to my problem please help?

I think you're trying to do a slightly different thing. This thread was asking about hiding the field in a relationship list view. You're trying to hide it from the find form.

I don't recall if there is an easy way to do what you are trying to do right now. You could just hide the fields in question from all find forms by updating the fields.ini file visibility:find directive for the fields in question. A cheap way would be to use CSS or javascript to hide the sections in question (just look at the HTML source of the resulting find form to see what the CSS selector should be for your section... there should be a way to specify it).

-Steve