Hello Experts,
I am very new to B1if. We have an existing scenario which fetches all Items from the OITM Table. Now we have a requirement in which we need to filter the set of items depending on some URL parameters provided.
Following are the configurations and Test example of the existing Scenario.
1) Inbound Channel Config:

2) Final Transformation:
</xsl:template><xsl:template name="transform"> <xsl:attribute name="pltype">xml</xsl:attribute> <GetProductList> <ProductList> <xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom1']/jdbc:ResultSet/jdbc:Row"> <row> <ProductCode> <xsl:value-of select="./jdbc:ItemCode"></xsl:value-of> </ProductCode> <ProductName> <xsl:value-of select="./jdbc:ItemName"></xsl:value-of> </ProductName> </row> </xsl:for-each> </ProductList> </GetProductList> </xsl:template></xsl:stylesheet>
3) Test Definition

4) Debug

5) SQL Inbound Document from the above debug

The problem is I cannot find the ItemCode value that is passed during testing in the SQL Inbound Document. I have followed all the steps mentioned in the Online help section of B1. I have also done extensive search on the community to find something near to this scenario but could not find one.
My idea is, to get the URL parameter in a variable and pass it to the SQL Call like below:
#SELECT ItemCode, ItemName FROM OITM WHERE ItemCode=’$ItemNo’
I would be very thankful if you can please show me the right path to pass multiple URL parameters to a scenario and use them in a SQL atom.
I know it may be a very simple thing but as I said earlier I am very new to this, thus any help is much appreciated.
Thanks a lot in advance.
Regards,
Paul