Hey everyone-
We have several types of tickets and people want to be able to search across
all of them. All ticket types push key information to the AllTickets form-
Status, Submitter, Summary, Date Created, and so on (not sure how much of
this was out of the box).
I'm trying to make a form which can be an 'Advanced Search' type of form.
I've made character or date fields to input the parameters and have a table
linked to All Tickets to display the results. My thinking was that the
criteria could be set in a hidden field called Search Criteria, then the
table has the qualification EXTRNAL($Search Criteria$), but I'm not able to
figure a good way to get multiple criteria in there. For example, if I
simply set the hidden field to something like this (LIST fields are on the
AllTickets form):
'LISTSummary' LIKE (("%" + $Summary$) +"%") AND 'LISTSubmitter' LIKE (("%" +
$Summary$) +"%")...
and so on, it won't run if fields any listed fields are null.
Am I going about this all the wrong way? Any ideas on how to do this best?
Thanks,
Chris
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
