Hi there

Using SQL query for an ARI Smart Content Data Table works excellent. The possibilities of "Format" for columns settings as well.

I'm using this:
<a href=ghgo-daten/anl/{$columns:rs} target=__blank>RS</a>

This ist excellent. Now I should define a rule that this is only fine for not empty fields. Is there anywhere an instruction what's possible within the Format specifications?

My need:
- if not empty
- do this: <a href=ghgo-daten/anl/{$columns:rs} target=__blank>RS</a>
- else do nothing

Which script can I use for this instruction?

Thanks for your support.
Heinz

PS
Additionally I should change the date format for another field. Usually I'm using something like this:
<?php $date = new DateTime($value);$value = $date->format('d.m.Y');?>

Hello,

The extension doesn't support ability to use "if" statement in "Format" parameter.

Use {$value|date_format:"d.m.Y"} code to format date value.

Regards,
ARI Soft

Thank you for the transformation script. This works correct using this code:
{$value|date_format:d.m.Y}
to make sure that the " are not shown in the field.

But it impacts the sort rule and it's not anymore the loading rule:
ORDER BY
datum DESC
It then sorts with the new value from left to right d ... m ... Y

Maybe you would have any hint for a workaround to have the date following our rule "d.m.Y" and to sort by date and not by text?

Thanks and best regards.
Heinz

Hello

A quick test using Type "Date (dd/mm/YYYY)" instead of "Date" helps to load with SQL loading sort but the column with the date is not anymore sortable. Icons are available but inactive. If I restort using another column then I have no possibility to go back to the original sort (use the sort of the column with the date).

Regards,
Heinz

Could you provide a link to a page where the problem occurs?

Regards,
ARI Soft

Sure. At the moment the table is implemented on this page:
www.ghgo.ch/impressum
Here it's based on a SQL query from a database.

and it's forseen to replace the old table on www.ghgo.ch/ghgo-anlaesse.html (where it is a load from a CSV file with full qualified link.

=> my proposal is to turn off the sort-changed within the table then it's not anymore a problem - and it is not really a business need to change the sort - the search functionality covers the real need.

Regards,
Heinz