[jira] [Comment Edited] (CONNECTORS-1130) Adding Key value pairs as filter while crawling documentum content using ManifoldCf

["hemant Jain (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CONNECTORS-1130?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14259388#comment-14259388 ] 

hemant Jain edited comment on CONNECTORS-1130 at 12/27/14 3:34 PM:
-------------------------------------------------------------------

Hi Karl
Thanks for the prompt response.
Below is the required DQL being used by me in the current Autonomy documentm connector:

select a_status, acl_domain, acl_name, dsm_additional_info, dsm_auth_profile, dsm_business_function, dsm_business_function_subj, dsm_business_group, dsm_business_processes, dsm_business_subsystem, dsm_business_system, dsm_business_units, dsm_change_request_nrs, dsm_departments, dsm_doc_classification, dsm_doc_collection, dsm_doc_info, dsm_doc_type, dsm_effective_date, dsm_filing_code, a_content_type  from dsm_basic_doc(all) where a_status='Effective' and (lower(dsm_doc_classification) <> 'secret')

Below are the DQL to list all available attributes that could be used for such a filter:

select a_status from dsm_basic_doc(all)
select dsm_doc_classification from dsm_basic_doc(all)

I would be very happy to test the code from you.
Please let me know if some more information is required.

Regards

Hemant 


was (Author: hemantjainmca):
Hi Karl
Thanks for the prompt response.
Below is the required DQL being by me in the current Autonomy documentm connector:

select a_status, acl_domain, acl_name, dsm_additional_info, dsm_auth_profile, dsm_business_function, dsm_business_function_subj, dsm_business_group, dsm_business_processes, dsm_business_subsystem, dsm_business_system, dsm_business_units, dsm_change_request_nrs, dsm_departments, dsm_doc_classification, dsm_doc_collection, dsm_doc_info, dsm_doc_type, dsm_effective_date, dsm_filing_code, a_content_type  from dsm_basic_doc(all) where a_status='Effective' and (lower(dsm_doc_classification) <> 'secret')

Below are the DQL to list all available attributes that could be used for such a filter:

select a_status from dsm_basic_doc(all)
select dsm_doc_classification from dsm_basic_doc(all)

I would be very happy to test the code from you.
Please let me know if some more information is required.

Regards

Hemant 

> Adding Key value pairs as filter while crawling documentum content using ManifoldCf
> -----------------------------------------------------------------------------------
>
>                 Key: CONNECTORS-1130
>                 URL: https://issues.apache.org/jira/browse/CONNECTORS-1130
>             Project: ManifoldCF
>          Issue Type: New Feature
>          Components: Documentum connector
>            Reporter: hemant Jain
>
> We are planning to replace Autonomy IDOL by SOLR search
> Currently I am using Autonomy Documentum connector to crawl my documentum data.
> Input to this connector is DQL query with some filters in where clause. ie meta data and value
> Is it possible to use key value pairs as filter while crawling the Documentum content using ManifoldCf GUI?. Please suggest.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)