Clarity

Expand all | Collapse all

Unable to XOG in under the costume lookup field

  • 1.  Unable to XOG in under the costume lookup field

    Posted 08-07-2020 09:56 AM
    Hi Team,

    I am unable to XOG in, from one of the "Region" column (hard coded value)  to the dynamic lookup field (ppd_country) 

    As per below screen shot, I want to enter Region's value (EMEA) in the Country field (dynamic lookup)

    I am not getting any error message or nothing happening via below XOG

    Gel Code:


     <core:otherwise>
     <core:otherwise>      <core:forEach indexVar="rowCounter" items="${qryResults1.rows}" var="row">   
        <core:set value="${row.get('forecast_code')}" var="v_instance_code"/>
      <!-- country  --> <core:set value="${row.get('ppd_region')}" var="V_ppd_region"/>
    <core:set value="${row.get('partition')}" var="v_partition"/>
    <core:set value="${row.get('unit_code')}" var="v_unit_code"/>   
          <core:set value="${row.get('project_code')}" var="v_project_code"/>   
        <gel:log level="INFO">${V_ppd_region}</gel:log>     
      <gel:parse var="v_xog">       
      <!--variable to parse the xml -->       
      <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd">   
            <Header action="write" externalSource="NIKU" objectType="customObjectInstance" version="${clarity_version}"/>            <customObjectInstances objectCode="PPD_UNIT_FORECAST">     
            <instance grandparentInstanceCode="${v_project_code}" grandparentObjectCode="project" instanceCode="${v_instance_code}" objectCode="PPD_UNIT_FORECAST" parentInstanceCode="${v_unit_code}" parentObjectCode="ppd_unit">    
        <CustomInformation>             
        <ColumnValue name="ppd_country">${V_ppd_region}</ColumnValue>         
            <ColumnValue name="partition_code">Clinical</ColumnValue>
    </CustomInformation>  
                </instance>   
            </customObjectInstances>          </NikuDataBus>     
      </gel:parse>   
        <core:choose>

    Even I tried to capture the value of the PPD_Region above in the bold value     <gel:log level="INFO">${V_ppd_region}</gel:log> and it is showing value but unable to print in the PPD Country column from the fron end

    Please do the needful.


  • 2.  RE: Unable to XOG in under the costume lookup field

    Posted 08-07-2020 10:19 AM
    Edited by David Morton 08-07-2020 10:20 AM
    A couple of observations;

    1 - To see "XOG errors" in your GEL script you would need to output the result of your XOG call (the XOG itself does not necessarily raise an error as it completes OK, it just completes with a error message contained in its output)

    2 - You can see what XOG output you would receive by using a simple XOG-client (rather than GEL) - i.e. work out what the contents of your v_xog is and use that in a simple XOG client - that should then tell you the XOG output.

    3 - I would GUESS that the V_ppd_region you are using is not the expected one - but you would not be able to verify that until you look at the XOG output


  • 3.  RE: Unable to XOG in under the costume lookup field

    Posted 08-07-2020 11:34 AM
    Here are the input and out put of the Gel :

    <?xml version="1.0" encoding="UTF-8"?> <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd"> <Header action="write" externalSource="NIKU" objectType="customObjectInstance" version="15.7.0.212"/> <customObjectInstances objectCode="PPD_UNIT_FORECAST"> <instance grandparentInstanceCode="PRJ-008107" grandparentObjectCode="project" instanceCode="01779445" objectCode="PPD_UNIT_FORECAST" parentInstanceCode="EMEA-AX01" parentObjectCode="ppd_unit"> <CustomInformation> <ColumnValue name="ppd_country">EMEA</ColumnValue> <ColumnValue name="partition_code">Clinical</ColumnValue> </CustomInformation> </instance> </customObjectInstances> </NikuDataBus>


    XOGoutcome = SUCCESS
    XOGtotalrecords = 1
    XOGinsertedrecords = 0
    XOGupdatedrecords = 1
    XOGfailurerecords = 0


    XOG_INPUT = <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_customObjectInstance.xsd"> <Header action="write" externalSource="NIKU" objectType="customObjectInstance" version="15.7.0.212"/> <customObjectInstances objectCode="PPD_UNIT_FORECAST"> <instance grandparentInstanceCode="PRJ-009991" grandparentObjectCode="project" instanceCode="01855888" objectCode="PPD_UNIT_FORECAST" parentInstanceCode="APAC-ZCOSTS1" parentObjectCode="ppd_unit"> <CustomInformation> <ColumnValue name="ppd_country">APAC</ColumnValue> </CustomInformation> </instance> </customObjectInstances> </NikuDataBus>

    XOG_OUTPUT = <XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd"> <Object type="customObjectInstance"/> <Status elapsedTime="0.069 seconds" state="SUCCESS"/> <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="1"/> <Records/> </XOGOutput>

    BPM-0546: Custom script has completed.



  • 4.  RE: Unable to XOG in under the costume lookup field

    Posted 08-07-2020 11:44 AM
    Assuming "APAC" is a valid entry for the lookup associated with that ppd_country attribute then that should have updated (updatedRecords="1")

    Sorry, not sure I can help any if there is no message to go on ; might have to raise a call with support? :(


  • 5.  RE: Unable to XOG in under the costume lookup field

    Posted 08-07-2020 12:38 PM
    As per your suggestion: Might have to raise a call with support?

    So would it be a webex call or same chat like this? or any number where I can call for this?


  • 6.  RE: Unable to XOG in under the costume lookup field

    Posted 08-08-2020 07:34 AM
    Hello!  You've shared the input and output XOG, but not the configuration of the lookup.  Can you please post that here as well?


  • 7.  RE: Unable to XOG in under the costume lookup field

    Posted 08-17-2020 12:14 PM
    Sorry for the delay TRicherdson,

    Which kind of configuration you are asking please
    It is a dynamic lookup
    Query based lookup


  • 8.  RE: Unable to XOG in under the costume lookup field

    Posted 23 days ago
    Hi Richerdson,

    Could you please suggest further on the last updated comment.