BUG: "Many" attribute in select - problems with encoding - MS SQL:
costCenterID
is a "Many" attribute (reference to org_unit):
It is in field list as: costCenterID.caption
.
In DB data is just fine, the dictionary / drop downs - all are fine, problematic is just the "Many" attribute.
Here is result:
[{
"entity":"pln_Project",
"fieldList":[
"docNumber","title","status","horizonBegin","horizonEnd","horizon","costCenterID.caption","categoryID.code",
"categoryID.name","subCategoryID.caption","currencyID","currencyID.name","sum","rfiDuration","auctionDuration",
"plannedProcedureID.code","plannedProcedureID.name","actualProcedureID.code","actualProcedureID.name",
"responsibleID.fullFIO","tenderCommitteeID.code","tenderCommitteeID.name","forecastStartDate","plannedStartDate",
"forecastPubDate","plannedPubDate","forecastOfferDate","plannedOfferDate","ID","mi_modifyDate"
],
"options":{"totalRequired":true,"limit":100,"start":0},
"orderList":{"x100":{"expression":"horizonBegin","order":"asc","isExternal":true}},
"method":"select",
"__totalRecCount":1,
"resultData":{
"fields":["docNumber","title","status","horizonBegin","horizonEnd","horizon","costCenterID.caption","categoryID.code","categoryID.name","subCategoryID.caption","currencyID","currencyID.name","sum","rfiDuration","auctionDuration","plannedProcedureID.code","plannedProcedureID.name","actualProcedureID.code","actualProcedureID.name","responsibleID.fullFIO","tenderCommitteeID.code","tenderCommitteeID.name","forecastStartDate","plannedStartDate","forecastPubDate","plannedPubDate","forecastOfferDate","plannedOfferDate","ID","mi_modifyDate"],"rowCount": 1,
"data":[
["000000000009","980","draft",216,227,11,"010000 - ??????????? 1,030000 - ??????????? 3,040000 - ??????????? 4,060000 - ??????????? 6,090000 - ??????????? 9","10000000","Live Plant and Animal Material and Accessories and Supplies","10100000 - Live animals,10110000 - Domestic pet produc,10120000 - Animal feed,10130000 - Animal containment ,10170000 - Fertilizers and pla,10190000 - Pest control produc",3000000001513,"Долар США",null,null,null,null,null,null,null,"Матвеева Зоя Богдановна",null,null,null,null,null,null,null,null,3000000070812,"2018-08-30T07:27:23Z"]
]}}]
Edited by Andrii Bezuglyi