Happy Business Starts Here

How to change the data type of a value fetched in DataQuery

Goutham
Zuora Support

How to change the data type of a value fetched in DataQuery

Problem: Customer wants to SET and Declare a variable in the DataQuery or change the datatype of an existing field retrieved from the DataQuery

 

Solution: SET and Declare function is not supported in the DataQuery, but the CAST function is supported.

For example, "Select cast( Id as varchar) from Invoice"

The above query will convert the value of the field “Id” into varchar datatype.

1 REPLY 1
sayam
Valued Scholar

Re: How to change the data type of a value fetched in DataQuery

Thanks Goutham,

 

I had this issue. was looking forward to this solution.