ObjectBox Query with strings

Question

How it is possible to create a QUERY using GREATER option with strings? I see that this is possible only for numeric or data properties. I have data coming from an IBM legacy database where dates are saved in timestamp fornat "YYYY-MM-DD HH:MM:SS". So, to test if a date is less or greater of a given date I have to compare two strings.

Please show an example of the data that you want to query and the expected results. What have you tried so far? — Dave Meehan
– Dave Meehan, Commented Apr 15, 2018 at 9:21

Markus Junginger · Accepted Answer · 2018-04-16 12:23:45Z

0

We missed that one. I just opened a ticket for this so you can track this feature. We'll try to support this shortly.

PS.: For your use case, you could have a long timestamp or Date property additionally.

edited Apr 16, 2018 at 12:23

answered Apr 16, 2018 at 12:14

Markus Junginger

7,14533 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

maracuja-juice · Accepted Answer · 2018-10-27 23:05:47Z

0

With the new versions of Objectbox this is now possible.

Example with Dates:

// you should define the lowest possible date as string
String lowestDate = LocalDate.now().minusMonths(3).toString();

getMyAlbumBox().query().greater(ObjectToQuery_.date, lowestDate).build()

answered Oct 27, 2018 at 23:05

maracuja-juice

1,0622 gold badges16 silver badges35 bronze badges

Collectives™ on Stack Overflow

ObjectBox Query with strings

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related