Hi Friend,
Can any body help me to figure out how I can achieve search functionality. Actually I wanted to do a search for documents from a view in which Field Owner has some value and Technician field is either Blank or its contains value “Select” or some name of the technician.
I have constructed a query like:
query= (FIELD Owner=“Greg Jepsen” AND FIELD Tech=“Erica Hsiung”)
Now I wanted to list all document in which Tech contains “Erica Hsiung” or its has blank value.
when i used:
query= (FIELD Owner=“Greg Jepsen” AND FIELD Tech=“”)
It return 0 documents. But I am sure there are some documents in my database which has owner is Greg and Tech field has nothing.
I will be very thankful to you for your kind response.
With Regards,
Vikas K Sinha