Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
the_query_details_menu [2015/04/07 21:57]
14.202.105.155
the_query_details_menu [2018/05/04 21:40] (current)
Line 60: Line 60:
 One of the key features of Reportico is to allow criteria selected by the user to be included witin the query statement. The best way of achieving this is to use the curly bracket "​{criterianame}"​ notation to link criteria in at report generation time. Alternatively this linking in is configured within the criteria item itself by filing in the Query Table Name and Query Column Name fields in the relevant criteria section, however linking within the SQL using this method is always preferable because it allows for more complex ways of using the crtieria. One of the key features of Reportico is to allow criteria selected by the user to be included witin the query statement. The best way of achieving this is to use the curly bracket "​{criterianame}"​ notation to link criteria in at report generation time. Alternatively this linking in is configured within the criteria item itself by filing in the Query Table Name and Query Column Name fields in the relevant criteria section, however linking within the SQL using this method is always preferable because it allows for more complex ways of using the crtieria.
  
-To link a criteria item in, just construct an where clause statement for the criteria, specifying the namke of the criteria .. e.g.+To link a criteria item in, just construct an where clause statement for the criteria, specifying the name of the criteria .. e.g.
 <​code>​ <​code>​
     SELECT x      SELECT x 
  • the_query_details_menu.txt
  • Last modified: 2018/05/04 21:40
  • (external edit)