Forum Discussion

addyb77's avatar
addyb77
Helper I
9 years ago
Solved

Parameter/drop down list

Hi all

 

I am creating a dashboard to show relevant sql server info for admin and info purposes. I have multiple queries which are identical apart from the servername of the data connection itself.

 

Currently i have 3 servers listed under tables which display the following columns:

 

Table 1 (query 1)

Server              Domain           IP Address

My Server 1     MyDomain       x.x.x.x

 

Table 2 (query 2)

Server              Domain          IP Address

My Server 2     MyDomain     x.x.x.x

 

Table 3 (query 3)

Server              Domain          IP Address

My Server 3     MyDomain     x.x.x.x

 

What i want to do is have a drop down list/slicer of all the server names so when i select one it will just the relevant ip address etc for that server in one table instead of it being split across multiple tables. Im not sure how i go about this.

 

 

  • Anonymous's avatar
    Anonymous
    9 years ago

    Use the Query Editor to "Append" these into one query.

     

     

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Use the Query Editor to "Append" these into one query.

     

     

     

    • addyb77's avatar
      addyb77
      Helper I

      Thank you i hadnt spotted that. That does the trick.