Issue with date retrieval from database?

General Discussion
1

I picked date using datetime input component and saved in database:
image

now when I am retrieving it using following query to perspective table its showing wrong value:
SELECT expense.expenseId,
expense.employeeName,
expense.description,
expense.job,
expense.cdnTotal,
expense.usdTotal,
expense.euroTotal,
expense.expenseDate,
expense.selected
FROM expense

image

Thank You

2

You’ll need to configure the props.columns section of your table. The props.columns[x].field should be equals to the column name, set your props.columns[x].dateFormat as you like and if needed, force the props.columns[x].render to date.

1 Like
3

image
image359Ă—892 37.7 KB

Since data is fetched from database there is no props.columns

4

i added columns and tried still not working
image

5

The props.columns can be auto generated by your dataset with the system.dataset.getColumnHeaders. If you want to have some flexibility on your table, the columns attribute is the way to go.

1 Like
6

You need to set the field with the column’s name.

2 Likes
7

Thank You so much you solved my two issues with this.