Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved ExportJson and Boolean Values

  1. How-to
0
Votes
Undo
  1. Andres Slachevsky
    Andres Slachevsky
  2. PowerBuilder
  3. Wednesday, 18 November 2020 12:57 PM UTC

Hello All,

We need to export a Dw a a Json 

the issue is that the required JSON have a Booelan value.

for example

{ "sale":true }

but the DW does not have a Boolean Column 

so it export like

 

{ "sale":'true' }

 

any solution other than generate the json with the JSONGenerator

 

App Crash with MultiThread
Download PowerBuilder 6.5 for Migration
Responses (1)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 18 November 2020 16:31 PM UTC
  2. PowerBuilder
  3. # 1

Hi Andres;

  Yes, the DWO does not support the Boolean DBMS column type. Yet, many DBMS (ie: SQL Server, ASE, Oracle, etc) do have that data type. So its basically a chicken and egg syndrome. That is ... the DWO needs to support Boolean column types for both DBMS and JSON reasons (XML as well).

   Unfortunately, the only workaround is to either ...

  1. Use the JSONGenerator object class at this time to get that data type value set properly.
  2. Parse the exported JSON file and then correct the "Should be Boolean" output.

Regards ... Chris

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.