How can I customize my view's code in the remote view builder, I am making a find form before accessing the form where I will add, edit, print estc
for example
my table has a pk thas is number, the find form initialize it with 0, but if
i need to have another search param like a name
the sql of the view should be
select * from mytable where pk=0 and name like FindName and this will never
work if i just want to search by name since my pk never are 0
what if I want to search by several parameters but not all in the find form, for example I just enter values for the findName and findZip and he query to be build by those 2 params.
Is this form as dynamic as it should be as the case of an native oracle form
where i can just type in the textbox what i want and oracle will make the
adequate query, leaving out of the query the fields not filled.

How I make myself clear ... Also, is any way possible to edit the sql query
of the view ?

For example I will like to do the following
select * from mytable where (pk=?FindPK or FindPK=0) and nombre like
?FindName in order to search by one or the other parameter

Thank you

Norman Avila