Hi,

Back end is Oracle.

Here is an ex:
Assume that my view has 3 fields, id(numeric),city, hire_date(date data type)

Some times I want to retieve data just by city. Then I give city value and dont bother about other two parameters(id and hire_date). I dont want id and hire_date fields to be null or blanks.

How can I set my id and hire_date params ??

Thanks

>>Hi,
>>
>>I have a remote view with numeric, date and char parameters.
>>If I want to retrieve my view based on blank numeric or date fields, how can I do that? I am able to do for char params, for ex., city like 'PARIS%'.
>>
>>Please advise me how to do for numeric and dates
>>
>>Thanks
>
>This is just a shot in the dark but have your tried to query for .null.?
>
>What is the bakend that you are using?