CFO allows to define which fields will be shown in
"views" is the node under "interface" that starts the view definition. A report contains:
"{table}/{entity}":{
"interface":{
"views": {
"default": {
"name": "General View",
"all_fields": true,
"_server_order": "date_insertion DESC",
"server_limit": 500,
"server_limit_max_value":500,
"server_where": {
"status":"active"
},
"conditional_rows_background_color": {
"default":"",
"fields": [
{"field": "status","condition": "equals","values": ["LEAD"],"color": "#CCCCCC"},
{"field": "status","condition": "equals","values": ["EN ESTUDIO"],"color": "#CCFFCC"}
]
}
"fields": [
{"field": "license_id"},
{"field": "date_activation","order": "desc"},
{"field": "status"},
{"field": "device_imei"},
{"field": "device_brand"},
{"field": "device_model"},
{"field": "user_id"},
{"field": "device_age","row_group":true}
]
}
}
}
}
The behaviour between Database and Entity is quite significant but they share the same properties.
server_limit: default rows or entities to be returned.
server_limit_max_value: establish the max rows or entities to be returned (this value of the rows or entities to be returned can be change in CFO (CloudFrameworkObject).
server_where: object to define a basic where condition {var1:value1,var2:value2..}
server_order: the default order to be applied in the query
conditional_rows_background_color
@Adrian Martinez How can we show an atribute of a JSON fields?