You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
luckysheet-mysql\src\main\java\com\xc\luckysheet\mysql\impl\RecordSelectHandle.java
public JSONObject getCelldataByGridKey(String listId, String index, String blockId) {
............
String sql="select index,json_data->>'$.celldata' AS celldata,json_data->>'$.column' AS column,json_data->>'$.row' AS row from "+JfGridConfigModel.TABLENAME+" p where p.list_id=? and p.index=? and p.block_id=? and p.is_delete=0 ORDER BY p.id DESC LIMIT 1 ";
Map<String, Object> map= luckySheetJdbcTemplate.queryForMap(sql, new Object[]{listId,index,blockId});
............
}
DataTable sheet [docssheet ] fields:id,block_id,row_col,index,list_id,status,order,json_data,is_delete
json_data : {"celldata": [{"c": 6, "r": 30, "v": {"m": "l", "v": "l", "ct": {"t": "g", "fa": "General"}}}]}
Mysql:
select id,index,json_data->>'$.celldata' AS celldata,json_data->>'$.column' AS column,json_data->>'$.row' AS row from docssheet p where p.list_id='45794d3ceb1f0054a2b6d47b0ac82212' and p.index='Sheet_6aokgc2qSWWH20210505161959' and p.block_id='30_6' and p.is_delete=0 ORDER BY p.id DESC LIMIT 1 ;
Query Result:
id :183152282723028992
index :Sheet_6aokgc2qSWWH20210505161959
celldata:[{"c": 6, "r": 30, "v": {"m": "l", "v": "l", "ct": {"t": "g", "fa": "General"}}}]
column: (NULL)
row : (NULL)
Map<String, Object> map= luckySheetJdbcTemplate.queryForMap(sql, new Object[]{listId,index,blockId});
ERROR Incorrect result size: expected 1, actual 0
problem 1: json_data->>'$.column' Or json_data->>'$.c' ?
problem 2: record count 1; but warning ERROR Incorrect result size: expected 1, actual 0 ?
The text was updated successfully, but these errors were encountered:
luckysheet-mysql\src\main\java\com\xc\luckysheet\mysql\impl\RecordSelectHandle.java
public JSONObject getCelldataByGridKey(String listId, String index, String blockId) {
............
String sql="select
index
,json_data->>'$.celldata' AS celldata,json_data->>'$.column' AScolumn
,json_data->>'$.row' ASrow
from "+JfGridConfigModel.TABLENAME+" p where p.list_id=? and p.index=? and p.block_id=? and p.is_delete=0 ORDER BY p.id DESC LIMIT 1 ";Map<String, Object> map= luckySheetJdbcTemplate.queryForMap(sql, new Object[]{listId,index,blockId});
............
}
DataTable sheet [docssheet ] fields:id,block_id,row_col,index,list_id,status,order,json_data,is_delete
json_data : {"celldata": [{"c": 6, "r": 30, "v": {"m": "l", "v": "l", "ct": {"t": "g", "fa": "General"}}}]}
Mysql:
select id,
index
,json_data->>'$.celldata' AS celldata,json_data->>'$.column' AScolumn
,json_data->>'$.row' ASrow
from docssheet p where p.list_id='45794d3ceb1f0054a2b6d47b0ac82212' and p.index='Sheet_6aokgc2qSWWH20210505161959' and p.block_id='30_6' and p.is_delete=0 ORDER BY p.id DESC LIMIT 1 ;Query Result:
id :183152282723028992
index :Sheet_6aokgc2qSWWH20210505161959
celldata:[{"c": 6, "r": 30, "v": {"m": "l", "v": "l", "ct": {"t": "g", "fa": "General"}}}]
column: (NULL)
row : (NULL)
Map<String, Object> map= luckySheetJdbcTemplate.queryForMap(sql, new Object[]{listId,index,blockId});
ERROR Incorrect result size: expected 1, actual 0
problem 1: json_data->>'$.column' Or json_data->>'$.c' ?
problem 2: record count 1; but warning ERROR Incorrect result size: expected 1, actual 0 ?
The text was updated successfully, but these errors were encountered: