How can I query numeric data of type String by condition?

4 replies
1233 views
Translate All

Dears

As shown, if the field is set to a number of type String, how can I query the data according to the condition?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

N

Nikita___GargAccepted solution

Adobe Employee

Hi @chaoxiong ,

You can try using groovy script which can read the value from String property and save in long property. This will help you manipulate the content and query the field with numeric operations.

Thanks,

Nikita Garg

krati_garg

Adobe Employee

@chaoxiong

If the Field is String Type, you cannot expect numeral comparison as an output for logical operators. In the end, it is being compared as a String and not a numeral.

I would suggest changing the Data Type of this "number" property to Long instead of String.

Translate

ChaoXiongAuthor

Level 2

Thanks @krati_garg

Because this is an example, there is already a lot of data in the actual project that is of String type, so I hope that there are related methods to query instead of modifying its type.

Translate

N

Nikita___Garg

Accepted solution

Adobe Employee

Hi @chaoxiong ,

You can try using groovy script which can read the value from String property and save in long property. This will help you manipulate the content and query the field with numeric operations.

Thanks,

Nikita Garg

Translate