DataRow attributes are omitted when the row is converted to JSON

[hyyan]

DataRow attributes should be part of the row when it is converted to JSON

The following programme shows how the row attributes are missings

My suggestion :

1. Add attrs object to the final JSON (recommended)
2. Copy the row attributes to each field

Programm:

    declare SqlQueryBC sbc!
    sbc! = new SqlQueryBC(BBjAPI().getJDBCConnection("CDStore"))
    rs! = sbc!.retrieve("SELECT  * FROM CDINVENTORY")

    rs!.get(0).setAttribute("BGCOLOR","Black")
   
   print rs!.get(0).toJson()

Output:

[
   {
      "CDNUMBER":"000001",
      "TITLE":"\u003Cb\u003EMississippi Blues\u003C/b\u003E",
      "ARTIST":"John Hurt \u0026 The Ramblers",
      "LABEL":"Blind Pig",
      "PLAYINGTIME":"72",
      "RECORDINGTYPE":"AAD",
      "MUSICTYPE":"Blues",
      "BINLOCATION":"N123",
      "NUMBEROFTRACKS":12,
      "ONHAND":55,
      "COST":5.99,
      "RETAIL":12.99,
      "meta":{
         "CDNUMBER":{
            "ColumnType":"12",
            "EDITABLE":"1"
         },
         "TITLE":{
            "ColumnType":"12",
            "EDITABLE":"1"
         },
         "ARTIST":{
            "ColumnType":"12",
            "EDITABLE":"1"
         },
         "LABEL":{
            "ColumnType":"12",
            "EDITABLE":"1"
         },
         "PLAYINGTIME":{
            "ColumnType":"12",
            "EDITABLE":"1"
         },
         "RECORDINGTYPE":{
            "ColumnType":"12",
            "EDITABLE":"1"
         },
         "MUSICTYPE":{
            "ColumnType":"12",
            "EDITABLE":"1"
         },
         "BINLOCATION":{
            "ColumnType":"12",
            "EDITABLE":"1"
         },
         "NUMBEROFTRACKS":{
            "ColumnType":"2",
            "EDITABLE":"1"
         },
         "ONHAND":{
            "ColumnType":"2",
            "EDITABLE":"1"
         },
         "COST":{
            "ColumnType":"2",
            "EDITABLE":"1"
         },
         "RETAIL":{
            "ColumnType":"2",
            "EDITABLE":"1"
         }
      }
   }
]

[StephanWald]

both 1. and 2., or either/or?

[hyyan]

@StephanWald either, first one recommended