‎24-02-2015 06:07 PM
Hi All,
I am trying to write a macro that extracts the text from an objects "Comments" field (i.e the text that is entered on an objects comments by someone creating content) and then tells me if an Org-Unit object name is within that text.
For example lets say I have an Org-Unit object called "Contractor" and I have another Business Process Object called "Assurance". I want my macro to look at the "Comments" field of the Business Process Object "Assurance" and check to see if the word "Contractor" appears in that field or not.
I'm wondering if anyone could share a macro that does something similar to give me something to start with as macros are not something I am used to dealing with.
Many thanks!
Aaron
Solved! Go to Solution.
‎12-05-2015 05:39 PM
The only thing that comes up in my mind is
dim application set applications = getRoot().getCollection("Application") for each application in applications if(InStr(application.getProp("comment"), "~FgQEydJ2LziI") ) then print application.getProp("comment") end if Next
That is what you get:
{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fnil\fcharset0 Arial;}} \viewkind4\uc1\pard\lang2057\fs20 Test of system purpose \v ~FgQEydJ2LziI[\b\v0 Application-53\b0\v ]\v0 ssw\par } Elapsed Time : 0.849 s
‎03-03-2015 12:23 PM
Bump
‎25-02-2015 04:24 PM
Thanks Jerome,
I am afraid the first solution, although works will not do exactly what I need it to do. In short I will be generating a document where an "Org-Unit"'s name is described in the comments box of another object but will need the value of the org unit name to change according to what org unit you are looking at. I therefore need to store the org unit name in a variable of some sort to run the check. Are you aware of a similar solution that might exist for this?
Kind Regards,
Aaron
‎24-02-2015 09:24 PM
Note also that with in solutions (ERM, Audit, ITPM, Internal Control..) of HOPEX Web Front-End, a full search feature is available
It is not available in Windows Front-end.
‎24-02-2015 09:22 PM
Hello Arron
1) Note that there is a standard feature to search for a string within the text 'Comment' of all Metaclass'
See image atached
2) Another option is to use an element of the syntax of ERQL queries
Ex:
Select [Org-Unit] Where Comment Like "#contractor#"
By code you can build a query for each MetaClass
3) Another option is to use macro code to parse the text values of all to object.
See VB Script language capabilities.
In all case, note that such features will be time consuming.