{
"fldAMdMkhNHoR": {
"id": "fldAMdMkhNHoR",
"name": "组别",
"type": 3,
"property": {
"options": [{
"id": "opt7EnQsE20Rq",
"name": "组别",
"color": 0
}, {
"id": "optsjTJfqyk8Y",
"name": "机械1组",
"color": 1
}, {
"id": "optLywx601VRq",
"name": "机械2组",
"color": 2
}, {
"id": "optYK6mt6ItSD",
"name": "机械3组",
"color": 3
}, {
"id": "optpkPIqIpRja",
"name": "机械4组",
"color": 4
}, {
"id": "optTgpBavHdYx",
"name": "电控1组",
"color": 5
}, {
"id": "optmUReOc3gfD",
"name": "电控2组",
"color": 6
}, {
"id": "optk8RhB4eGYp",
"name": "项目组",
"color": 7
}, {
"id": "optOhWXvQBndR",
"name": "电控3组",
"color": 8
}]
}
},
"fldHhivb42f04": {
"id": "fldHhivb42f04",
"name": "待料工时",
"type": 2,
"property": {
"precision": 1,
"symbolAlign": 2
}
},
"fldM3ttjCjaiE": {
"id": "fldM3ttjCjaiE",
"name": "备注",
"type": 1,
"property": null
},
"fldODFwocO5mW": {
"id": "fldODFwocO5mW",
"name": "实到人数",
"type": 2,
"property": {
"precision": 0,
"symbolAlign": 2
}
},
"fldRj5LQWuHQ2": {
"id": "fldRj5LQWuHQ2",
"name": "其它工时",
"type": 16,
"property": {
"expression": "{fldgqxiaXLz2q}-{flda2hMpitMmm}",
"formatting": {
"symbol": "$",
"precision": 0,
"formatType": 2
},
"datasheetId": "dstfGWFSqBmjcnWMFZ"
}
},
"fldSLq8sGINsn": {
"id": "fldSLq8sGINsn",
"name": "装配工时利用率",
"type": 16,
"property": {
"expression": "if({fldgqxiaXLz2q}>0,ROUND({flda2hMpitMmm}/{fldgqxiaXLz2q}*100,1)&\"%\",\"\")",
"formatting": {
"symbol": "$",
"precision": 1,
"formatType": 18
},
"datasheetId": "dstfGWFSqBmjcnWMFZ"
}
},
"flda2hMpitMmm": {
"id": "flda2hMpitMmm",
"name": "装配工时",
"type": 16,
"property": {
"expression": "",
"datasheetId": "dstfGWFSqBmjcnWMFZ"
}
},
"fldacC6uiks4u": {
"id": "fldacC6uiks4u",
"name": "应到人数",
"type": 2,
"property": {
"precision": 0,
"symbolAlign": 2
}
},
"fldfnPGNBHVyc": {
"id": "fldfnPGNBHVyc",
"name": "其它事项工时",
"type": 16,
"property": {
"expression": "{fldRj5LQWuHQ2}-{fldHhivb42f04}",
"formatting": {
"symbol": "$",
"precision": 0,
"formatType": 2
},
"datasheetId": "dstfGWFSqBmjcnWMFZ"
}
},
"fldgqxiaXLz2q": {
"id": "fldgqxiaXLz2q",
"name": "出勤工时",
"type": 2,
"property": {
"precision": 1,
"symbolAlign": 2
}
},
"fldjKV2vPEKNs": {
"id": "fldjKV2vPEKNs",
"name": "时间",
"type": 5,
"property": {
"autoFill": false,
"dateFormat": 0,
"timeFormat": 1,
"includeTime": false
}
}
}
在以上中mysql表中一个字段的值,json类型,想实现如下的结果,语句要怎么写?
ID name
optsjTJfqyk8Y 机械1组
optLywx601VRq 机械2组
optYK6mt6ItSD 机械3组
optpkPIqIpRja 机械4组
optTgpBavHdYx 电控1组
optmUReOc3gfD 电控2组
optk8RhB4eGYp 项目组
optOhWXvQBndR 电控3组