Dynamic DataSource Parameters

 Top  Previous  Next

MScript functions can be used within data source parameters to make them dynamic.

Please refer to {INSTALL_DIR} \lib\sys\moremotion\docs\manual\index.html
                     "Scripting with MScript" topic for more information.

For example, using MScript functions, you shape your database query according to user's input.

Example 1:

Request:

dynamic_parms_input1

Query Parameter of Data source:

SELECT * FROM products WHERE CATEGORY = '@vof(i:category)'

 

Example 2:

Request:

display.doms?pg=ProductDetails&product_id=P0017&fields=A,B,C

 

 

Query parameter of data source:

 

  @doif(fields = '')

    SELECT * FROM products WHERE PRODUCT_ID = @vof(product_id)

  @doelse()

    SELECT @vof(fields) FROM products WHERE PRODUCT_ID = @vof(product_id)

  @doend()