Shulou(Shulou.com)06/01 Report--

What this article shares to you is about how to realize the related query of two select drop-down boxes in the query panel, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Method 1: realize the associated query function through the code code, the idea is as follows:

Add the onchange event to the first select drop-down box, and when the user selects the value of the first select drop-down box, it enters the onchange event, gets the selected value value in this event, then uses ajax to query the associated second select drop-down box based on this value, and returns the results to the page.

This method is prone to performance problems when associating and filtering a large amount of data.

Method 2: using the association filtering function provided by the report tool, the association filtering of drop-down data can be achieved through simple settings, such as editing style pull-down dataset association filtering.

When the select drop-down box has a large amount of data, the asynchronous loading method can be used to ensure the performance of fetching and drying the report parameter form association filter asynchronous loading usage.

Drop-down box associated with the query implementation effect:

The above is how to implement the related query of the two select drop-down boxes in the query panel. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.