Integration with Fabrikar tables

OK, followed your examples, got it set up, however I cannot display the path on the map. Created a separate group, however does not work.
I do not quite understand your syntax when you use "Select latitude as lat", do you really have to rename the column when you actually specify the column name in the Visualisation?
I do not quite understand what is meant under "Driver" in server details.
Apart from it, when I click "Visualisation", it does open, but I get a warning that "model class ZhosmmapModelVisualizations was not found in file".
Regards

Hi
For warning I'll check. Probably you need to clear cache.

For columns and tables.
I work with databases every day, and don't think of basic knowledge.

I use aliases for tables and columns.

I mean
you can write
It means I get two columns (latitude and longitude) in result select.

But you can have a few connected tables therefore:
- I use table aliases
- I use column aliases

For tableAs you can see alias t it is useful to access to correct table in WHERE clause
Aliases are useful to define what column in what table is used, because if you have the same column names in different tables you have difficulties to write correctly dependencies.

For columnsAs you can see aliases lat and lng will be in result SELECT data.
Aliases are useful to define what columns from what table I want to have in result SELECT data.
Moreover, if you use formulas you have to define alias to access to result as column (it is for example 2)

You don't need rename anything. Only aliases.

As for driver.

Write mssql for ms sql server.

I'll add description, example into it (and for basics SQL)

OK, I managed to have the path displayed. However only if I go to Map - Groups and mark Group Control as No. If I select Left, the group list appears on the left, but the list is empty and no path is displayed.
With the Group Control set to No, the path is displayed, but without the start/end icon specified in the Group.

Aha. Do you want to manage this paths by groups?
I did visualization but didn't think about its management.
Probably I need analyse how manage it.

I think it is because you set group, but I didn't get it into list. I'll check.
I think I know how to fix it. Tomorrow will do release for it.