Search across virtual columns.

Post Reply
Texis User
Posts: 74
Joined: Thu Jul 13, 2006 8:47 am

Search across virtual columns.

Post by 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?
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Search across virtual columns.

Post by 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.
John Turnbull
Thunderstone Software
Texis User
Posts: 74
Joined: Thu Jul 13, 2006 8:47 am

Search across virtual columns.

Post by 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.
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Search across virtual columns.

Post by 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 Turnbull
Thunderstone Software
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Search across virtual columns.

Post by John »

John Turnbull
Thunderstone Software
Texis User
Posts: 74
Joined: Thu Jul 13, 2006 8:47 am

Search across virtual columns.

Post by Texis User »

Thanks John!!
Post Reply