This content has been marked as final. Show 3 replies
Perhaps a closer inspection of the docs might help:
You can specify a QUERY attribute, and when doing so the BODY attribute is
a list of the columns in said query to index.
Thank Adam, but what the BODY attribute does is lumps all those fields into one field, "summary". This doesn't fit with what I'm trying to do. Here's an example.
table structure (scaled down of course)
ID, fname, lastname, email, manager_fname, manager_lname, dept.
I would like to index all of those items, so that when someone types in the search box (google-style), "John", I get all the rows that contain "*john*" within the index.
a sample return would be:
ID fname lname email manager_fname manager_lname dept
3 john jones jjones fred hicks marketing
4 jack smith jsmith john jones sales
> I would like to index all of those items, so that when someone types in the
> search box (google-style), "John", I get all the rows that contain "*john*"
> within the index.
> a sample return would be:
> ID fname lname email manager_fname manager_lname dept
> 3 john jones jjones fred
> hicks marketing
> 4 jack smith jsmith john
> jones sales
OK, just because that's what Verity returns as its default summary doesn't
mean you have to use that in your display. It also returns the key of the
record, which you can then use to do a select query from the DB to return
But to be honest, I'd not use Verity for this sort of thing. I'd just use
a DB query in the first place, or hasve a look at what the full-text
searching capabilities of your DB offers.