Discussion:
help with ixsso using regx query
(too old to reply)
BrenB
2008-03-27 17:50:09 UTC
Permalink
Raw Message
I need help forming a query.

Although I'm more comfortable with SQL type queries, my server is not
setup to use the OLEDB provider, so, I'm using the ixsso object
instead.

The Index Server property that I'm querying is Filename.

Embedded within all the Filenames is an Invoice Number and a Project
Number. The Filename has a pattern something like this:

PPPPPP_GG_DDDDDDDD_IIIIIIII.pdf
Where P = Project Number, G = Invoice Group, D = Date, and I = Invoice
Number

This query below works, and it returns all PDF documents in the Index
Server catalog for a given project number:

#Filename = 123456*.pdf

I tried adding a phrase for the invoice number, but this query didn't
work.

#Filename = 123456*.pdf and #Filename = *23232323*

Thank you for your help.

Bren
BrenB
2008-03-27 19:19:29 UTC
Permalink
Raw Message
Never mind.

Upon further testing, I've discovered that both my queries work.

Sorry for the interruption.

Thanks, Bren

Loading...