Dear Wappler Team
I want to report a small but still significant issue when working with data views.
The scenario involves a Postgres view, constructed with a master table (jobs) and a number of simple inner joins (status, type, category, etc) to provide expanded data to be used in a bootstrap 5 table.
The job table (master) includes a “created” column as a timestamp with timezone for when the job was added. This column is also included in the view.
In Wappler the “created” column is correctly reflected as a timestamp with timezone value in the jobs table.
In the view however, it is seen as a time value, and there is no way to correct it. This means that the data in the table view disregards the date and only shows times.
This is most probably a bug since there is no way to “update” the view to change the data type to its correct type.
Is there anything I perhaps missed here?
Any help would be greatly appreciated.
Regards
Nantus
Last updated: