retrieve index expression information

Post Reply
Priti Barapatre
Posts: 22
Joined: Fri Oct 19, 2007 10:11 am

retrieve index expression information

Post by Priti Barapatre »

Hi John,

How can I come to know what are the index expressions used on a texis table.

Regards
Haamid
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

retrieve index expression information

Post by John »

The index expressions are associated with a specific index, and different indexes on the same table could have different index expressions. You can run the Unix strings command on the INDEXNAME_P.tbl file to get an idea of the parameters used for that index.
John Turnbull
Thunderstone Software
Priti Barapatre
Posts: 22
Joined: Fri Oct 19, 2007 10:11 am

retrieve index expression information

Post by Priti Barapatre »

Hi John,

Thanks for the prompt response. actually the problem which I was facing that is one of the tables i am not able to retieve any results if the user is using special character like "_" or "." in their search query so I was trying to look into the index expression. this what it looks like:

-bash-3.00$ tail -f xfiles_files1_10_0_P.tbl
ó88ÿÝ8PBParamTValueò¹¹Index Expression@¦|\alnum{1,30}\digit=[\digit\.+]{1,30}[\alnum\x80-\xff]{1,30}>>\alnum=[\alnum+\x5C\x5F\x2D\x26\x23\x40\x2E\x25\x2C\X20]{1,99}\alnum=\x2C\X20{1,30}òocale,CóÃÃ

I tried to look into the other table in which special characters are working that has the same index expression. Can you please let us know what can be the possible cause for this behaviour.

Thanks and Regards
Haamid
Priti Barapatre
Posts: 22
Joined: Fri Oct 19, 2007 10:11 am

retrieve index expression information

Post by Priti Barapatre »

Hi John,

upon looking into the search behaviour here is what i have noticed

if the file name is "installation_of_jre_1.5.ppt" and i put same thing in query it does return the result. but

if the file name contains special character and also has white spaces in between then it does not return result e.g
if filename is "cdhc portal.xls" and I use the same as query word then it does not give back the result.

what can be the cause. Can you please help
Regards
Haamid
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

retrieve index expression information

Post by mark »

Can't tell from that where one expression starts and the next one starts. Please provide the full SQL of your index create statements and search queries.

Also check for warnings or errors in the source of the search results page and/or vortex.log.
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

retrieve index expression information

Post by John »

The index expressions will index the filename as a whole, including the punctuation, and the non-punctuated pieces, so the query should either be exact, or contain no punctuation. E.g.

cdhc portal xls

or

cdhc_portal.xls
John Turnbull
Thunderstone Software
Priti Barapatre
Posts: 22
Joined: Fri Oct 19, 2007 10:11 am

retrieve index expression information

Post by Priti Barapatre »

Hi John,
Let me rephrase my question:

the filename is "cdhc portal.xls"
Scenario 1
if the search query is "cdhc portal xls" results is returened.

Scenario 2

if the search query is "cdhc portal.xls" no results returned.

I am not able to understand why its is behaving in this manner.

Regards
Haamid
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

retrieve index expression information

Post by mark »

Please provide the full SQL of your index create statements and search queries.

Also check for warnings or errors in the source of the search results page and/or vortex.log.
Priti Barapatre
Posts: 22
Joined: Fri Oct 19, 2007 10:11 am

retrieve index expression information

Post by Priti Barapatre »

Hi John/mark,

these are the index expression:
<sql novars "set delexp=0;"></sql>
<sql novars "set indexmem=20"></sql>
<sql novars "set locale='C';"></sql>
<sql novars "set addexp='[\alnum\x80-\xff{1,30}';"></sql>
<sql novars "set addexp='\digit=[\digit\.,+]{1,30}';"></sql>
<sql novars "set addexp='>>[\xc0-\xfd]=[\x80-\xbf]+';"></sql>
<sql novars "set addexp='>>\alnum=[\alnum\x5c\x5f\x2d\x26\x23\x40\x2e\x25\x2c]{1,30}';"></sql>
<sql novars "set indexmeter=2"></sql>
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

retrieve index expression information

Post by mark »

I don't see any problem with those settings.
What's the index create SQL?
What's the query SQL?
What's the output of "texis -version"?
Do you get any warning or error messages in html comments on the search results page? Or in vortex.log?
Post Reply