The options you can change are:<\/p>\n
Note: Enabling the Preload List of Values option will load the list of values from the database, which can take a while depending of how much data is retrieved.<\/p>\n
To configure the list of values for a Parameter, you need to open the Parameter Customization window, enable the Option Show Values option and click on Configure List Values, this will open the Query Builder so you can create the Query that will bring the values for the Parameter.<\/p>\n
Note: The values for a Parameter must come from the same Data Connection.<\/p>\n
With this Query Builder you have most of the options available from the regular Query Builder, so we recommend you to review the documentation about the Query Builder to know how to use it.<\/p>\n
When you configure the list of Parameter values, you have the option to add a description to it, so for example, if your Parameter is for numeric customer ids, you can add a description to know to what customer the id refers to.<\/p>\n
To show a Cover Value, just add a second column to your Query and verify that the Output column in the Grid Pane is enabled, this way you’ll see both the value and the description when asked for the value of the Parameter.<\/p>\n
If you don’t want to see the value passed to the Query, you can enable the Show Cover Values Only option in the Parameter Customization window.<\/p>\n
When you configure the list of Parameter values you can make that the value of one Parameter dependent on the value of another one.<\/p>\n
For example, having a Parameter for cities and countries and when you select one country, you see only the cities that depend to that country.<\/p>\n
To enable this option, you need to insert both Parameters in the Query and customize the one whose value will depend on the other (In our example Cities will depend on the value of Country, so we customize Cities), change the List of Values (Configure List Values) then in the Query Builder add the column of the main Parameter (Countries), open the Criteria Expression Builder and add the Parameter with the same name as in the main Query (For example, @Param1).<\/p>\n
This way, when asked for the value of the Parameter (City) it will be filtered by the value of the previously asked Parameter (Country).<\/p>\n
Note: The order of the Parameters in the main Query is important, as Parameters are asked in the order they appear on the main Query.<\/p>\n
User – User Group Variables are special Variables that you can use in your Query to show distinct data to different users, depending who is logged in and the user group(s) he belongs to.<\/p>\n
User Variables change its value depending of the currently logged in user.<\/p>\n
To configure those Variables, go to Variables->User Variables.<\/p>\n
User Group Variables change its value depending of the Group or Groups the currently logged in User belongs to.<\/p>\n
To configure them, go to Variables->User Group Variables.<\/p>\n
Configuration of both kind of Variables is similar.<\/p>\n
Options:<\/p>\n
To use a User or User Group Variable, you need to open the Criteria Expression Builder, then in the Used Database Objects\/Variables list select the User or User Group Variable you want to use.<\/p>\n
A Login Parameter is a special Variable that you can use in your Query to show distinct data to different users using its User ID as a filter for said data; to use a Login Parameter, you can click in the Login Parameter button on the Criteria Expression Builder.<\/p>\n
Note: The Login Parameter is replaced with the User ID as defined when the User was registered on XLReport.<\/p>\n","protected":false},"featured_media":0,"parent":147,"menu_order":8,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/218"}],"collection":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/comments?post=218"}],"version-history":[{"count":3,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/218\/revisions"}],"predecessor-version":[{"id":365,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/218\/revisions\/365"}],"up":[{"embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/147"}],"next":[{"title":"Query Properties","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/query-properties\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/220"}],"prev":[{"title":"Criteria - Filter","link":"https:\/\/docs.xlreport.com\/docs\/admin-user\/query-your-data\/criteria-filter\/","href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/docs\/211"}],"wp:attachment":[{"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/media?parent=218"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/docs.xlreport.com\/wp-json\/wp\/v2\/doc_tag?post=218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}