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

A place for users and developers of the Xataface to discuss and receive support.

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

Postby 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
 
Posts: 12
Joined: Mon Aug 25, 2008 2:18 am

Re: visibility of fields if i include a __sql__ in my fields

Postby 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
chapin
 
Posts: 12
Joined: Mon Aug 25, 2008 2:18 am


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 15 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved