2 Replies Latest reply on Nov 6, 2019 5:56 AM by Rakesh Rajasekar

    BMC Attrium Orchestrator Date field not fetching data

    Rakesh Rajasekar
      Share This:

      Dear All,

       

      Am trying to query a form using BAO but date field is not capturing any value,

       

      below is my XSLT ,

       

      <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">

        <xsl:output indent="no" />

        <xsl:template match="/">

          <request-data>

            <remedy-action>

              <schema>

                <xsl:text disable-output-escaping="no">UTS:WOS:Events</xsl:text>

              </schema>

              <query>

                <xsl:text disable-output-escaping="no">'536870918'="0" AND '536870929' ="START"</xsl:text>

              </query>

              <fields>

                <field>

                  <xsl:text disable-output-escaping="no">Infrastructure Change ID</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Event Name</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Event ID</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Change Status</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Status Reason</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Change Template Name</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">ACC_Worflow</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">ACC_Source</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Scheduled Start Date</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Release ID</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Release Source</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Release Milestone</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Release Status</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Release Template Name</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">ACC_xAKTA_Relevant</xsl:text>

                </field>

                <field>

                  <xsl:text disable-output-escaping="no">Change Modified Date</xsl:text>

                </field>

              </fields>

            </remedy-action>

          </request-data>

        </xsl:template>

      </xsl:stylesheet>

       

      and the results is below,

       

      entry id="EV0000000000243">

            <field name="Event ID">EV0000000000243</field>

            <field name="Infrastructure Change ID">CRQ000002063512</field>

            <field name="Event Name">Infrastructure Change Update</field>

            <field name="Change Status">1</field>

            <field name="Status Reason">5000</field>

            <field name="Change Template Name">BO-Konfig/PaC_Standard</field>

            <field name="ACC_Worflow">Change</field>

            <field name="ACC_Source">1</field>

            <field name="Scheduled Start Date" />

            <field name="Release ID">RLM000000409847</field>

            <field name="Release Source">1</field>

            <field name="Release Milestone">20</field>

            <field name="Release Status">4000</field>

            <field name="Release Template Name">change:Node-B:Vendor_change:swap out</field>

            <field name="ACC_xAKTA_Relevant">0</field>

            <field name="Change Modified Date" />