visibility of fields if i include a sql in my fields.ini

Archived from the Xataface Users forum.

chapin — Fri Mar 27, 2009 8:18 am

Hello!

I included a global directive in my fields.ini It looks something like this:

---

__sql__ = “SELECT A, B, C ….”

[Address]

widget:type = textarea

visibility:csv =hidden

[Phone]

widget:type = textarea

visibility:csv =hidden

[Name]

widget:type = textarea

[FamilyName]

widget:type = textarea

.

.

.

---

When I click on csv-export i get the fields Name and FamilyName, I dont get Address and Phone which is exactly what I want. But, I also get A,B,C

which I would like to exclude. How do I procede to exclude those fields from the cvs-file?

Thanks in advance

Chapin

---

chapin — Mon Mar 30, 2009 11:56 pm

chapin wrote:Hello!

I included a global directive in my fields.ini It looks something like this:

---

__sql__ = “SELECT A, B, C ….”

[Address]
widget:type = textarea
visibility:csv =hidden

[Phone]
widget:type = textarea
visibility:csv =hidden

[Name]
widget:type = textarea

[FamilyName]
widget:type = textarea

.
.
.

---

When I click on csv-export i get the fields Name and FamilyName, I dont get Address and Phone which is exactly what I want. But, I also get A,B,C
which I would like to exclude. How do I procede to exclude those fields from the cvs-file?

Thanks in advance
Chapin

My mistake!!! I found the solution myself, fields A,B and C were from a third table which was involved in my query. So I simply updated the fields.ini file for tath table and thats all.

cheers