Search across virtual columns.

[Texis User]

I have created a index as below.
create metamorph inverted index xpprofile on person_profile (email,business_name,function_name,expert_brief_desc,dialcomm,other_info);

When I try to search across these columns, it gives me No Records Found and $indexCount is 0.

But when the same query is run at the command prompt it displays data.

Earlier my query was

select person_id, initcap(last_name) last_name, initcap(first_name) first_name,initcap(preferred_name) preferred_name,email, ohr_id, business_name, expert_brief_desc,dialcomm, folders_flag from person_profile where email\business_name\function_name\other_info likep 'New* Jersey*' order by initcap(last_name), initcap(first_name) asc

I changed this thinking the order by was taking time and hence the No Record message.

But still I see the same message comming up.

I have changed the timeout to -1, still see no difference.

Any clues?

[John]

create metamorph inverted index xpprofile on person_profile (email\business_name\function_name\other_info);

The virtual field in the create index should match the virtual field in the where clause.

[Texis User]

Sorry I pasted wrong create statment, it is
create metamorph inverted index xpprofile on person_profile (email,business_name,other_info);


And its giving me No Records Found.

[John]

As mentioned the virtual field in the create metamorph index statement must match the one being used in the query. If you have:

where email\business_name\function_name\other_info likep ...

you should use:

create metamorph inverted index xpprofile on person_profile (email\business_name\function_name\other_info);

otherwise you are creating and index on different fields so they won't be used.

[John]

The following page may be useful:

http://www.thunderstone.com/texis/site/ ... pound.html

[Texis User]

Thanks John!!