Databases
StackOverflow2013
Postsdbo
POModify subsequent dropdown list with jquery
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POModify subsequent dropdown list with jquery
    primarykey
    data
    text
    <p>I have a web form with multiple dropdown lists. I would like to only display options in the second list that share the same value as the selection in the first list. </p> <pre><code>&lt;!-- Dropdown #1 --&gt; &lt;div class="control-group"&gt; &lt;label class="control-label" for="select01"&gt;Select Tier&lt;/label&gt; &lt;div class="controls"&gt; &lt;select id="select01"&gt; &lt;option value="all"&gt;All Tiers&lt;/option&gt; &lt;option value="db"&gt;Database Tier&lt;/option&gt; &lt;option value="app"&gt;Application Tier&lt;/option&gt; &lt;option value="web"&gt;Web Tier&lt;/option&gt; &lt;/select&gt; &lt;/div&gt; &lt;/div&gt; &lt;!-- Dropdown #2 --&gt; &lt;div class="control-group"&gt; &lt;label class="control-label" for="select01"&gt;Select Audit Point&lt;/label&gt; &lt;div class="controls"&gt; &lt;select id="select03"&gt; &lt;option value="all"&gt;Software Version&lt;/option&gt; &lt;option value="all"&gt;Server OS, Memory, CPU&lt;/option&gt; &lt;option value="all"&gt;High Availability&lt;/option&gt; &lt;option value="db"&gt;DBMS Version&lt;/option&gt; &lt;option value="db"&gt;DBMS Statistics&lt;/option&gt; &lt;option value="db"&gt;DBMS Parameters&lt;/option&gt; &lt;option value="db"&gt;DBMS Data File Growth&lt;/option&gt; &lt;option value="db"&gt;Database Disk Structure&lt;/option&gt; &lt;option value="db"&gt;Long Running SQL&lt;/option&gt; &lt;option value="db"&gt;Security Data Growth Range&lt;/option&gt; &lt;option value="db"&gt;Extraneous entries in System Tables&lt;/option&gt; &lt;option value="db"&gt;Feed Error Orphans&lt;/option&gt; &lt;option value="db"&gt;Position Detail Orphans&lt;/option&gt; &lt;option value="db"&gt;Data Retention Policy&lt;/option&gt; &lt;option value="db"&gt;Securities Added Daily&lt;/option&gt; &lt;option value="db"&gt;Security Master Load&lt;/option&gt; &lt;option value="db"&gt;SRM Purge&lt;/option&gt; &lt;option value="db"&gt;Best Pricing Purge&lt;/option&gt; &lt;option value="db"&gt;Partitioning&lt;/option&gt; &lt;option value="db"&gt;DBMS Data/Log File Utilize Shared Disk&lt;/option&gt; &lt;option value="db"&gt;DBMS Failover&lt;/option&gt; &lt;option value="app"&gt;DBMS Client Version&lt;/option&gt; &lt;option value="app"&gt;Star Engine IP Configuration&lt;/option&gt; &lt;option value="app"&gt;Engine Count/Configuration&lt;/option&gt; &lt;option value="app"&gt;STAR Engine Logging Interval&lt;/option&gt; &lt;option value="app"&gt;PACE Engine Port Configuration&lt;/option&gt; &lt;option value="app"&gt;PACE Server Logging&lt;/option&gt; &lt;option value="app"&gt;PACE Engine Log Configuration&lt;/option&gt; &lt;option value="app"&gt;STAR Engine Load Balancer Interval&lt;/option&gt; &lt;option value="app"&gt;Engines Restarted Weekly&lt;/option&gt; &lt;option value="app"&gt;Designated Master&lt;/option&gt; &lt;option value="app"&gt;Cluster Managers Identical&lt;/option&gt; &lt;option value="app"&gt;Uploader Shared Disk Space&lt;/option&gt; &lt;option value="app"&gt;Custom Archive Rule Shared Disk Space&lt;/option&gt; &lt;option value="app"&gt;App Server Clustering&lt;/option&gt; &lt;option value="app"&gt;PACE Event Concurrency&lt;/option&gt; &lt;option value="web"&gt;Homogenous Engine Configuration&lt;/option&gt; &lt;option value="web"&gt;Log Levels&lt;/option&gt; &lt;option value="web"&gt;Scheduler Purging&lt;/option&gt; &lt;option value="web"&gt;Web Server Services Restarted Weekly&lt;/option&gt; &lt;option value="web"&gt;Email Notification Basic Configuration&lt;/option&gt; &lt;option value="web"n&gt;Web Load Balancer Configuration&lt;/option&gt; &lt;option value="web"&gt;Load Balancer Customizations&lt;/option&gt; &lt;option value="web"&gt;Portal Shared Disk Space&lt;/option&gt; &lt;option value="web"&gt;Message Center Shared Disk Space&lt;/option&gt; &lt;option value="web"&gt;Message Center ID'S&lt;/option&gt; &lt;option value="web"&gt;Schedule Service Config&lt;/option&gt; &lt;option value="web"&gt;ePace is a client of Clustered App Servers&lt;/option&gt; &lt;option value="web"&gt;Portal is a client of Clustered App Servers&lt;/option&gt; &lt;option value="web"&gt;ESTAR is a client of Clustered Load Balancers&lt;/option&gt; &lt;option value="web"&gt;ESTAR is a client of Clustered Engines&lt;/option&gt; &lt;option value="web"&gt;ESTAR is a client of Clustered Report Export Services&lt;/option&gt; &lt;option value="web"&gt;WebSync Configured&lt;/option&gt; &lt;option value="web"&gt;Web Server Load Balancing Configured&lt;/option&gt; &lt;option value="web"&gt;Shared Disk Dynamic Folder&lt;/option&gt; </code></pre> <p>I need to be able to continuously change the list 1 selection, so I cannot .remove() unmatched options in the 2nd list. If I did remove them, I would then need to re-populate the 2nd list on each new selection from the 1st list.</p> <p>Thank you for your help.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USJake
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POModify subsequent dropdown list with jquery
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCould you make multiple dropdowns and only show the appropriate one based on selection instead? You might also want to look into [optgroup](http://www.w3schools.com/tags/tag_optgroup.asp).
      singulars
      1. POModify subsequent dropdown list with jquery
      1. USJeremy Gallant
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload