Creating Search Queries that Prompt User

[jthillmn]

I need to create a series of searches that, when run, would prompt the user for the appropriate search criteria.

I have seen samples of SQL queries that include references to <Search Term>, expecting that when the query is run it would prompt the user for the value(s) to be provided for the <Search Term> strings.  That doesn't happen.

Is <Search Term> little more than a placeholder for someone to go in and physically replace that text with the search value they are looking for, or is there some nicer way of providing changing search parameters to a query; either for those using Search Builder or SQL?

Thanks...Jim

[qwerty]

<Search Term> is replaced by what the user supplies in the Search field when you enter Ctrl-F.

q.

[jthillmn]

Thanks!

[Grahame]

Does anyone know if you can do something similar with RTF reports?

I have a report that calls a number of template Fragments, which each contain SQL queries. Ideally I'd like to be able to pass a parameter from the main report into the fragments, to use in the WHERE clause of my SQL query. Is this possible within EA?