Unable to search with new fields created in the grid

Scriptcase 9 General
#1

Good morning :),
As usual hope you can help me with an issue…

I have a grid that must start as search… everything working OK except:
In my grid I have created three fields to calculate some values based in some fields from my database…
I need to use those 3 fields in the search, but I can’t because they are empty when I do the search… Hope this make sense…

In the event OnRecord I have:
{total1} = {totalSent} / {totalBase} * 100;

How can I use total1 in my search?
I can see it there but using the debug mode this field is not in the query…

Appreciate your help.

Regards,
Janneth

#2

The search is generating a valid sql statement to lookup data in the database. In this case you have a value which is read on every record. That is after the search and these values are not part of the database structure. That’s why you can’t search on them. Of course you can do calculations in sql and depend your select on that. But you need to make your own searchscreen for that, as it cannot be generated as a part of the standard sc search afaik.

#3

Thank you Albert :slight_smile:
I’ll create one on my own!!