find mode with calculation fields

Classic Servoy
1

Hi,

I have a calculation field for a form that basically does the following:
if(x == 1)
return ‘complete’;
else
return ‘incomplete’;

when i go in find mode for the form to search on that calculation field it shows me all the records instead of showing the exact records that are incomplete or complete.

Can we do find mode on calculation fields or am I missing something?

Any help would be appreciated

Regards
jdcunha

2

Hi,

I forgot to mention that i am using Servoy 3.5.6

Regards
jdcunha

3

Hi jdcunha,

When Servoy does a search it simply fires a SQL query to the back-end database. This means it will only be able to search on stored data so when your calculation is not stored you can’t search on it.
So you have 2 options:

  1. create a new column in the table with the same name as the calc so it stores the calculated data.
  2. apply the logic of your calc in your search (if possible).

Hope this helps.

4

Thanks Robert.

Appreciate your help

Regards
James