custom search field in grid?

Applications Grid / Reports
#1

I have a custom search field defined in the grid, but is has no effect on the search results. Referring to this custom field in the WHERE clause using {} has no effect either.

How can I make this work?

#2

Re: custom search field in grid?

Custom meaning you created your own control? Did you not want to use the one built into SC?

I am trying to guess how you have this implemented, so I guess how are making the call would be helpful.

Does this help:
http://www.scriptcase.net/forum_en_us/index.php?topic=1483.0

Regards,
Scott.

#3

Re: custom search field in grid?

  1. Add custom field (custom_field)
  2. goto grid onScriptInit event:

if (empty({sc_where_current}))
{
sc_select_where(add) = “where db_field =’{custom_field}’”;
}
else
{
sc_select_where(add) = “AND db_field =’{custom_field}’”;
}