I need to make json string formate suitable to select statement as following :
select FooterTable.LineNumber,FooterTable.ItemCode,FooterTable.Quantity,FooterTable.UniPrice,FooterTable.Total from
MasterTable inner join FooterTable on MasterTable.Serial=FooterTable.Serial,MasterTable.BranchCode=FooterTable.BranchCode,MasterTable.Year=FooterTable.Year
where MasterTable.Serial=10 AND MasterTable.Year=2019 AND MasterTable.BranchCode=1
No need for code by any language
only string fomate like that
{
xxxx
}
MasterTable
Serial pk
Year pk
BranchCode pk
FooterTable
Serial pk
Year pk
BranchCode pk
LineNumber
ItemCode
Quantity
UniPrice
Total
How to generate json string as following
Fields : LineNumber,ItemCode,Quantity,UniPrice,Total specified all fields from
FooterTable no fields from MasterTable .
Keys : Serial:10,Year:2019,BranchCode:1 from MasterTable .
Tables:MasterTable,FooterTable .
so that how to generate json format string to my requirement above
What I have tried:
{
"Details" : {
"table" : "master_table",
"fields" : {
"itemCode" : "item-5050",
"Quantity" : "10" ,
"Price" : "50" ,
"Total" : "500"
},
"keys": {
"BranchCode" : 1 ,
"Year" : 2019 ,
"Serial" : 2
}
}
}