...
2. In the admin dashboard Table, all fields are in string formate when fetched from the JSON even though their datatype is number or Date. Because of this, the sorting of the table on these fields is not working as expected
...
Solution
1. Each of the
...
fields can have two attributes that specify the datatype
...
and is the field
...
sortable
...
Solution 2
...
this will be in the JSON so that the update will be easy. whoever is consuming the JSON will write the conversion mechanism from string to the required datatype
Pro's
all the field types are stored as a JSON and if a new type has to be added this will make it easy to add and the handling of data becomes easy
2. Depending on the field name the consumer writes the conversion mechanism of the datatype.
cons
As the datatype is dependent on the field name this may not be accurate and also if a new field name is added then the mechanism need to be added to convert the datatype.
3. In the admin dashboard Table, there is a requirement to have filters so that the table data can be filtered depending on the required field value
Solution
1. JSON can have the visible column list
this can be done as shown in the link https://datatables.net/extensions/fixedcolumns/examples/initialisation/colvis.html
4. In the admin dashboard Table, there should be an option for multiple tabs of the table (These tables are the subset of the master data that we are getting)