Export the Results of a Static Lookup Using XOG

Products

• Clarity PPM On Premise

Issue/Introduction

How to Use XOG to Export the Values of a Static Lookup.

Environment

Release : 16.0.1

Resolution

XOG: Please follow the steps 

1. Go to XOG installation directory --> xogclient --> content_pack_read.xml
2. Please make a copy of this file and move it to --> bin directory
3. Now, edit the file using Notepad++.
   (This file can help fetch the values of your lookup.)
4. Remove all the unnecessary tags, since the request is about static lookups... here is an example.
   
   Code:
   
   <?xml version="1.0" encoding="UTF-8"?>
   <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
    <Header version="8.0" action="read" objectType="contentPack" externalSource="NIKU">
     <!-- the contentType is used to determine which filter goes where -->
     <args contentType="job_definition" name="order_by_1" value="code"/>
     <args contentType="menu" name="order_by_1" value="code"/>
     <args contentType="view" name="order_by_1" value="code"/>
     <args contentType="process" name="order_by_1" value="code"/>
     <args contentType="object" name="order_by_1" value="code"/>
    </Header> <LookupQuery>
      <!-- Static lookup -->
     <Filter name="code" criteria="EQUALS">SEC_OBJECT_TYPE</Filter>
    </LookupQuery></NikuDataBus>
   
   
5. Please rename the "SEC_OBJECT_TYPE" with the lookup ID's that you want to pass in the code.
   
   
   
   
6. If you like to extract more than 1 or more lookup values, copy the below code next to the query and rename the SEC_OBJECT_TYPE with your lookup ID.
   
     <LookupQuery>
         <!-- Static lookup -->
       <Filter name="code" criteria="EQUALS">SEC_OBJECT_TYPE</Filter>
       
     </LookupQuery>

NOTE: This approach will give you all the details of your lookup and 1 among them is your lookup values