Mohammed Atef’s Technical blog

Copy multi value property items to another multi value property using FileNet search Bulk Query

Introduction:

here I am going to tell you trick in FileNet search bulk query when you are going to run script to the search bulk result by Filenet Enterprise Manager.

Problem

the issue is how to copy multi value property  items to another multi value property in same the document class using Filenet Enterprise Manager search bulk query.

solution

1- open the Filenet Enterprise Manager and open collapsed object store you need to do that process upon

2- go to search result node and select new search as shown in picture below

image

3- select your document class and then determine it’s search criteria

4- select the script tab and check the execute script check box as shown in picture below

image

5- select the VB script type and write the following VB script in text below

   1: Public Sub OnCustomProcess (CEObject) 
   2:  
   3: set objsrc=CEObject.properties.item("SourcePropertyName").value
   4: set objdest=CEObject.properties.item("destPropertyName").value
   5:  
   6: for i=1 to objsrc.count
   7: objdest.add objsrc(i)
   8: next
   9:  
  10: CEObject.Save
  11: End Sub 

the code listed above is very simple,about lines number 3 and 4 i have just create objects of property that i will use, but please do not forget to replace the sourcepropertyname and destpropertyname with the accurate properties names you have.after that i have loop between items in the source property and add it to the destination property.

I Hope that help

Advertisements

August 26, 2010 Posted by | Uncategorized | 2 Comments