我想把横坐标换成这个id,但是我数据库里面没有这个ID的属性
这个时候,我们要使用过滤器,展示我们需要的数据
sql语句
SELECT guolianTradeVolume,tongdaxinTradeVolume,changchengTradeVolume,guotaijunanTradeVolume,yinheTradeVolume,tonghuashunTradeVolume
from tradecount
where id = '股票'
过滤器
return data.flatMap((item, index) => ([{
"x": "国联证券",
"y": item.guolianTradeVolume.toString()
},
{
"x": "通达信",
"y": item.tongdaxinTradeVolume.toString()
},
{
"x": "长城证券",
"y": item.changchengTradeVolume.toString()
},
{
"x": "国泰君安证券",
"y": item.guotaijunanTradeVolume.toString()
},
{
"x": "银河证券",
"y": item.yinheTradeVolume.toString()
},
{
"x": "同花顺",
"y": item.tonghuashunTradeVolume.toString()
}
]))