What's new in Customer Journeys?

Connect and learn more! ×
Convert Text field into Integer Type in ROQL — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Convert Text field into Integer Type in ROQL

Question
42
Views
0
Comments
edited Jun 8, 2022 12:10PM in General Technical Discussions

Summary

Type casting Text field column into Integer type using ROQL Query

Content

Hi,

We have business requirement to convert Text data type field value into Integer type value using ROQL. For example 

Field Name        Data Type          Value              Need to Convert

field_a                   Text                 $65.00              65

I need to convert $65.00 value (field_a) using ROQL. I know CAST() in SQL but it did not work in ROQL.

Select ID, CAST(field_a AS Int) From Custom Object

Anyone has an idea how to convert text data type to Integer using ROQL

Thanks!!

Baljeet

 

Version

Oracle Service Cloud 20 C

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!