CyberStore Ecommerce 2023 Documentation
SORQID

See the example of INVQSE code below:

<?xml version="1.0" encoding="utf-8" ?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:param name="SerialNumber" />
  <xsl:param name="StockCode" />
  <xsl:param name="Warehouse" />
  <xsl:param name="Location" />
  <xsl:param name="CustomerNumber" />
  <xsl:param name="ExpiryDate" />
  <xsl:param name="ScrapDate" />
  <xsl:param name="DateCreated" />
  <xsl:param name="EntryDate" />
  <xsl:param name="IncludeTransactions" />
    
  <xsl:template match="/">
    <Query xmlns:xsd="http://www.w3.org/2001/XMLSchema-instance" xsd:noNamespaceSchemaLocation="INVQSE.XSD">
      <Option>
        <Sequence>S</Sequence>
        <IncludeTransactions><xsl:value-of select="$IncludeTransactions" /></IncludeTransactions>
        <IncludeZeroQtyOnHand>Y</IncludeZeroQtyOnHand>
        <IncludeOnlyUnitsInService>N</IncludeOnlyUnitsInService>
        <IncludeOnlyUnitsOnLoan>N</IncludeOnlyUnitsOnLoan>
        <IncludeOnlyUnitsAtDepot>N</IncludeOnlyUnitsAtDepot>
        <XslStylesheet/>
      </Option>
      <Filter>
        <xsl:if test="$StockCode!=''">
          <xsl:element name="StockCode">
            <xsl:attribute name="FilterType">L</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$StockCode" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
        <xsl:if test="$Warehouse!=''">
          <xsl:element name="Warehouse">
            <xsl:attribute name="FilterType">L</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$Warehouse" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
        <xsl:if test="$Location!=''">
          <xsl:element name="Location">
            <xsl:attribute name="FilterType">L</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$Location" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
        <xsl:if test="$SerialNumber!=''">
          <xsl:element name="SerialNumber">
            <xsl:attribute name="FilterType">L</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$SerialNumber" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
        <xsl:if test="$ExpiryDate!=''">
          <xsl:element name="ExpiryDate">
            <xsl:attribute name="FilterType">L</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$ExpiryDate" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
        <xsl:if test="$ScrapDate!=''">
          <xsl:element name="ScrapDate">
            <xsl:attribute name="FilterType">L</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$ScrapDate" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
        <xsl:if test="$DateCreated!=''">
          <xsl:element name="DateCreated">
            <xsl:attribute name="FilterType">L</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$DateCreated" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
        <xsl:if test="$EntryDate!=''">
          <xsl:element name="EntryDate">
            <xsl:attribute name="FilterType">L</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$EntryDate" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
        <xsl:if test="$CustomerNumber!=''">
          <xsl:element name="Customer">
            <xsl:attribute name="FilterType">S</xsl:attribute>
            <xsl:attribute name="FilterValue">
              <xsl:value-of select="$CustomerNumber" />
            </xsl:attribute>
          </xsl:element>
        </xsl:if>
      </Filter>
    </Query>
  </xsl:template>
</xsl:stylesheet>