Searching for unchecked checkboxes

Classic Servoy
1

Hello. I’m just moving over from filemaker (that seems to be the usual path here) and have run up against a problem. How can I search for records where a particular check box is NOT checked. In FM, you can do it with the omit button (i.e. a NOT search) but how to do this in Servoy where, as far as I can tell, you can only do AND and OR searches. I suppose I could make a button and a method to do this, but I’d rather not if there’s a better solution

While I’m at it, can I search for records where a particular (non-editable) combo box is empty?

Thanks all in advance and thanks for a great product.

2

any luck on this? I’m trying to solve the same situation

3

Are you trying to examine the dataprovider contents (which references a field in a table) or the contents of the element on the layout (which could be a label showing a global variable rather than a database table field)?

4

What i’d need to do is to find records where a particular option on a radiobutton list is not checked.

Example: I’ve got a client record with a “language” field. This field is a list with “Spanish, English, French, etc” values.

I’d like to search for clients not speaking Spanish (it doesn’t make sense, I know, but I think it works as an example)

How can I do this?? (I now I can duplicate search, selecting all the options but “Spanish”, but this is not what I’m looking for)

Thanks!

5

Hi janteque,
If you check English and French options then it returns only these two options value.
Then you take the result in an array by spliting “\n” and apply your search.
I think it will work for you. 8)

6

I don’t know if janteque succeeded to get it work, I did’nt.
Can anyone supply the code plse.
Above example works with comboboxes, suppose I use radiobuttons or just a plain field and I want to find all records where language is NOT Spanish, so even the records where language is NULL. ShowOmittedRecords does’nt seem te work.
How do I find these records?

7

Thanks subhranild, but I’m not sure that is what I’m looking for.

What I’d like to replicate is the “omit record in search” functionality from Filemaker. I know, I know, Servoy is not FM and will never be (in fact each time is more and more different), but without this functionality, the powerful search engine lacks an important feature to be perfect.