Hi!
I want to know if it's possible to sort a column with date format and how.
{
"display": "dbtable",
"table": "eform_mails",
"caption": "Sending Emails",
"fields": {
"id": {
"caption": "ID"
},
"name": {
"caption": "Name"
},
"address": {
"caption": "Address"
},
"city": {
"caption": "City"
},
"email": {
"caption": "Email"
},
"phone": {
"caption": "Phone"
},
"store": {
"caption": "Store"
},
"message": {
"caption": "Message"
},
"date": {
"caption": "Date",
"type": "unixtime"
}
},
"columns": [
{
"fieldname": "id",
"width": "5"
},
{
"fieldname": "date_pub",
"caption": "Date",
"width": "45",
"render": "[+date:ne=`0`:then=`[+date:date=`%d/%m/%Y`+]`+]"
},
{
"fieldname": "email",
"width": "50"
},
{
"fieldname": "store",
"width": "50"
}
],
"form": [
{
"caption": "Publication",
"content": {
"id": {},
"name": {},
"address": {},
"city": {},
"email": {},
"phone": {},
"store": {},
"message": {},
"date": {}
}
}
],
"configuration": {
"radioTabs": 0,
"sorting": 1
}
}