11.7.3
I have this Array by doing this:
{&out-long} oJSData:GetJsonArray('data'):GetJsonText().
How to hek do I get this without the [] in front and after? I have tried so many things, but not found the correct, and before I start removing, I just have to ask. The worst is that I have made it myself ...
help….
[{"current":1},{"total":"1119"},{"rowCount":"1119"},{"rows":[{"CustNum":2097,"Name":"Bonnie's Sports & Trophy Supl","RowIdent1":"0x00000000000004b4","RowCount":10,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2098,"Name":"John's Custom Archery Pro Shop","RowIdent1":"0x00000000000004b5","RowCount":9,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2099,"Name":"Arctic Gunworks","RowIdent1":"0x00000000000004b6","RowCount":8,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2100,"Name":"Western Auto","RowIdent1":"0x00000000000004b7","RowCount":7,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2101,"Name":"Bob's Guns & Sporting Goods","RowIdent1":"0x00000000000004b8","RowCount":6,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2102,"Name":"Lighthouse Grocery & Liquor","RowIdent1":"0x00000000000004b9","RowCount":5,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2103,"Name":"Alaska Fisheries","RowIdent1":"0x00000000000004ba","RowCount":4,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2104,"Name":"Alaska Par T Golf Pro Shop","RowIdent1":"0x00000000000004bb","RowCount":3,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2105,"Name":"All Weather wear","RowIdent1":"0x00000000000004bc","RowCount":2,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2106,"Name":"Apocalypse Design Inc","RowIdent1":"0x00000000000004bd","RowCount":1,"jbCountDistinct":1,"jbAverage":0.0}]}]
Sorry, suddenly I see that I have made a mess out of this :.-) too many objects….
Sorry, suddenly I see that I have made a mess out of this :.-) too many objects….
|
Got it
{"current":1,"total":"1119","rowCount":"1119","rows":[{"CustNum":2097,"Name":"Bonnie's Sports & Trophy Supl","RowIdent1":"0x00000000000004b4","RowCount":10,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2098,"Name":"John's Custom Archery Pro Shop","RowIdent1":"0x00000000000004b5","RowCount":9,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2099,"Name":"Arctic Gunworks","RowIdent1":"0x00000000000004b6","RowCount":8,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2100,"Name":"Western Auto","RowIdent1":"0x00000000000004b7","RowCount":7,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2101,"Name":"Bob's Guns & Sporting Goods","RowIdent1":"0x00000000000004b8","RowCount":6,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2102,"Name":"Lighthouse Grocery & Liquor","RowIdent1":"0x00000000000004b9","RowCount":5,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2103,"Name":"Alaska Fisheries","RowIdent1":"0x00000000000004ba","RowCount":4,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2104,"Name":"Alaska Par T Golf Pro Shop","RowIdent1":"0x00000000000004bb","RowCount":3,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2105,"Name":"All Weather wear","RowIdent1":"0x00000000000004bc","RowCount":2,"jbCountDistinct":1,"jbAverage":0.0},{"CustNum":2106,"Name":"Apocalypse Design Inc","RowIdent1":"0x00000000000004bd","RowCount":1,"jbCountDistinct":1,"jbAverage":0.0}]}
Hi,
You write that you created the array yourself. Why not create an object? And place all rows inside, the object?
I got it :-) I had created objects instead of properties :-) I saw it when posting this :-)
Update from Progress Community
onnodehaan Hi,
You write that you created the array yourself. Why not create an object? And place all rows inside, the object?
You received this notification because you subscribed to the forum. To unsubscribe from only this thread, go here.
Flag this post as spam/abuse.