Content Management and Capture

Trying to get some counts of Emails archived for specific user and need to convert this FileNet SQL to MS SQL

Article with sample queries - https://www.ibm.com/support/pages/configuring-querystring-option-specify-document-selection-when-running-ibm-content-collector-set-retention-tool

Specific query to translate -

SELECT DEI.this, DEI.* FROM ICCMail3 DEI INNER JOIN ContentSearch cs ON DEI.This =

cs.QueriedObject WHERE CONTAINS(*, '(:''//icc_recipients[.contains("""test1\/ibm""")]'')')

Anyone been able to do this with success?

You can't. Apache Lucene (which is what CSS basically is) is outisde the MS SQL domain. Or am I misunderstanding something?

/Gerold

Thanks Gerold, I suspected as much.

Regards, Kenny