Export the Results of a Static Lookup Using XOG
search cancel

Export the Results of a Static Lookup Using XOG


Article ID: 264313


Updated On:


Clarity PPM On Premise


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


Release : 16.0.1


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.


    <?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>

  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.

          <!-- Static lookup -->
        <Filter name="code" criteria="EQUALS">SEC_OBJECT_TYPE</Filter>

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