Profile search syntax question

sleclerc

I am trying to perform a document search using the ImanProfileSearchParameter object, and I am looking for all values in a field that are not null. This is easy for String profile fields ("*") and Boolean profile fields ("Y"), but I can't figure out how to define the search criteria for Long and Date fields.

Is there a way I can define the search criteria for Date fields to be something like ">= 1901-01-01"? (I know all of my data values will always be greater than or equal to that date value).

What can I do for Double profile fields? Something like ">= 1.0" would work but I can't define something like that or using wildcards either. I'm told the search criteria is not valid.

Any help would be appreciated. Thanks.

sleclerc

Interwoven Dev Support responded with a solution that I improved upon and wanted to share with everyone else. For numeric lookup values they can be defined as:

String.Format("{0} - {1}", Integer.MinValue.ToString(), Integer.MaxValue.ToString())

For Date values is am using:

String.Format("{0} - {1}", Date.MinValue.ToString(), Date.MaxValue.ToString())


These produce criteria as such and will return all non-null records:

(Numeric) "-2147483648 - 2147483647"

(Date) "01-01-0001 - 12-31-9999"