How to make and /or search

Applications Grid / Reports
#1

Hi,
I am new scriptcase user. How I can make search in grid or form, what uses and and or.
If I have in search four fields.

Field 1 --> listbox form different table (must choose)
Field 2 --> listbox form different table dependency with Fied 1 (must choose)
Field 3 --> contains part of wanted word or number ( can be empty “shows all what is choosed in Fiels 1 and Fiel 2”)
Field 4 --> contains part of wanted word or number ( can be empty “shows all what is choosed in Fiels 1 and Fiel 2”)

if some one could help

#2

Re: How to make and /or search

HI,
SC Grid takes one SQL and the search is only based on that
I don’t think it is possible…!

regards
Dhana

#3

Re: How to make and /or search

Is it possible with form or must i take blank application and start building manually.

#4

Re: How to make and /or search

Hi,
It is based on the useage, the gird provides search options where you can filter based on conditions in the availble sql.

The Form has single record and Editable grid view options, where you can’t use search becuase it is used for entry mode.
When you want to search the records in the editable grid view, you have to use Browser search

Regards
Dhana

#5

Re: How to make and /or search

grid is for display only, we don’t add or edit anythin only display.

#6

Re: How to make and /or search

Hello Sir,

If I understood what you can do is create an application Search and link with a form.