Home

dqMan 5 User manual

Contents

1. 104 164 3 Shared Favorites E ER 105 LOLA DOCUMENTATION C EE EEA AEE AE NER E EE EERE ENE 105 16 2 API Command Vie Wer E 106 16 3 DQL Command View ccccssccccsssecessnececsesececseseeceesaeeecsesaececeeeeceesaeeecsesaececseseeceeaeeecsesaeeeseeeeeeneas 107 40 3 l iSeHiBSczinccsuncsssnze e HEUS HINSOINMRIHUSMIS E EEG NI ON IS tastes HEUS tue yap E E 107 POS Ee EEE ERE EEE E yankee EE tcoedinet rasta a O E EERE 108 16033 Syntax Highlight ince tret mate tte E EE EEEE E E EE E E 108 10 34 OTI HIS e onee Pe a EE D tete iier tenete EE E 109 10 3 5 Repository NQVIBOIOT nes I EERE E E E E RE RE E ER ueeeeseaaed 112 P dqMan 5 User Manual Page 4 aja 16 3 5 1 Cabinets Folder Tree tanita eee tt e ERE vex ERU Eve rede epe Eve eve de epe ee Eudecs 112 16 3 9 2 Object Iype Trel iere tetra Sui Dee MER CHE Ve beu oko ME EXE EVE Due SEEN TRUE Doe ERO 113 10 3 5 3 GrOWp VOE cscs ss sace eer tV EATUR e eet e EEE EE EUER CHE Ve E EU XE EN e Due ENRE eR END 113 16 4 SCEUPE VIEWS C 114 16 5 PUDCUODS ee treedeetite ete erbe tien bestertstere soe bentesiscese teet eeteiiectete tete Perbitese teen bestertstere resins erties 115 163A Object Functions ER 115 10 3 2 Session FUMCHONS eee et ee tec Re eter e Rye te v E ER e De e EUR EU LEER TOR be Oe pter 126 16 6 Miscellaneous
2. Change Object Type Attribute Mapping gt Next lt Back Source Attribute on Target Attribute scope begin tag receivers document_type mp name nvp value e fo 7 value list 1 e value list 2 e value list 3 e message e target e value list 4 e l E Attribute Mapping Iv Show type related attributes of target objecttype only v Show matching data type only Cancel Figure 32 Change Objecttype Assistant 2 In the dropdown lists only attributes of the new type will be displayed that are type specific of the new type and that have the same data type as the old attribute Additionally repeating attributes of the old type can be mapped to repeating attributes of the new type only Single attributes can be mapped to single attributes only Changing the options can influence this behaviour Show type related attributes of target object types only Deactivate this option to select from all attributes of the new type Show matching data type only Deactivate this option to map different data types ar dqMan 5 User Manual Page 103 On the last page the generated script will be displayed It can be saved by clicking on the button Save script or it can be copied into the DQL script view of the current session window for execution using the button Finish On the third page some optional features can be activated n Change Object Type I
3. X D JJ 9s 155 Options gt Next v Encapsulate as transaction EIL M Ignore r immutable flag M ChangeACL Wastebasket m v Linkto Temp Browse amp Iv Move objects to new location Figure 33 Change Objecttype Assistant 3 Encapsulate as transaction The complete change of the object type for each object is treated as one transaction If an error occurs the action will be rolled back Ignore r immutable flag Older versions are usually protected from being changed by the r immutable flag This behaviour can be ignored Change ACL The changed object can be assigned a new ACL in one step Link to Changed Objects can be linked or moved to a new folder in one step P dqMan 5 User Manual Page 104 ME 16 Options The Options are the central tool in order to adapt the features and functionalities of dqMan They are available from the Extras menu The window shows a tree structure on the left side to navigate the different categories 16 1 General The General category has four subsections 16 1 1 Settings e Open session at startup Automatically opens a session window at start up The start view can be selected from the Start with dropdown e Restore last executed query from history Restores the last executed DQL query from the history e Show toolbar Displays the toolbar e Show tabs for open windows Displays an additional t
4. Display of server response time in status bar Describe command can be stopped during execution Support for undocumented adminstative function execute count_sessions Template queries and object functions Use cached queries option for dynamic value assistances Message Area Logging options Auto Clear Log Log Query Results in Fixed Width or CSV format API Scripts Script command Sleep supported in API scripts Command DEFINE no longer valid Increment and decrement variables containing numbers e g LoopiIndex or PositionID Repository Navigator New icons for roles Script Generator Autocomplete can be activated with lt Ctrl gt lt Space gt All attributes of an object can be referenced The attribute does not need to be part of the underlying result list anymore New option for DQL scripts Auto escape single quotes Object functions Syntax highlighting added Value assistance can be invoked manually using lt Ctrl gt lt Space gt Indenting with function code is now allowed Increment and decrement variables containing numbers Ar dqMan 5 User Manual Page 13 e g LoopiIndex or PositionID Grid hints Value assistance can be invoked manually using lt Ctrl gt lt Space gt New dqMan DQL administration method set session dd locale added to set locales in DQL script Dump and Load Optionally stop DMClean and DMFilescan jobs during load operation Destroy dump loadobject otional Chang
5. To reference any values of the underlying DQL result list insert the attribute names in curved brackets If any referenced attributes are not available in the DQL result list the function is disabled The multiselect option is not available for this type of function P ME dqMan 5 User Manual Page 128 16 5 2 Session Functions Session functions nearly offer the same elements as object functions One difference is that references to result list values like r object id are not allowed The other is that they are executed exactly once independently from any selections made anywhere in the session window Installed session functions can be found in the Functions menu from the main menu They are only available if the active window is a session window with a valid session alad dqMan 5 User Manual Page 129 16 6 Miscellaneous 16 6 1 Docbroker Availability At startup dqMan can check whether a docbroker host is available If the docbroker host is not available an error window is displayed which shows all in the dmcl ini file configured docbrokers and their status There are different test modes available No check No checking Primary docbroker only Only the primary docbroker is checked and must be available Backup docbroker will not be checked Any docbroker All available docbrokers primary and backup will be checked At least one must be available Check all docbrokers All available docbrokers
6. WordPerfect 8 Doc Excel Workbook 5 Excel 97 2000 W Excel 97 2000 1 Access 95 Databas Access 97 2000 Access 97 2000 Word 6 0 7 0 Docu Warn Q7 INNAN Ne 1 1 sO Wa dqMan 5 User Manual Page 57 7 1 The Cabinet Folder Tree Creation of a DQL query for the folder contents Clicking on a folder with the left mouse button directs dqMan to create a DQL query for the folder contents It is placed in the DQL command input area without executing it The query is created by using the Default Query Template that can be modified in the options dialog Viewing the folder content Using the center mouse button creates a DQL as described above but it is automatically executed Context menu Clicking on a folder with the right mouse button opens a context menu o Expand recursive Expands all subfolders o Dump object Creates a dump of the currently selected folder o List of query templates List of template queries defined in the options dialog Templates marked with a green arrow will be executed immediately the others generate a DQL query only o Create Folder Opens a dialog to create a folder The folder is linked into the currently selected cabinet or folder The name of the folder is mandatory an ACL can be assigned optionally o Create Document Opens a dialog to create a document dm document or any of its subtypes The document is linked into the currently selected cabinet or folder The sel
7. command Execute as Subquery Opens a copy of the current session window and executes a DQL query Do nothing No action is taken The option Copy to Clipboard is no longer supported It was replaced by the variable Clipboard that allows more flexibility Functions can be grouped by assigning a category A category name represents a submenu of the context menu where all functions of this category are listed P wa dqMan 5 User Manual Page 118 e Allow multiselect e Ask user before execution e Active e Ignore errors e Create Debug Script e DQL Result List e Repository Navigator il e Object Navigator Multiple objects can be selected and processed at the same time The execution must be confirmed first Inactive functions are not visible in the context menu If an error occurs the execution is continued with the next object Error messages will be displayed in the function result message after processing all objects This option is for function development only Instead of executing the function the resulting API script is opened in the API Script View if the function was executed from a DQL Result List Otherwise it will be opened in an extra text window and can be copied into any API Script view for execution The generated debug script is full runnable in dqMan Function is available in DQL Result List Function is available in Repository Navigator Function is available in Object Navigator
8. needed the context menu offers a function to execute the underlying query in the DQL window Configuration The Object Navigator configuration is stored in the file dgManObjectNavigator xml in the config subdirectory of the dqMan home directory c program files dqMan The configuration is done in different sections within the file Section lt identifiers gt Identifiers are used to uniquely identify objects by the value of an attribute e g an acl name identifies a dm acl object and are used in the DQL result list or the Object Navigator itself The attributes can be single or repeating Identifiers consist of an attribute name columnname acl name and a qualification qualification dm acl where object name j The value of the attribute is represented by identifier columnname acl name qualification dm acl where object _name gt lt identifier columnname a_content_type qualification dm format where name gt lt identifier columnname content_type qualification dm format where name gt identifier columnname r accessor name qualification dm group where group_name union select r object id from dm user where user name and r is group 0 gt P dqMan 5 User Manual Page 66 ala Section lt co attributes gt Copy attributes fill the submenu of the function Copy Value of fro
9. awa dqMan 5 User Manual Page 119 On the second page not available for option Execute as Subquery global variables can be defined When the function is called these variables are either filled by manual input of the user or queries from the repository using API commands The values of the global variables are valid for all objects processed in one function call d Edit function Global Variables Field type Input field with DQL query valu v Name ACL Name Label Bitte wahlen Sie eine ACL Value Use as defat Show always Mandatory v Use cached query v Variable Index j1 lt qP Add Variable c Delete Variable DAL Query select object name from dm acl where acl classz0 and owner name dm dbo order by object name Check syntax Next gt lt Back Save and Exit Figure 40 User Function Assistant 2 In the variables also column values of the DQL result list can be referenced e g r_object_id In this case the function can be executed for single objects only The option Allow multiselect is deactivated automatically The DQL query Select full format from dmr content where any parent id r object idj order by 1 results in a pick list that contains all available formats of an object The column r object id must be contained in the DQL result list and only one object must be selected otherwise this function is
10. 16 3 3 Syntax Highlighting On this page the range color and style of the syntax highlighting can be customized Depending upon the selected level more or less reserved words are marked Available levels are None Low Medium and All An Example can be seen in the last column Syntax highlighting is available in the DQL View only a dqMan 5 User Manual Page 109 16 3 4 Grid Hints Grid Hints are hints that show additional information for single objects They are faded in if the mouse is moved onto the row header containing the row number Name dmadmin Is group False e State Active Capability System Administrator g Privileges Superuser autorender w autorender ru Figure 34 Grid Hint for a dm user object Grid Hints can be defined for different object types They consist of a hint template and translations n Options E General 2 Settings Login i Favorites Documentation API Command View amp DOL Command View i Settings Colors t Syntax Highlighting 7 Script Views Repository Navigator _ Cabinets Folder Object Types Groups E Functions Object Functions E Session Functions Miscellaneous i Docbroker Availability A Edit Add Delete Mg IN JZ Edit Add r accessor permit Delete aa S ee cm Figure 35 Gri
11. attributes lt objecttype gt P A dqMan 5 User Manual Page 67 Connections are defined as a DQL query whereas defined labels are used to assign the result to the Object Navigator columns relation name packages label Workflow Packages limit to 50 select r object id as relation id dmi package as relation label r component id as target id r component name as target label from dmi package where r workflow id r object idJ order by 4 lt relation gt The number of results of a query can be limited by setting the 1imit_to value for the connection This is useful to limit loading time of an object Attributes in curved brackets reference the currently loaded object in the navigator The resulting values are displayed in the Object Navigator target label in the column To From and relation label in via If the label is omitted the target id or relation id will be displayed instead If no relation value is queried the column via remains empty This chapter describes only the basic principle of the Object Navigator configuration There are many more examples to be found in the dgManObjectNavigator xml ar dqMan 5 User Manual Page 68 9 Processing Attribute Definitions dqMan offers functions to view edit and copy attribute definitions They are available from the context menu of the DQL result list after executing a describe command Copy Ctrl C Dup
12. DQL query contains more than one attribute the value of the first column will be displayed in the value list the corresponding value of the second column will be inserted in the query In a fixed value list the displayed value and the inserted value can be separated by e g Label Value The query Select object name r object id from dm document will fill the list with the object name attribute of all dm document objects Selecting a name from value the list returns the r object ia for the placeholder Check Syntax Check the syntax of the current DQL query This feature is only available if a valid session exists P Wa dqMan 5 User Manual Page 40 3 1 12 Formating DQL Queries DQL queries can be formatted automatically The associated format templates are defined in the file dgManFormatTemplates xml To format a query click on the query in the DQL input area and select the function Auto Format Query from the context menu of the DQL input area The Query Select r object id object name where object name like dm or object name like r object name acl name Will be formatted to SELECT r object id object name acl name FROM dm document WHERE object name like dm or object name like ORDER BY xy object name acl name acl name from dm document xy order by Queries can also be unformatted with the function Unformat Query from
13. Objects Open navigator Renditions testfunktion Export to Generate Script Excel 97 2000 Template Access 95 Database Access 97 2000 MDE Database Access 97 2000 Database Word 6 0 7 0 Document Word 97 2000 Document Word 97 2000 Template PowerPoint 97 2000 Presentation PowerPoint 97 2000 Template Microstation Document Framemaker 5 5 Chapter Framemaker 5 5 Fax View Edit ACL Messages 2634 Rows returned in 2 442 sec Server response time 0 174 sec 12634 Rows returned in 2 442 sec Server response time 0 174 sec Figure 3 Result list The columns and rows of the result list can be sized in width and height Columns can be moved using the mouse Within the result list search functions are available A search over the entire table takes place by means of the function Search from the menu Edit Typing one or several initial letters within one column will scroll to the first value matching a AF dqMan 5 User Manual Page 24 Two context menus are available for the result list which are activated with the right mouse button On the column heading line an alphabetically sorted ile list of all available columns appears acl domain acl name Clicking on an item scrolls this column into the visible authors range of the list a content type f ini group name group permit language code DN log entry Jn message 2if object_name ig owner_name owner_permit
14. The Describe Command The Describe Command is entered in the DQL input window and displays all attributes and selected characteristics for an object type Syntax Describe type all custom with name name locale locale locale all Describe table name lt identifier gt Arguments type Object type like dm document dm acl or custom types all custom all lists all attributes including all inherited ones custom lists all customized attributes including parent objects If no argument is supplied only the type related attributes will be listed Available for object types only table Name of a registered table e g dm dbo dm queue or dm queue name lt name gt Part of or complete attribute name and or column name Wildcards are or locale locale Locale name for the attribute labels Multiple locales can be separated by comma locale all displays all attribute labels of all available locales Available for object types only The attribute labels can be edited directly in the result list using the edit function from the context menu Changed labels will be published immediately Due to local caching the displayed labels can differ after editing until the local cache is updated dqMan 5 User Manual Page 32 aa DOL Query describe dm acl with locale all name r Results 10 Char 32 Berechtigungssatz Mitglieder Per
15. be logged in CSV format Only valid for DQL script log Results of DQL queries will be logged as list with fixed width Values can be truncated if too long Color of the next script command to be executed in debug mode only Color of an incorrect script command in debug mode only a dqMan 5 User Manual Page 115 16 5 Functions Functions are user programmable extensions for dqMan There are two different types of functions Object Functions and Session Functions Object functions are available from the DQL result grid They can contain references to the DQL result grid as known from the Script Generator On execution the function will be executed once for every selected object whereby the references are replaced with values from the current result grid Session functions need a valid session and are executed only once They cannot reference any values from the current session window dqMan is installed with a number of object and session functions that demonstrate the use of the extended functionality described below If there are any more questions please send an email to dgMan fme de 16 5 1 Object Functions r Options General Object Functions i Settings Name Category ras imis ston Delete Workflow 4d Edit i Delete Workflow and Dok 1b l API Command View Delete line k H DOL Command View Dequeue Item 1b Copy Settings Destroy
16. different for both lists since the criteria can be fulfilled by more than one data record Page 90 an dqMan 5 User Manual 14 1 4 Working with Marked Records The result of the compare operation will be displayed in the corresponding data lists All found records will be marked If the function Search for different records was executed the rows with differences will be highlighted select from dm acl select from dm acl 45bc614e80000113 45bc614e80000114 22 455e614e80000115 23 45be514e80000115 24 455e614e80000117 25 4snc614e80000118 45bc614e80000119 45bc614e8000011a 28 455e614e60000115 le 45 bc614e8000011c 45bc614e8000011d 45bc614e8000011e 32 45bc614e8000011f as 45bc614ee0000120 34 45bc614e60000121 45hr amp 14ennnnnt22 dm 45bc614e80000113 dm 45bc614e80000114 dm 45bc614e80000115 replica acl default dm 45bc614e80000117 dm 45bc614e80000118 desktop client acli dm 45bc614e8000011a dm 45bc614e8000011b dm 45bc614e8000011c dm 45bc614es8000011a dm 45bc614e8000011e dm 45bc614e8000011f dm 45bc614e80000120 dm 45bc614e80000121 rim 45hrf amp 14ennnnni22 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 4556c614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 dm 45bc614e8000 450f427f80000116 450f427f80000117 450f427f80000118 450f427f80000119 450f427f8000011
17. disabled The syntax of a DQL query can be checked by clicking on the button Check syntax if a valid session is available in any session window P alad dqMan 5 User Manual Page 120 Field type Input field Input field with fixed valuelist Input field with DQL query list Date picker File open dialog Directory selector Cabinet Folder selector API Command Field where a user can must input a value An input field with fixed value assistance that must be entered into the control Valuelist Data If items in the value list contain the characters the part prior to will be displayed in the dropdown control the part after will be returned as value e g Label Value An input field with value assistance that is filled with the results of a DQL query The DQL query must be entered in the control DQL Query If the select list of the DQL query contains more than one attribute the value of the first column will be added to the value list the value of the second column will be returned as variable value The query Select object name r object id from dm document fills the list with the object name attribute of all dm document objects Selecting a name from the list returns the x object ia Displays a date picker control An input field with a browse button A list of allowed file types can be entered in the control File Formats Allows selection of a directory from the local f
18. primary and backup will be checked All must be available The button Edit History opens an editor to manage saved docbroker information Wa dqMan 5 User Manual Page 130 16 6 2 Docbasic Interpreter A valid Docbasic interpreter must be supplied to use the type Docbasic Script in the Script Generator Default is DBEditor exe that is installed with Documentum Developer Studio The generated script is saved as file and can be passed on to the Docbasic interpreter as parameter There are some predefined placeholders for parameters available filename Filename of the script generated by dqMan user Username of the selected session window password Password of the selected session window docbase Repository of the selected session window The curved clips are a necessary part of the placeholders Example The Parameters filename u user p password d docbase will be transformed to DBEditor exe c temp script ebs udmadmin padminpwd dtestdocbase 16 6 3 Tracing e Default trace level Trace level that is used starting a trace e Always open tail viewer Always opens a tail view if a trace is started either by clicking on the Trace button of the toolbar or using the API command trace c P Wa dqMan 5 User Manual Page 131 17 Appendix A Unsupported Commands and dqMan Syntax Extensions This section holds information about undocumented DQL commands as well as dqMan syntax extension
19. timed out sessions cold list size free sessions This method is also offered through the session function Server Session Statistics available in the Functions menu 17 4 Script Commands and Variables Chapter 16 5 Functions introduces script commands and the use of variables in API scripts These are also dqMan specific and will not work anywhere else Wa dqMan 5 User Manual Page 133 18 Appendix B Plugins Plugins expand the functionality of dqMan They consist of a DLL stored in the subdirectory Plugins of the dqMan the program directory The following two plugins are part of the dqMan installation E dqMan 5 User Manual Page 134 18 1 The DMCL INI dfc Properties Editor The editor offers fast access to the configuration files of Documentum It is available from the Edit menu and opens the first file found following the environment path Also the reference file dmclfull ini dfcfull properties will be opened if it is found The opened file depends on the currently used interface If dmdl40 dll is used dmcl ini will be loaded if dmcl dll with dfc is used then dfc properties will be shown r A Edit dmcl ini MEN orn File Edit View Extras bl X E m bo p Pp r 2 Save Paste Undo Search Sections dmcl ini Version 5 of Documentum products Default DMCL INI Refer to DMCLFULL INI for other options Assuming No Network File System Assuming No Compression for Content Tunneling A gener
20. w Create Attribute v User Interface hints IV Search Options IV Value Assistance v Value Mapping C None Publishing Cancel Rename attributes and change repeating flag if necessary Attribute acl class gt Jacl_class description gt description globally_managed gt globally_managed Cancel ay dqMan 5 User Manual Page 72 if Attribute Create Script In case of error please change the session local before continuing script execution Liilllllll cl FS FS SS ES FSS 1 1 0 FSS 0 0 0 0 00 0 10022 execute set session dd locale with locale de LIillllll sl di f lll1 ll df f 0 1 0 1 0 0 0 FFF 00 22 Create attribute acl class amp ei ALTER TYPE new type ADD acl class Integer ALTER TYPE new type MODIFY acl class SET ignore immutable 0 SET is hidden O0 m a Initialize Session Locale FFFFFFFFFE gt Execute in lt Back Save script Review generated script Click on Back to change settings Save script to save the script to the file system or choose a session to directly execute the generated script P Ar dqMan 5 User Manual Page 73 10 Viewing Textfiles dqMan offers two functions to view external text files like log files or trace files To open static text files the function View File from the View menu can be us
21. where folder Additional options are available Use as default One standard template can be defined by enabling this option The standard template will not appear in the context menu but is called directly with the left or center mouse button Enable direct execution If this option is enabled the generated DQL query will be executed immediately This sort of template is marked with a green arrow in the context menu Wa dqMan 5 User Manual Page 113 16 3 5 2 Object Type Tree Auto expand at startup Autoformat queries Show customized types only Start with Query templates 16 3 5 3 Group Tree Auto expand at startup Autoformat queries Group top level by first lt xx gt characters Limit no of groups to Query templates The first level will be loaded and displayed on login Generated queries from query templates will be formatted automatically Only customized types and all types with customized subtypes will be shown in the tree Also all Documentum base type tables will be hidden e g dm sysobject s whether they are registered or not Object type to start with Type tree only There are two kinds of query templates for dm type objects and for registered tables The functionality has already been described in the section gt Cabinet Folder Tree The first level will be loaded and displayed on login Generated queries from query templates will be formatted
22. 0 Copy Registered Table Assistant 3 The option Register all columns will do a complete registration of all copied columns with names and types This option is only enabled for selection if the table is not fully registered in the source repository If it is checked the registration will differ between source and target repositories The table permissions are initialized with the permissions of the source table but can be changed if necessary P Wa dqMan 5 User Manual Page 100 Data selection If the operation Copy content was selected a where clause can be added for data selection Result On the last page the generated script will be displayed It can be saved by clicking on the button Save script or it can be copied into the DQL script view of an existing or a new session window for execution using the button Execute in The assistant will close automatically if the script is copied into a session window ar dqMan 5 User Manual Page 101 15 3 Change Objecttype Using the Change Objecttype assistant the object type of objects can be changed It can be found in the Extras menu but it is only available if called from a session window with an active session and the DQL command view selected Furthermore a DQL query result must be available that includes the x object id attribute All selected objects in the result list must be of the same object type Supported types are dm document dm folder and
23. 0 10 VIEWING TEXTFILES eere esee ee ense en setate stats tns tns tn eraro seta suse Deac sesso sess sone tasse en sesto sensu aen 73 10 1 File Vie EN 73 10 2 MRAM VIE N 73 11 THE SCRIPT GENERATOR eene reete seen tenete sns tn sns tn sets tu seta sse ta sens enses toss is suse ta sons osve sscb sdovis v s 74 11 1 Script Templates RHENUS WEE GEO RR RERO es 75 IREI Pl CW Oder EH m 73 II4 2 Processing AstructloHs ipee ite enses epus citro du ee ee cgo Eo eg e e bg ede laces Pera ae ite eg o Ie 76 HERE TED UIT I ES 77 11 2 Manaping Script Templates iis 78 11 3 The HIStory daise eree riro Erra REEE EEE EEE EE REEE yevessecanweatesuevbardeiaysedestevbestsunveassosaties 78 11 4 SCHpPt Types and Ren ME 78 11 5 Adding Data SOurcess s si 8 cise costae ond T E EEVEE E EEEE E EE iia EEEE Er 79 11 6 Generating a SCEIpL s ioo eerte certet ci ep EEEE EE EE caved E EEEE EE E dk EEE Edd 81 11 7 Exec ting inspect 81 11 8 Type dependent Script Templates eee eren tiepi tte citri reta tera tUe chen cba uus 81 i 2M 1 1 1 11 0 1d tete M 83 12 1 Import OF CSV Or Text Piles eerte er teme OR reete netten an eee gero rev eene a ERES 84 12 2 Import OF Excel Piles m 85 12 3 Import from Clipboard eH eas detest eas DEI as AL ee 85 13 BATCH OBJECT CREATION uu ccsscsssssssscccssscsssssssscssssessssnssscsss
24. 00000000000 0000000000000000 090f430a80007de2 i_chronicle_id 090f430a80007dc8 090f430a80007dc9 090f430a80007de2 i contents id 060f43028000ae08 060 430a8000ae0a 060 430a8000ae37 kxapiteinummer o o 0 1 0 1 object name 0 0 Deckblatt 0 1 Inhaltsverzeichniss 0 1 Table of contents Deutsch r access date 02 08 2011 10 04 43 04 08 2011 09 44 23 28 07 2011 17 36 30 r content size 22275 37227 35918 r creation date 18 04 2011 12 57 02 18 04 2011 12 57 03 28 07 2011 10 47 26 z creator name dmadmin dmadmin EIBL CHRISTIAN z full content size 22275 37227 35918 r modifier dmadmin dmadmin EIBL CHRISTIAN r modify date 21 04 2011 13 16 08 21 04 2011 13 16 29 28 07 2011 16 15 24 aera ae 12 13 CURRENT CURRENT CURRENT sprache Deutsch Deutsch English title Deckblatt Inhaltsverzeichniss table of contents Object 090f430a80007de3 added Figure 27 The Object Compare List The attributes are aligned vertically The object in the first column is the master object All other objects are compared with the master object Differences will be highlighted Differences in single values of repeating attributes will be displayed with red font color To change the master object the new master object can be dragged to the first column using the mouse If different object types are compared attributes that are invalid for the object type remain grey and empty The button I refreshes the values of a column deletes the column P wa dq
25. 11 resolution label ast r creation date r modify date r object id r object type scope subject itl ted title world_permit On the data area a list of functions is faded in for object processing Available functions are Edit Starts the Result List Inline Editor gt 3 1 5 The Result List Inline Editor Copy This function copies selected values into the clipboard Rows will be separated with a linefeed and a carriage return character columns will be separated with tabs Duplicate Duplicate copies all selected values in a separate data grid Add to compare list The selected objects are added to the Object Compare List P Wa dqMan 5 User Manual Page 25 Sort Sorts the result data ascending or descending by the selected column Goto The function Goto enables the fast change to a line or a column for the result list If a number is entered the list will be scrolled vertically if a column header is entered or selected from the dropdown list it will be scrolled horizontally Marks Marks are used to select different objects in the result list Marks can be toggled or scrolled to the next or previous marked object Marks are mainly used by the Compare Data function but can also be set manually Object functions In the following section of the context menu user defined functions for objects in the result list are offered e g Change ACL Dump Object Last SQL statement Request PDF renditio
26. Er AE Pcr Cati ANE 47 3 3 4 Using Variables in API SCripls 5e crie e rici eet iter dii iid bye E eve dee Ced eve esed 48 3 3 5 Using Script Commands in API Scripts eese eene etre i saes 49 3 3 6 LOGGING Iv Ride avi M M T 51 4 CREATING A DUMP OF AN OBJECT eeeeeee eese essen ense tn tuse tn tuse ta sensns estas ets su seta sons ta sesso senatu 53 Bar SHARC a PE M soccaucstesssesesey 54 6 THE HISTORY 55 7 THE REPOSITORY NAVIGATOR eeeeeeee eese se ense ta sins tn sts tn seta suse ta sonata sesto sees saneta visose senten senatus 56 Td TheGCabmet PFolder Tree etri terere pee ie e Pte e HER eR Ee EE Ee ae ve 57 7 2 The Object Type Registered Table Tree esseseseeseeeeee eene enne nennen nennen nennen 58 TBs Ehe Group Tree yaen EAE een DIT eerie ei ev 59 VE MEE dI IUT MUI P ME 60 8 THE OBJECT NAVIGATOR eene retenta tn stne tatu sins tata sins tasas ins tasas totns tasa sene tasas insta sansara ssia 61 P i dqMan 5 User Manual Page 3 and 9 PROCESSING ATTRIBUTE DEFINITIONS eeeeeeeee eese esee eene ne tates tn sets tn seta suse ta sento senten statu 68 OAL MD tp ATE DUS zinc reto eee RE P RR rei T ee Tn 68 92 Edit Attribute eene oer b ene eter iq petet bait epis 69 9 3 Copy Att DUte rep de ertet bei eieievditenimiei entes eve 7
27. If valid logins exist in the login history you can open a dropdown list with available history entries by clicking on the down arrow beside the New or Connect button Reloads session dependent value lists like users groups or object types Switches current session locale to locale selected from submenu Sets an alias name for a session This name is used instead of default session name lt user gt lt repository gt wherever it is possible P Ar dqMan 5 User Manual Page 17 2 2 Login There are different ways to open a session e Opening a session window e Selecting Connect from the session menu or the toolbar e Executing an API or DQL command that needs a session without having a valid session Local commands like getservermap getdocbrokermap or connect can be executed without a session Whenever a session is needed but not available the login dialog will appear Logins can be saved in a history for repeated use either with or without password Saved logins are available through the History button Behaviour can be changed in the dqMan Options see 16 1 2 Login dqMan 5 User Manual Page 18 aa 2 3 Docbroker Availability At start up dqMan can check whether a docbroker host is available Please refer to the Options section for configuring this feature If the docbroker host is not available an error window is displayed which shows all docbrokers configured in the dmcl ini dfc properties file al
28. Man 5 User Manual Page 93 The context menu of the list offers additional functionalities Edit Values can be directly edited within the table A change is stored only if it is confirmed with the key lt Enter gt Repeating attributes can be edited within a small sub grid The sub grid offers an own context menu for inserting deleting or reordering values of the repeating attribute Copy Copies all selected cells into the clipboard Dump Object If the selected cell contains a valid object id this id can be dumped Goto Searches for attributes in the list Show Attributes All All attributes of all object types in the list Master All attributes of the master object Type specific Type specific attributes of the master object type only Identical values All attributes with identical values in every column Different values All attributes with a different value in any column Compare settings Compare case sensitive Compares case sensitive Exact order of repeating attributes Repeating attributes can have the same values but in different order Order Attributes by Name Sort attributes by name Category Sort attributes by category like an object dump Not sorted Attributes are shown in content server generated order Wa dqMan 5 User Manual Page 94 15 Script Assistants Script assistants support the development of complex API or DQL scripts 15 1 Dump amp Load The dump amp Load Script as
29. The ACL Viewer The ACL viewer displays ACLs for viewing and or editing and is called either from the View gt View ACL menu or from the context menu of the DQL result list It is activated only if an active session is available and either the selected objects in the DQL result list are ACLs or an ACL is assigned to them like dm_document or dm folder and the attribute x object id is available in the list E i daMan ACL Viewer men Ro ug co per m ACL List Properties Description J Showusagg dm UU 101 Name dm 450f430a80000101 dm_450f430a80 This function is disabled Owner G svcDEdm 000101 Class Regular Cle I Permissions User Group Permission 1 Extended permission dm world Read Execute Procedure Change Location p v dm owner Delete Execute Procedure Change Location eeEEEEEE EE_ docu Version Figure 44 ACL Viewer The ACL list contains all ACLs from the selected objects of the DQL result list To view or edit properties an ACL can be selected from the list ACLs will only be added to the list once Therefore the number of selected objects can differ from the of the number of the ACLs in the list The Usage area informs about the usage of the ACL in the current repository Change permissions One or more selected permissions can be changed by clicking on the Edit button If more than one permission was selected only the changes will be appli
30. The third page of the dialog either displays a textfield for the API sequence or for a DQL query option Execute as Subquery The Basic API Sequence Syntax n Edit function API Sequence Finish Back set c r object id acl name SACL Name set c r object id acl domain SACL Domain m save c r object id L Refresh acl name acl domain a Cancel Figure 41 User Function Assistant 3 The API sequence consists of a batch of API commands similar to an API script References to values of the DQL result list are enclosed in curved clips During execution those references are replaced with values from the result list fetch c r object id destroy c r object id There are different placeholders to access the data of the result list This is a reference to the currently selected column of the result list If more than one column is selected the function is disabled ID The selected column must contain a valid object id otherwise the function is disabled INT The selected column must contain an integer value TIME The selected column must contain a valid time value CHAR The selected column must contain a string value P alad dqMan 5 User Manual Page 123 Comments Each line beginning with the character or with is regarded as comment line fetch current object fetch c r object id destroy the current object dest
31. Types Groups Favorites 333 Object Types dm sysobject hj bm config api property E bm dpf job kj dm acs config dm activity hj dm app ref E dm application E dm bocs config Lj dm business pro kj dm cache config E dm category class E dm ci config Lj dm client registration B dm_client_rights E dm component E dm cont transfer config E dm cryptographic key hj dm decision hj dm dms config hj dm docbase config hj dm document EJ dm federation E dm folder E dm ftengine config Error detected at line 1 F m dm client_rights Results 2634 os0 430ae00001b2 090 430a800001be 090f430a800001bd a 090 430a800001be E 090 430a800001bf ls 090 430a800001c0 090 430a800001ci je 090 430a800001c2 i 090 430a800001c3 090 430a800001c4 090 430a800001c5 090 430a800001c6 12 InanFa2nsannnnin7t Default Signature Page Template Blank PowerPoint Pre 3 0 Presentation Blank WordPerfect 6 Document Blank WordPerfect 8 Document Blank Excel Workbook 5 0 7 0 Document Blank Excel 97 2000 Workbook Blank Excel 97 2000 Template Blank Access 95 Database Blank Access 97 2000 MDE Database Blank Access 97 2000 Database Blank Word 6 0 7 0 Document Risnblb Warn OF FANN naeemant Figure 19 Repository Navigator title PowerPoint Pre 3 WordPerfect 6 Doc Blank WordPerfect 7 Document WordPerfect 7 Doc
32. User manual for Documentum Content Server Pur P i dqMan 5 User Manual Page 2 ala Table of contents 0 SYSTEM REQUIREMENTS cccsscsssscsscsssesssessssssssscssssssssssssnesscssescessssssssesenesssssessessssessssssesesssesseses 5 iE UID OU M 6 1 1 License Agreement serso tatae eee e Aap eleven Ve ec e ae es Eee PARERE ER CEPS 7 1 2 Supported Documentum Clients essesssssseseseeeeeeee eene nennen enne reeenetene trennen trennen rennes 9 1 3 Eacense Level iere eee ee ee Rs Fe Reeve Eve ee TE ee REQUE DERE V es 10 1 44 New Feattires im Release 5 esee ete o epe EE eee eU Pee a ee pe Eo gebe dune ve tee Rb eeu 11 1 4 1 Former Xtended Features ee eben canteen Ee decere bue e tee vy ee Re pe Heec e ER Ee ceases 11 1 4 2 AJ ECV ONS oer sag a tpi ubl pembet E EA Cape Liebes 12 1 4 3 Xtended Editon oci e eee epe Hr cae il ea Se eae e reg ve b ce aee eae URN ENRE 14 1 5 Installing dqMan on a removable media sess eene nem nennen nen 15 MEE NTC S T e E T A E E A 16 2 4 SESSION manaPetnent neret Haee RE PR HER Ee Ee EIS RIEN ai e ru eve Ee te npe eee Eee 16 PUMP MC 17 2 3 Wocbroker Availability ettet eerte a hee Eee tete de eger be ora ren tese tbv eee ee aS 18 3 SESSION WINDOW 19 SN MEE THe DOL VAG p 20 3 1 1 Working with DOL Queries cccscccessceessecessceeseceseceescecsece
33. a 450f427f8000011b 450f427f8000011c 450f427f8000011d 450f427f8000011e 450f 427f8000011f 450f427f80000120 450f427f80000121 450f427f80000122 45nf427f8nnnn123 dm 450f427f80000115 replica acl default dm 450f427f80000117 dm 450f427f80000118 desktop client acli dm 450f427f8000011a dm 450f427f80000115b dm 450f427f8000011c dm 450f427f8000011a dm 450f427f8000011e dm 450f427f8000011f dm 450f427f80000120 dm 450f427f80000121 dm 450f427f80000122 dam 45nf427f8hnnni23 rim 45heA1 E E 52 Rows returned 0 181 se een ist 12625 Rows returned 13 438 sec n Figure 26 Working with marked records The marks will remain until either a new DQL query is executed in the session window a new data compare is run or the marks a removed manually using the function from the context menu Marked records can be processed as group similarly as selected data records Object functions export functions and the Script Generator support marked records To execute a function for all marked records exactly ONE cell of any marked record must be selected and the function started If more than one cell or a not marked cell is selected the function will be executed for the selected objects cells If the compare was executed with the functions Search for identical records or Search for different records the rows in the two grids are linked to each other A center mouse click on a marked record in one list will scroll the o
34. a loop through the values of the repeating attribute from the object identified by the ID object id SEndLoop Marks the end of the loop a Wa dqMan 5 User Manual Page 50 Example for a collection loop sCollection s readquery c select group name from dm group where any i all users names dmadmin SLoop Collection group name get c Collection group name Print Group name LoopIndexl group name SEndLoop The handling of the collection is done by the s ndLoop command It is not necessary to add next or close commands The variable LoopIndex lt i gt does only exist within a loop and contains the current loop index starting with 0 sLoopindex1s is the index of the first loop sLoopindex2 would be the index of the second loop if it is nested within the first loop Example for an attribute loop id id c dm document Loop i folder id id S Folder ID get c id i folder id LoopIndex1 SLoop r folder path Folder ID SFolderPath get c Folder ID r folder path LoopIndex2 fprint result 4 Print FolderPath SEndLoop SEndLoop The variable sLoopIndex lt i gt is incremented each time the sEndLoop command is executed It can be used as index for the repeating attribute values P ara dqMan 5 User Manual Page 51 3 3 6 Logging During the execution of scripts the result of the commands will be logged in the result log The loggi
35. a800001cO Blank Excel Workbook 5 0 7 0 Document Excel Workbook 5 0 7 0 Document 090f430a800001c1 Blank Excel 97 2000 Workbook Excel 97 2000 Workbook 8 090f 430a800001c2 Blank Excel 97 2000 Template Excel 97 2000 Template 9 090f 430a800001c3 Blank Access 95 Database Access 95 Database 10 090f430a800001c4 Blank Access 97 2000 MDE Database Access 97 2000 MDE Database 11 090f430a800001c5 Blank Access 97 2000 Database Access 97 2000 Database 12 090f430a800001c6 Blank Word 6 0 7 0 Document Word 6 0 7 0 Document 13 090f430a800001c7 Blank Word 97 2000 Document Word 97 2000 Document 14 090f430a800001c8 Blank Word 97 2000 Template Word 97 2000 Template 15 090f 430a800001c9 Blank PowerPoint 97 2000 Presentation PowerPoint 97 2000 Presentation 16 090f430a800001ca Blank PowerPoint 97 2000 Template PowerPoint 97 2000 Template i 4 r Messages amp DQL gt SELECT FROM E dm document 2 2634 Rows returned in 2 442 sec Server response time 0 174 sec 2634 Rows returned in 2 442 sec Server response time 0 174 sec 4 14 Ei Figure 2 The DQL View To execute a DQL query press F9 or lt Shift gt lt Enter gt select Run from the Edit menu or the context menu or click on the Run button in the toolbar A running query can be stopped by clicking on the Stop button in the toolbar Double clicking a cell in the result grid will copy the value into the clipboard If the lt Ctrl gt key is pressed while double clic
36. are stored by their repository id If you are working with clustered content servers or use full qualified repository names every repository needs to be listed only pnce a dqMan 5 User Manual Page 35 To load a query from the favorites call Edit gt Load from Favorites r Eton ot a a 7 mc Search attributes Cancel Name Category WDK Caws Searchtext document Querytype Jall X Objecttype all X Manage Result list Name Querytype Objecttype DQL Dokumentenabrufe nach Benutzern WDK Select dm dbo webs Dokumentenabrufe nach BenutzernSELECT Dokumentenabrufe nach Dokumenttypen WDK Select dm dbo webs Dokumentenabrufe nach DokumenttypenSEL WDK Typen WDK Select bm config w SELECT r object id object name typena 4 n Description 3 queries found Figure 8 Load from Favorites On the top of the window is a search filter The search criteria can be combined freely Searchtext does a full text search in all available favorite attributes In the center part of the window all queries are displayed that correspond to the entered filter criteria A double click on a query copies it to the DQL View input area If a description exists for a query it will be displayed in the lower part of the window if the query is selected Additionally the favorites can be managed within this dialog by clicking on the button Manage A separate button list w
37. ated client init file for Documentum products This file was generated on 16 03 2005 11 49 51 by user m The only REQUIRED information in this file is the DOCBROKER_PRIMARY section and an entry for host The host value should be the name of host on which your network wide DocBroker is running Se ie tee Se ie Se Se Sie ie Sie e S DOCBROKER PRIMARY Host dctm6server PORT 1 89 DOCBROKER BACKUP 1 host dctm5server PORT 1489 DOCBROKER BACKUP 2 dmcl ini loaded DOCBROKER PRIMARY 20 7 Figure 43 DMCL INI Editor For dmcl ini all entered docbroker hosts are stored in a host history If at any time host is entered or while the cursor is positioned on an existing host name the keys Ctrl Space are pressed the history will be displayed for value assistance dmcl ini only The command Clear host history from the Extras menu can be used to clear the host history MN dqMan 5 User Manual Page 135 Changes to the dmcl ini file will not take effect until at least all session windows of the dqMan are closed If the dfcfull properties file is found all available commands are loaded from this file and will be available as value assistance that will appear either if dfc is entered or by pressing Ctrl Space How and when changes to the dfc properties file will take effect depends on the dfc behaviour It may vary between different dfc versions ar dqMan 5 User Manual Page 136 18 2
38. automatically A repository can contain a large number of groups This option lets you create an additional first level in the group tree for a better overview by grouping the group names by their first lt xx gt characters This option limits the number of queried groups gt see Cabinet Folder Tree alad dqMan 5 User Manual Page 114 16 4 Script Views Clear script log at restart Copy comments to script log Add line numbers to script log Synchronize log to file Log everything Log results only Log errors only Log nothing CSV format for query results Fixed width for query results Next line Error The script log area is cleared each time a script is executed Comments in the script will be copied to the script log The line number of the command will be added to the script log If line numbers are stored the function Show command from the context menu allows jumping from any line in the log to the corresponding command in the script This options allows copying all log messages into a file If this option is selected the user has to select a target file every time a script is started If an existing file is selected the additional content will be appended to the existing file Everything will be logged Only results or error messages will be logged Only error messages will be logged Nothing will be logged Only valid for DQL script log Results of DQL queries will
39. bjects of any type can be added from any repository These objects are compared attribute by attribute and it offers the possibility to edit directly in the list 14 1 The Compare Data Function This function is only available if at least two different data lists are opened These can be results from DQL queries from any repository or imported data lists The assistant is described in the following sections 14 1 1 Settings Compare data Source Data Next gt Source data G svcDEdm gburgmann burgmann gDEWOHS v Back Target data G svcDEdm Intburgmann Intburgmann DEW Y Search for Identical records C Missing records C Different records Options Compare case sensitive Compare exact order of repeating attributes Cancel Figure 24 Comparison Settings P Wa dqMan 5 User Manual Page 88 First select the two different data lists to compare The possible lists are available in dropdown menus Subsequently the comparison function is determined Three functions are available Search for identical records Searches for identical records in both lists Search for missing records Searches for missing records in both lists Search for different records Searches for records that are joined by one or more column but differ in other attributes With the following options the comparison can be influenced Compare case sensitive Compares case sen
40. bles checkbox removes all system tables from the list 34 dqMan 5 User Manual Page 98 Selecting the target database type and columns This page is available if the operation Create table creation script has been selected Target Database Oracle MS SQL Server Targettable name new table name Columns Please select columns to copy Colummname Datatype Size Is key object id Char ref object id Char job id Char order no Integer Figure 29 Copy Registered Table Assistant 2 The target database type must be selected in order to generate the correct SQL commands for table creation On this page the created table can be assigned a new name by filling in a valid table name into the Target table name field Further single columns from the source table can be excluded If columns are deselected they will not be copied registered or filled with data At least one column must be selected a dqMan 5 User Manual Page 99 Registration and permissions This page is available if the operation Register table in target system was selected Copy registered Table dm replica delete Parameter F Register all columns not registered in source object Table Permissions owner table permit group table permit world table permit w Select Select Select V Update Update Update Jv Insert Insert Insert NV Delete Delete Delete ER CNN Figure 3
41. ccurrences click on the Count button P A dqMan 5 User Manual Page 55 6 The History The History records all successfully executed DQL and API commands for further use It is controlled using the tool bar e OQ B ack History Next Figure 18 History controls Clicking on Back or Next will load the according query into the input control replacing the existing content The History list shows a list of all recorded commands To copy a command either double click it or use drag and drop The content of the target input area will be replaced unless a part of it has been selected Copying a command to a script view will insert the command at the current cursor position without overwriting the existing content unless something is selected 33 dqMan 5 User Manual Page 56 7 The Repository Navigator The Repository Navigator is available in the DQL view It can be opened or closed by the Repository Navigator item from the View menu or by the Navigator button of the toolbar The Repository Navigator offers a cabinet folder tree an object type registered table tree a group tree and a favorites tree for the currently connected repository of the session window Every time a tree item is expanded the appropriate data is fetched dynamically from the repository Therefore an update of a part of the tree can be easily done by collapsing and re expanding the parent folder m Navigator Folder
42. change if DQL queries are executed again e Reverse displayed order of repeating attributes DQL queries usually return values of repeating attributes in reversed order This option reverses the order again e Move focus to DQL Result List after query execution e Autosize columns e Autosize rows e Separate repeating attributes e Enclose single values with Moves the focus to the DQL Result grid if a query was executed successfully If not checked the focus remains in the DQL area Column widths are adapted to the length of the represented data with the limitation defined in the Max Characters field Row heights are adapted to the max number of lines of repeating attributes with the limitation defined in the Max Rows field This option does only apply if the DQL query contains repeating attributes and their values are separated by a carriage return Values of repeating attributes can be separated by a comma a semicolon a carriage return a tab or by a custom string Encloses values of repeating attributes either with single quotes or with double quotes or with no character at all if nothing is selected Wa dqMan 5 User Manual Page 108 16 3 2 Colors e Highlight even lines background Background color for even lines e Marked lines background Background color for marked rows e Different columns background Background color for cells with different content from Compare data function
43. ct Navigator Figure 39 User Function Assistant 1 P Wa dqMan 5 User Manual Page 117 e Name e Typetag list e Repository List e Result e Category Name of function shown in the context menu Comma separated list of Documentum type tags e g 09 dm_document to restrict the function to certain object types Instead of type tags type names can be entered that will be replaced by type tags automatically To assign a function to all object types the character can be entered If no value is entered the function is always available But it will be executed only once independently of the number of selected data records The example function Last SQL statement uses this feature Enables the allocation of functions to one or more repositories Repositories can either be added manually or selected from a repository list by clicking on gt Multiple repository names must be separated with a comma An exclamation mark placed in front of the repository name e g testdocbase hides this function if this repository is active The result of a function execution can be presented in different ways Count processed objects Shows the number of processed objects in a dialog box Show result in dialog Shows the results in a dialog box Open textwindow Opens a text window to display the results Pass to operating system Passes the result to the operating system e g result of a getfile
44. d Hints a dqMan 5 User Manual Page 110 Edit Grid Hints Options OK Cancel Name dm document Typetag o9 Repeating values in rows columns Values Doctype r object typel Checkedout by r lock owner Checkedout on r lock date Version r version label Figure 36 Editing the Grid Hints A Grid Hint template contains the following elements e Name Freely selectable name shown in the grid hint list Typetag Single Documentum type tag e g 09 dm document Instead of a type tag a type name can be entered that will be replaced with the type tag automatically Values Hint template References to attributes must be enclosed in curved clips and will be replaced automatically All valid attributes of the type can be referenced All other text and invalid attributes will be copied without changes Display repeating values in Repeating values can be displayed in columns whole template line is copied for each value in the attribute or rows values will be separated by a comma If more than one repeating attribute is in the same line and displayed in column mode the individual value indices are correlated see Grid Hint for dm acl objects an dqMan 5 User Manual Page 111 Translations can translate values into readable designations They are valid global i e a translation for the attribute client capability is valid for all defined Grid Hints
45. debug mode is switched on In debug mode with Set Next Statement the next command to execute can be selected We dqMan 5 User Manual Page 47 3 3 2 The Script Navigator The Script Navigator is a directory tree for all available local drives enabling fast access to stored API and DQL Scripts The Script Navigator is available in the API Script view and the DQL Script view Script Navigator DOL Script ae C 9 Dcoumentum a Scripts ie APIScript_1 api A APIScript_2 ApiScript iP DOLScript_1 dql COOLS cript_2 dal D DOLScript_3 dql com r object id as component id com object name as component name com class id appc object name as comp docapp qc r object id as qual comp id qc class name Global Functionality as type name H E Dokumente und Einstellungen T ee T H E Inetpub H E Intel Script Log 2222 Rows returned 11 188 sec Figure 14 Script Navigator A selected script file can be opened using the return key or a double click Opened scripts are marked with a special icon These marks retain until the session window is closed Additionally the marks can be toggled with the function Mark as New and or Mark as Opened from the context menu Default settings for file extensions are api apiscript dql and dqlscript They can be configured by calling the function Filter from the context menu 3 3 3 E
46. dm cabinet with their descendants The generated script can be saved or pasted into the DQL view of the current session window for execution The first step is to select a new type for the objects from the available types in the current repository When a new type is selected from the type tree the necessary migration path is displayed at the bottom of the window The Next button will be activated n Change Object Type NNN EE Select Target Type gt Next dgsw_doc Back dgsw_doc_faq dm_docset dm_docset_run dm_email_message dm_format_preferences dm_java dm_menu_system Ej dm message container dm message archive dm plugin dm staged dm xml config dm xml custom code dm xml style sheet dm xml zone dmc jar dmc preset package dmr tref activitv m Migration Path bm config applications gt dm_document gt dm esign template Cancel Figure 31 Change Objecttype Assistant 1 ar dqMan 5 User Manual Page 102 The next step is to map all attributes from the old type that will be lost through the change in type to attributes of the new type These attributes are displayed in the left column of the attribute mapping window Selecting an attribute of the new type from the dropdown menus on the right will create the mapping between the old and the new attribute All attributes including their values that are not mapped will be lost
47. domain dmtestadmin acl name dm 450f4309880000101 authors a application type a archive Attribute Area a category a compound architecture a content type mdoc55 a controlling app a effective date a effective flag a effective label a ewpiration date a extended properties a full text a is hidden a is signed a is template a last review date nulldate a link resolved F a publish formats a retention date nulldate a special app a status a storage lype filestore Q1 group name docu Connections Connection To From Connections Area Folderpaths Templates Formats mdoc55 Lifecycle State Relations Versions 1 0 CURRENT Virt Children Wirt Parents Workflows P j dqMan 5 User Manual Page 63 313 The navigation bar offers some functions for handling objects 3 gt History of loaded objects Reload button to refresh currently displayed object P Quick Pick a fast search for objects The Quick Pick search function offers fast access to objects in the repository The top edit field expects 2 strings to begin a search The first is part of the object type to be searched in You can either enter the complete type name like dm_user or part of the type name e g user In the latter case the search will be conducted in all types containing the keyword user in the type name dm_user dm_message_user_data dm_message_route_user_data dmc workqueue user profile and dmc w
48. e during save of the script the type Typescript has to be chosen in the save file dialog At last the template has to be named and a type tag must be selected in an additional dialog Additional data sources are not allowed in type dependent script templates dqMan includes an example the ACL Create Script Script Header f ACL Create Script Template f Created 06 26 2004 Script Body Create ACL object_name create c dm acl set c l object name object name set c l description description set c l owner name dm dbo set c l acl class acl class LOOP r accessor name accessor name accessor permit accessor xpermit names grant c 1 _accessor_name _accessor permit _accessor_xpermit_names END LOOP Script Footer END ACL Create Script Please note the use of the computed attributes _accessor_name _accessor_permit and accessor xpermit names in the LOOP instruction Since computed repeating attributes are computed on demand they usually return the wrong number of contained values To ensure the correct processing of the LOOP instruction the regular attribute r accessor name of the type dm acl is included in the loop attribute list at the first position without being referenced within the loop a dqMan 5 User Manual Page 83 12 Import The import function allows importing data no documents from external sources into a repository A data import takes place in two steps F
49. e 20 Script Template Editor P alad dqMan 5 User Manual Page 75 11 1 Script Templates The basis for a script is a script template It consists of three areas header body and footer Header and footer can only contain static text It is added exactly once at the beginning and or at the end of the Script The script body is applied to each line of the data list The script contains thereby one copy of the script body for each data record The script body can contain text placeholders for data from the data list and processing instructions With the generation of the script the placeholders are replaced by data from the data list The processing instructions are removed 11 1 1 Placeholders A placeholder must exist in the source data list It consists of a column name enclosed by curved clips Examples xr object id or object name If the data list is a DQL query result list placeholders can contain any attribute of the underlying object type If this is available in the data list the value is taken from there If not the value is loaded from the repository object Inserting placeholders can be done by clicking the nsert Querycolumn item in the context menu It opens a submenu containing all available placeholders that are part of the data list Entering a left curved clip in the editor area or pressing lt strg gt lt space gt will open a select list containing all attributes of the referenced object type P
50. e 60 7T 4 The Favorites Tree Load a favorite query Clicking on a favorite with the left mouse button loads the DQL query of the favorite into the DQL command input area without executing it Run a favorite query Using the center mouse button loads the DQL query as described above but it is automatically executed Context menu Clicking on a favorite with the right mouse button opens a context menu o Run Favorite Loads the DQL query of the selected favorite and executes it immediately o Manage Favorites Opens the manage favorites Dialog as described in section 3 1 9 DQL Favorites o Expand all Expands all subfolders wa dqMan 5 User Manual Page 61 8 The Object Navigator The intention of the Object Navigator is to provide an easy fast and comprehensive access to the properties and connections like ACLs owner names relations subscriptions lifecycles workflows to any other object in the repository All properties can be edited directly in the Object Navigator Additionally you can follow connections to other objects similar to a web browser by simply clicking on the link The dependent object will then be opened in the Object Navigator Furthermore all available actions like object functions type scripts and plugins are also available making Object Navigator first choice of working with single objects There are different ways to open Object Navigator or to load new objects From anywhere withi
51. e API View Single API Commands can be executed in the API View ff G svcDEdmGlIntburgmann Intburgmann GDEWOHSDM921 on x API Command qgetfile session obiect id file namel formatli page numberl get resourcel page modifier Command oetfile c v Data Result Log API gt validate c 460 430a8000783a c temp test xls OK Done 0 010 sec E s Figure 12 The API View To execute an API command press Enter F9 or lt Shift gt lt Enter gt select Run from the Edit menu or click on the Run button in the toolbar Double clicking an element in the result log will copy the value into the clipboard If the Ctrl key is pressed while double clicking the value will be pasted into the active input control at the current cursor position immediately API commands like connect getservermap etc that do not need an active session can be executed locally To open the API command help click the Y button on the right In the help window you can search for API commands or insert a command by double click to the command input field If one object is selected in the DQL result list its x ooject id can be copied into the command input control pressing lt Alt gt lt O gt or calling the function Copy r object id from the context menu P ara dqMan 5 User Manual Page 44 The result log also offers a context menu with some special functions Dump Object Creates a dump of an r object id Open F
52. e Load Script function from the Edit menu or by dropping a file on the input area Created from DQL query results or imported data using the Script Generator Manually typing a script API scripts will be executed line by line DQL commands can consist of more than one line Therefore commands in DQL scripts must be separated either by a semicolon at the end of each command or by an extra line containing only the command go Each line beginning with the character or with is regarded as comment line P ara dqMan 5 User Manual Page 46 3 3 1 Executing Scripts Scripts can be executed either as a whole or step by step The execution can be controlled by the tool bar or the context menu Run Step F8 Run to Cursor F4 Set Next Statement F5 Stop Dump object Cut Ctrl X Copy Ctrl C Paste Ctrl V Clear v Stopon Errors b Ld Run Step Pause Stop Run Start the script Step Execute the next single command This command is highlighted If the script has not been started Step turns on the debug mode and selects the first command Pause Pause a running script and switch to the debug mode The next command will be highlighted Stop Stop the execution Additional functions are available in the context menu Run to Cursor executes all commands from the current debug position or from the beginning to the currently selected line The command in the current line is highlighted and the
53. e Object Type Auto escape of DQL reserved words DQL History Functions and Favorites Repository names are replaced by repository IDs for assigning DQL history functions and favorites to certain repositories Compare Data Autofind function for corresponding attribute Import from File Ignore Empty Lines option for import from CSV and clipboard Wa dqMan 5 User Manual Page 14 1 4 3 Xtended Edition Repository Navigator Registered Tables can be listed in types tab Copy Registered Table Available from Repository Navigator Name of target table can be changed Hide system tables function on table selection page Auto escape of DQL reserved words Auto split SQL Create Table statements if too long Attribute Copy Script Check for references to source object type in value assistances Auto escape of DQL reserved words Attribute Editor Auto escape of DQL reserved words Object Navigator Quick Picks with Dropdown and History Quick Picks result list reduced to unique objects Copy values with doubleclick Add to Compare List Function added Destroy Folder Function recursive added Create ticketed user session Function added dqMan Analyzer Template queries support cached queries for value assistances Analyzes can be limited to repositories by supplying a repository ID dqMan 5 User Manual Page 15 ia 1 5 Installing dqMan on a removable media dqMan can be used from a removable medium like an USB stick To install dqMa
54. eR nitelteedeeretienteriiteses enteidertesetesved ee aa Ea re rnb e r eer pie ebd 129 16 6 1 Docbroker Availability us at eee tute votre eae eta ade eure Denn to er Eee DUE VES SESS NEVER VAR 129 16 0 2 Docbasic Interprete snarere innii pte te oet E uiae taie HER EER e te ou Ev Doe e NEU ERE EPIO 130 160 3 Ur T NR aA 130 17 APPENDIX A UNSUPPORTED COMMANDS AND DQMAN SYNTAX EXTENSIONS 131 17 1 The API Command filename eese n n e n nen nnne nnn nnn nnn nnn n nnn nnn anas a nana nana nena 131 17 2 The DQL Administration Method set session dd locale ssseeeeerene 131 17 3 The DQL Administration Method count sessions eese ener nnne 132 17 4 Script Commands and Variables essent nennen een eene eene 132 18 APPENDIX B PLUGINS sissies ssscsvsssissescsce Savcscssnsteiseoxscsssusstesacscccvacssecsssctecesssstcvasvascccensessssessccdssvessessse 133 18 1 The DMCL INI dfc Properties Editor esee enne nennen enne 134 18 2 The ACT MIeWORT arinean ninen ronnan sane deeraondans cance aceto ein canst dee qeu ee cates qseresednsecaaes OEE OEREN 136 18 3 nubi PAS He 140 18 4 Content RestOfe ete iet eerte eee denies eese deese ate aenea deine seem deed uae ense dion 142 P Ar dqMan 5 User Manual Page 5 0 System Requirements Operation System All current Windows plattforms Please make
55. ect title value 11 5 Adding Data Sources A script can be generated from 2 data sources simultaneously The additional source can be another DQL query result or a data list The additional data source can be opened clicking on the Add Source button of the toolbar A submenu appears that contains all possible data lists The additional data source must be joined to the main data source to allow correlation of the data records At least one column of the main data source must be joined to one column of the additional data source an dqMan 5 User Manual Page 80 Source Columns r creation date r modify date r object id r object type resolution label Joined Columns log entry object name r creation date r modify date r object id r object type resolution label Figure 21 Joining columns To join to columns select the columns in both lists and click on the button Join Columns can also be dragged and dropped on the opposite list To delete a join use the context menu of the Selected Columns grid After successful joining placeholders can be added to the script template from the context menu or value lists They look like data object name P A dqMan 5 User Manual Page 81 11 6 Generating a Script The script can be generated from the template by clicking on the Generate button During generation the button Stop is activated to stop the generation process and return to the script temp
56. ection of the object type and the object name are mandatory Assigning a content file from the local file system or an ACL is optional o Destroy Cabinet Recursively destroys all subfolders of the currently selected folder including all contained objects If these objects are linked to more than one folder only the links can be destroyed by user choice o Tree Options Opens the appropriate page of the options dialog to manage repository tree settings Wa dqMan 5 User Manual Page 58 7 2 The Object Type Registered Table Tree Creation of a DQL query for type objects or registered tables Clicking on an object type table with the left mouse button directs dqMan to create a DQL query for objects of the selected type rows of the selected registered table using the Default Query Template It is placed in the DQL command input area without executing it Viewing the objects Using the center mouse button creates a DQL as described above but it is automatically executed Context menu Clicking on an object type table with the right mouse button opens a context menu o Expand recursive Expands all subtypes o Dump type object Creates a dump of the currently selected type o List of query templates List of template queries defined in the options dialog Templates marked with a green arrow will be immediately executed The others generate a DQL query only and place it in the DQL command area o User Functions List of user f
57. ed SIDS id c dm document where object name like a assigns the result of the API command to the variable ID Concatenating values Values can be concatenated in two ways oe ID Add this text oe ID oe ID Add this text ar dqMan 5 User Manual Page 49 Usage To use a variable insert it at the appropriate position in the API command get c ID object name Query variable contents While executing the script in debug mode values of variables can be queried at any time Click on the variable and wait for the hint to appear Define Test dm document Tests id c dm type where name lt gt Tests YoTest gt 030041e980000164 Figure 15 Querying Variable Contents 3 3 5 Using Script Commands in API Scripts Script commands are additional commands that expand the functionality of API scripts or object functions Using script commands in API scripts is not compatible to the Documentum API language Scripts with script commands cannot be executed by other applications Available script commands are SStopOnErrors on off Sets the error handling behaviour during script execution SPrint text Prints the text and or the values of variables into the script log SSleep time Pauses script execution for lt time gt milliseconds SLoop lt collection identifier gt Start of a loop through a collection Loop lt attribute name object id Start of
58. ed unchanged fields will be ignored E g all groups can be assigned an extended permission without changing the basic permissions or the values of the other extended permissions Add permissions al dqMan 5 User Manual The Add button opens a dialog to add one or more new permissions If an existing permission was selected before the settings of this permission will be copied to the dialog as default User Group Search test Filter fan User test 05 rm business sector test 05 rm claim initiator test 05 rm claim manager test 05 rm cqm test 05 rm general manager test 05 rm process coordinator test 05 rm regional management test 05 rm service center test 05 rm technical sales yg test 05 rm top management team test 06 rm business sector Permissions Version X V Execute Procedure Change Permit Change Location Change State Delete Object Figure 45 Adding Permissions Wa dqMan 5 User Manual Page 138 To search for a group or user an expression begins with can be entered into the search field The Filter limits the displayed users and or groups All All users and groups User Users only Group Groups only Additionally available for Template ACLs Users and groups Users and groups Qualified aliases Qualified aliases only Unqualified aliases Unqualified aliases only Multiple members can be selected from the list and will be added at once with identical permi
59. ed To track changes a tail view can be opened from the View menu In both cases a submenu with the recently opened files is displayed To open a new file the item Open can be selected 10 1 File View This function displays the entire contents of a file Use the context menu to access additional functions like refresh search dump object or word wrap settings 10 2 Tail View The tail view shows a configurable number of lines from the file tail It is refreshed regularly The content menu offers specific functions for this viewer Pause Continue Pauses the refresh Tail length xxx Number of displayed lines of text Interval xx seconds Refresh interval in seconds Wordwrap Turns on or off automatic wrapping of lines exceeding screen width an dqMan 5 User Manual Page 74 11 The Script Generator With this tool DQL API Docbasic or other scripts can be generated from a data list either a DQL query result list or an external data list It is available from the context menu of the list calling the function Generate Script F Ee A O MB gt 0 gt ww gt MEK Add Source Generate Siap Finar Script type DQL Script Translate Booleans V Mask single quotes update dm document objects set titel acl name where r object id r object id r alias set id l r aspect name T composite label Please enter script template Figur
60. eesseceeeeeacecseneeeaaeceeeeenaecseneeeaeceneeeenaeees 21 3 1 2 Syntax ASSISTANCE iu nee i E E E A O E R E E 21 3 1 3 Query by E b l 2a n RE DER ano mtn aun e 22 3 1 4 The Result list ecu DETROIT EE elitti uite t TIEREN 23 3 1 5 The Result List Inline Editor eee eese eene tenete enne nent entren tenente tenter en 26 3 1 6 The Attribute Filler e este ue HO RR E RISE ERU E S E SCORE TIRE EEE 28 3b 7 TANI 30 3 1 8 The Describe Command eese eese esee eene nennen Ee en tenente en tenete entente en an aa 31 3 1 9 DOL nv P M 33 3 0 Favorite MONI M M 36 BAL Template Queries uet erdt ir tie eie Pn eic eee EP Care aS NUM Era nf orate ERES 37 3 1 12 Formating DQL Queries eese eene enne enne nente netten ennnet nene en nn ee tene enn en tenere 40 34 13 Repeated Queries siessen err te ir eicere elite EEEE i RU ERE RE ratae ates 42 32 The APD VIeW edere rre ute pes tee Dai expe eet ee bte sspe starten ESERE laeua Une uae vero eo eo Een 43 3 3 The DOL and API Script View eee te critt te Heute Lo PR Prep eda ko bee Ende ee LE E EE S EEE Er as 45 3 3 J Executing m 46 3 9 2 The Script Navigator isisisi te anni teen entente nne een nennen nete EEE nnne teen nennen nennen enne 47 3 3 3 Error Handling it o radere ttg eren tek e ERES E OS RUM
61. eral options are available i Paste Permissions O Permissions already exist The ACL already contains a permission for user group dm_owner Do you want to replace or merge the existing permission Delete Execute Procedure Change Location with the pasted permission Delete Execute Procedure Change Location Figure 46 Copy Permissions Replace The old permission is deleted and replaced by the new one Merge Permissions are merged meaning the higher basic permission is assigned and the extended permissions are aggregated Skip This permission will not be pasted P Ar dqMan 5 User Manual Page 140 18 3 dqMan Analyzer dqMan Analyzer is intended to provide a simple and fast way to generate regular analysis of repository data The plugin itself is used to execute a batch of predefined queries The results are then stored to an Excel template which does the analysis An analysis consists of two files an XML where the queries are described as well as an Excel template It is very useful to set the read only flag for the Excel template to prevent overwriting it by accident The files must be stored in the Analyzer sub directory of the dqMan home directory c program files dqMan All XMLs will be read on start up and all available analysis reports will be placed in an additional main menu called Analyzer There are two preinstalled examples available a simple UserStatistics and a c
62. ettings BENBINENESIS Data Mapping Value Lists Apply Generate Script gt One Two Three Four oP DA dqMan 5 User Manual Page 70 Manage value mapping even with copy amp paste of entire lists and with all locales in one dialog I CT CREEK Attribute settings Value Lists Data Mapping Value Mapping Generate Script Cancel Edit value assistance content order fixed lists or execute DQL queries to control results Value Assistance Conditions OK Cancel E Value Assistance Fixed List DQL Query n mU Uu I g Value Assistance Fixed List DAL Query OK I Select distinct object name from dm acl order by 1 gt T Listis complete Sa Allow caching Query Attribute dm 450f4303800015b3 dm_450f430a800015b8 dm_450f430a800015b9 dm_450f430a800015ba 4 a dqMan 5 User Manual Page 71 Copy Attribute This function creates a script from existing attributes It can be used to copy attributes between different object types or between repositories if Attribute Create Script Settings Select target type locales to copy attribute property areas and publishing options Source type dm acl Targettype new type x Locales vien vi de Attribute Properties
63. fault value madmin Mandatory v Value Assistance Type DaL query Y Values select distinct owner_name from dm_document order by 1 r s Check Syntax Figure 11 Template Field options Name Name of the placeholder Label Caption displayed in the input dialog If no label is available the name will be displayed Default Value The default value shown in the input control It is valid until another value is entered or selected Mandatory Check this box if it is a mandatory field Use cached query If checked the result of the DQL query used to fill the value assistance will be cached to improve performance but changes to the underlying values will be ignored Select Refresh Value lists from the Session menu to clear the cache P alad dqMan 5 User Manual Page 39 Value List Type To assist the user different types of value lists are available None Fixed List DQL Query Date Picker File Open Dialog Directory Selector Cabinet Folder Selector No value list A list with fixed values that must be predefined in the control Values A DQL query that fills the list dynamically Displays a date picker control Opens a file open dialog A list of available file types can be defined in the control Values Allows selection of a directory from the local file system Allows selection of a cabinet or folder from the currently connected repository If the result of a
64. g and waits until the editor is closed Refresh Column Name Column Name Refreshes the DQL result list by fetching the values of all attributes in the column list from the repository If the char was specified as column list all currently selected columns are refreshed RemoveLine Removes the currently processed line from the DQL result grid without destroying the Documentum object ShellExecute lt Program gt Parameter Starts the lt Program gt with the supplied lt Parameters gt and returns control to the dqMan without waiting for its termination The first parameter is the executable program The number of parameters is free They must be separated by spaces ShellExecuteAndWait lt Program gt Parameter Like ShellExecute but dqMan waits for the program to finish its execution Sleep lt time gt Pauses the function execution for lt time gt milliseconds Loop lt collection identifier gt Start of a loop through a collection A ara dqMan 5 User Manual Page 126 Loop attribute name object id Start of a loop through the values of the repeating attribute from the object identified by the ID object id If the object id is not supplied the ID of the currently processed object from the result list is used EndLoop Marks the end of the loop FetchObject lt r_object_id gt Opens the Object Navigator and loads the object identified by r_object_id Example for a collection lo
65. generated script can be saved or pasted into the DQL view of an existing or new session window for execution Selection of registered tables and operations r Copy registered obe Target Type iw Create table creation script iw Register table in target system Iw Copy content Registered Table dm queue dm queue dm replica catalog dm replica catal dm replica delete dm replica delete dm replica delete info dbo dm replica delet dm replication events dbo dm replication e dm scope config r dbo dm scope config dm scope config s dbo dm scope config dm store s dbo dm store s dm sysobjects dbo dm sysobjects dm tasks all dm tasks all Hide system tables Cancel Figure 28 Copy Registered Table Assistant 1 P dqMan 5 User Manual Page 97 aa On the first page the registered table and at least one operation must be selected Available operations are Create table creation script Creates the table in the database of the target repository The table must not exist in the target database Register table in target system Creates Register Table commands that will copy the Documentum registration of the source table The table must exist in the target database Copy content Generates a script to copy the data from the source to the target table The table must exist in the target database and it must be registered in the target repository The Hide system ta
66. he API command to the variable ID Concatenating values Values can be concatenated in two ways oo ID Add this text oe ID ID Add this text Usage To use a variable insert it at the appropriate position in the API command get c ID object name Predefined variables are result This variable saves the result to be returned e g S result dump c r object id If result does not exist within the API sequence the result of the last executed API command will be returned CrlLf This is a constant containing a carriage return and a line feed It can be used for result formatting Clipboard This variable allows to exchange text data with the clipboard If this variable is used the current content of the clipboard is pasted If a value is assigned it will be stored in the clipboard Also concatenation is possible Clipboard Any text Clipboard and more P Sr dqMan 5 User Manual Page 125 Example set ACL name set c r object id acl name SACL Name Set ACL Domain set c r_ object _id acl_ domain SACL Domains Save save c r object id Script Commands Script commands extend the functionality of an object function Placeholders or variables can be used as parameters They will be replaced by their values before executing the script command Available script commands are it EditFile Filename Opens the currently processed object for editin
67. his Software 2 If license fees are raised the licensee shall have the right to extraordinary termination without notice 3 Place of performance is Braunschweig Germany 4 This agreement is subject to Federal German Law under exclusion of the United Nations Convention of Contracts for the International Sale of Goods CISG 5 Place of venue is Braunschweig Germany inasmuch as a valid agreement can be reached to that effect VII Severability Clause In the event that one of the above terms is or becomes invalid the parties shall agree to an effective settlement that best approximates the original economic intent dqMan 5 User Manual Page 9 ME 1 2 Supported Documentum Clients dqMan supports two Documentum clients dmcl40 dll is a native dmcl client It can be used for Documentum 4 and 5 content servers As Documentum 6 is fully compatible to clients of the edition 5 it can be used for Documentum 6 as well Please make sure that the dmcl40 dll from any Documentum 5 Edition is installed and reachable by system path Connecting to Documentum using dmcl40 dll will bypass installed TBOs dmcl dll is a dmcl emulator installed with Documentum 6 translating API commands to dfc Therefore a valid Documentum DFC 6 x must be installed The dmcl dll must be reachable by system path Connecting to Documentum using dmcl dll with dfc will trigger TBOs the same way as normal dfc commands do On start up dqMan searches at fi
68. ic value assistance or with manually configured values from the file dgManValuelists xml Repeating Attributes Repeating attributes can be edited within a small sub grid As DQL results do not show the correct order of repeating attribute values the contents of this list can differ from the displayed values in the result list The sub grid offers an own context menu for inserting deleting or reordering values of the repeating attribute Multiple Single Attributes If the result list contains more than one result a single attribute of multiple objects can be edited simultaneously Select more than one value in a column and start the editor Multiple Single Attribute Editor an dqMan 5 User Manual Page 27 Linked Repeating Attributes Linked repeating attributes of one object such as r accessor name r _accessor_permit and r accessor xpermit of dm acl objects can be edited in a multicolumn sub grid Select more than one column of repeating attributes and start the editor dm owner 7 9 docu 5 3 ia Jam world 2 0 dm_owner 131072 2 admingroup 131072 cad user 6 o cad_admin 131072 0S cad user 0 06 cad user 0 12_cad_user 0 14 cad user 0 9115 cad user o zl dm world 3 o dm owner 7 9 a dqMan 5 User Manual Page 28 3 1 6 The Attribute Filter By using the attribute filter query results can be filtered by the queried values It can be opened for each column Filters can be used for mul
69. ile system Allows selection of a cabinet or folder from the currently connected repository A single line API command like id c dm acl This command can reference result list columns by column names in curved clips e g r object id It can also reference global variables with a lower index than itself