I noticed with the ARI Smart Content SQL setup, when I want to relabel the field names, I must must use underscore for two or more header names. I tried to use apostrophe around two more word header names (no underscore) but new relabeled header shows the apostrophes with the header name. When I use use no apostrophe around two more word header names and no underscore I get error. Just wondering if this may be a bug. I don't have have this issue when I use sql code in other components.

Hello,

Could you provide samples of configuration and SQL quer(ies)?

Regards,
ARI Soft

Here's my sql code:

------------------------------
SELECT
concat(firstname, ' ', (LEFT (lastname,1))) as Name,
attending_banquet as Attending_Banquet,
attending_family_night as Family_Night

FROM `kamc3_chronoforms_data_RSVP-20-Yr-Anniversary`

WHERE attending_family_night = "Yes Attending Family Night" OR attending_banquet = "YES"

ORDER BY firstname ASC

----------------------------------

I wanted the table headings to appear without the underscore when report is generated and an csv export is done, but when I code:

attending_banquet as "Attending Banquet",
attending_family_night as Family_Night

The double quotes are appearing and I tried using single quotes then, single quotes appearing. Which I don't want either. (see attached.)

Ok so I played around and copied the special quote mark in From line and I got the results I wanted. No quotes, no underscore in the column header.

SELECT
concat(firstname, ' ', (LEFT (lastname,1))) as Name,
attending_banquet as `Attending Banquet`,
attending_family_night as `Family Night`

FROM `kamc3_chronoforms_data_RSVP-20-Yr-Anniversary`

WHERE attending_family_night = "Yes Attending Family Night" OR attending_banquet = "YES"

ORDER BY firstname ASC

We can't reproduce the problem. Could you provide a link to a page where it occurs and a temporary access to your J! backend by email so we can investigate the problem?

Regards,
ARI Soft