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 »

  1. Could u do the same thing to single value to multiple value.

    Comment by Krishna | October 4, 2012 | Reply

    • yes you can

      Comment by mohammedatef83 | October 7, 2012 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: