Export the Results of a Static Lookup Using XOG
search cancel

Export the Results of a Static Lookup Using XOG

book

Article ID: 264313

calendar_today

Updated On:

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.

    https://api-broadcom-ca.wolkenservicedesk.com/attachment/get_attachment_content?uniqueFileId=YUs6mTgBoAIe0RufHkqC6g==

  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