Calculations and find mode

Classic Servoy
1

Hello,

I apparently couldn’t find an aswer to this (the only one dated back to 2008, so I thought I’d better ask again): can calculations be used when in find mode? I mean standard calculations, not stored ones. If not, what other way is there to perform a search on a foundset based on calculations?
I’m trying to implement a sample solution to use multiple selection (without relying on multiSelect mode) using checkboxes and I had weird behaviour with the find. However my original method used actual columns defined by modyfing the dataset of the foundset I was working on and then stored in a in-memory datasource (see viewtopic.php?f=8&t=17817).

Any idea is really appreciated, thanks.

2

Anyone?

3

Hi,

Up until this point Servoy uses plain SQL to do it’s finds so if the calculation is not stored it can’t be used in the search.
I believe they will add support for searching unstored calculations in 6.1 though.

Hope this helps.

4

What about foundset filters? Do they get translated to SQL too? Anyway I’ll take a look at the docs, sometimes you can actually find what you’re looking for, you know :P

Thanks in advance.