Get the lastest number from string attribute

[bronze zealot]

I have client table whcih contains code, was initially interger field, but since it doesn't support full searching. I need to change to string and store it.

But when I try to get the last order number. it doesn't return the correct biggest number. any possible solution or workaround for this

const promise: any = await db.clients.list([
    Query.orderDesc("code"),
    Query.limit(1),
  ])

[tame zealot]

Why do you need to search it?

[tame zealot]

If it's a string, it will be sorted like a string. So 2 is bigger than 11.

[bronze zealot]

I have a requirement to search by Id ,

[bronze zealot]

Correct, so now I need to revert back to integer.

[cold dove]

Or have a duplicate attribute, one with string and the other one with integer

[tame zealot]

i would use padded strings.

00000001
00000002
10000000

would all sort properly

[bronze zealot]

my attemption now is to havea ability to search startWith. because I have requirements to find all document's code start with something, interger cannot be search like that. and string cannot be use to generate the incremental number. I have heard auto increment coming in 1.7 . is this still valid

[bronze zealot]

what is that for sir,

[tame zealot]

So that order is retained

[tame zealot]

I don't think starts with works on integers does it?

[bronze zealot]

workaround but not neatly.

[bronze zealot]

totally agree, first though, get all then manipulating in server side, but not preferable.

now, revert back to integer and only support equal search for integer, must be exact!

[tame zealot]

Sure if you only need equal then that's fine