XMLQuery Mode

With this mode, the URL query and associated style sheet conversion is dynamically constructed by the connector using the URL and Transform parameters. For example, the URL is http://livestockdata.com/StockPrices?Ticker=IBM and the Transform is http://localhost/Styles/StocksToIlluminator.xsl or C:\Inetpub\wwwroot\Styles\StocksToIlluminator.xsl. The URL contains the source file, and the Transform contains the fully qualified style sheet reference.

Date Placeholders

You use the StartDate (SD) and EndDate (ED) placeholders to insert the date and time values into the XML query string at runtime. These dates are calculated by the system based on the query parameters. You use these placeholders in the JoinExpr or FilterExpr parameters in Query mode and the Query or QueryParams parameters in FixedQuery or Command mode. For example, http://weatherserver?getHistoricalRainfall&PeriodBegin=[SD]&PeriodEnd=[ED].

The system recognizes queries with date placeholders as time-based queries and enables the time navigation bar on related display applets.

Parameter Placeholders

You insert parameter values into an XML query at runtime using parameter placeholders [Param.1] to [Param.32].

For example, if you use an XML query to return open work orders for a department from the ERP system, you could use the following URL:

http://erpsystem?method=output&requesttype=AB_OpenOrd&WorkCenter=[Param.1]&WorkStatus=Open.