https://www.servicenow.com/community/csm-forum/dashboard-with-dynamic-content-filter-for-reservation-mgmt/m-p/3042773#M39772 <P>I have a dashboard that has a calendar and uses a dynamic filter. That dynamic filter is build on a dynamic content / content block programmatic (script below). I have changed the building to be multi-select optional, but when in use, the filter only applies the first building selection. How can I get this to filter based on all selected buildings?</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="javascript">&lt;?xml version="1.0" encoding="utf-8" ?&gt; &lt;j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null"&gt; &lt;g:evaluate var="jvar_space_data" object="true" jelly="true"&gt; var spaceData = []; var spaceGr = new GlideRecordSecure(sn_wsd_core.WPConstants.TABLES.SPACE); spaceGr.addQuery('region', gs.getProperty('sn_wsd_rsv.lrccd_primary_region_id')); spaceGr.addActiveQuery(); spaceGr.addQuery('is_reservable',true); spaceGr.orderBy("region.name"); spaceGr.orderBy("site.name"); spaceGr.orderBy("campus.name"); spaceGr.orderBy("building.name"); spaceGr.orderBy("name"); spaceGr.query(); while(spaceGr.next()){ spaceData.push({ spaceId: spaceGr.getValue("sys_id"), spaceName: spaceGr.getDisplayValue("name"), buildingId : spaceGr.getValue("building"), buildingName : spaceGr.getDisplayValue("building"), campusId: spaceGr.getValue("campus"), campusName : spaceGr.getDisplayValue("campus"), siteId : spaceGr.getValue("site"), siteName : spaceGr.getDisplayValue("site"), regionId: spaceGr.getValue("region"), regionName: spaceGr.getDisplayValue("region"), }); } JSON.stringify(spaceData); &lt;/g:evaluate&gt; &lt;g:requires name="sn_wsd_rsv.lrccd_rsv_dashboard_filter.jsdbx" params="cache=$[jvar_stamp]" /&gt; &lt;style&gt; .cont { margin-top: 20px } .filter-label { font-size: 16px; margin-top: 8px; margin-bottom: 5px; } &lt;/style&gt; &lt;input type="hidden" id="spaceData" value="${jvar_space_data}"&gt;&lt;/input&gt; &lt;input type="hidden" id="siteStr" value="${gs.getMessage('Select a site')}"&gt; &lt;/input&gt; &lt;input type="hidden" id="campusStr" value="${gs.getMessage('Select a campus')}"&gt; &lt;/input&gt; &lt;input type="hidden" id="buildingStr" value="${gs.getMessage('Select a building')}"&gt; &lt;/input&gt; &lt;input type="hidden" id="spaceStr" value="${gs.getMessage('Select a room')}"&gt; &lt;/input&gt; &lt;div class="container"&gt; &lt;div class="row"&gt; &lt;div id="site-container" class="col-md-3 col-xs-12 col-sm-12"&gt; &lt;div class="filter-label"&gt; ${gs.getMessage('Site')} &lt;/div&gt; &lt;select class="select2" id="siteSelect" style="width: 100%" aria-label="${gs.getMessage('Select a site')}"&gt; &lt;/select&gt; &lt;/div&gt; &lt;div id="campus-container" class="col-md-3 col-xs-12 col-sm-12"&gt; &lt;div class="filter-label"&gt; ${gs.getMessage('Campus')} &lt;/div&gt; &lt;select class="select2" id="campusSelect" style="width: 100%" aria-label="${gs.getMessage('Select a campus')}"&gt; &lt;/select&gt; &lt;/div&gt; &lt;div id="building-container" class="col-md-3 col-xs-12 col-sm-12"&gt; &lt;div class="filter-label"&gt; ${gs.getMessage('Building')} &lt;/div&gt; &lt;select class="select2" id="buildingSelect" style="width: 100%" multiple="true" aria-label="${gs.getMessage('Select a building')}"&gt; &lt;/select&gt; &lt;/div&gt; &lt;div id="site-container" class="col-md-3 col-xs-12 col-sm-12"&gt; &lt;div class="filter-label"&gt; ${gs.getMessage('Room')} &lt;/div&gt; &lt;select class="select2" id="spaceSelect" style="width: 100%" aria-label="${gs.getMessage('Select a room')}"&gt; &lt;/select&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;/j:jelly&gt;</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 11 Sep 2024 22:20:44 GMT JuliaHowells 2024-09-11T22:20:44Z https://www.servicenow.com/community/csm-forum/dashboard-with-dynamic-content-filter-for-reservation-mgmt/m-p/3042773#M39772 <P>I have a dashboard that has a calendar and uses a dynamic filter. That dynamic filter is build on a dynamic content / content block programmatic (script below). I have changed the building to be multi-select optional, but when in use, the filter only applies the first building selection. How can I get this to filter based on all selected buildings?</P><P>&nbsp;</P><P>&nbsp;</P><LI-CODE lang="javascript">&lt;?xml version="1.0" encoding="utf-8" ?&gt; &lt;j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null"&gt; &lt;g:evaluate var="jvar_space_data" object="true" jelly="true"&gt; var spaceData = []; var spaceGr = new GlideRecordSecure(sn_wsd_core.WPConstants.TABLES.SPACE); spaceGr.addQuery('region', gs.getProperty('sn_wsd_rsv.lrccd_primary_region_id')); spaceGr.addActiveQuery(); spaceGr.addQuery('is_reservable',true); spaceGr.orderBy("region.name"); spaceGr.orderBy("site.name"); spaceGr.orderBy("campus.name"); spaceGr.orderBy("building.name"); spaceGr.orderBy("name"); spaceGr.query(); while(spaceGr.next()){ spaceData.push({ spaceId: spaceGr.getValue("sys_id"), spaceName: spaceGr.getDisplayValue("name"), buildingId : spaceGr.getValue("building"), buildingName : spaceGr.getDisplayValue("building"), campusId: spaceGr.getValue("campus"), campusName : spaceGr.getDisplayValue("campus"), siteId : spaceGr.getValue("site"), siteName : spaceGr.getDisplayValue("site"), regionId: spaceGr.getValue("region"), regionName: spaceGr.getDisplayValue("region"), }); } JSON.stringify(spaceData); &lt;/g:evaluate&gt; &lt;g:requires name="sn_wsd_rsv.lrccd_rsv_dashboard_filter.jsdbx" params="cache=$[jvar_stamp]" /&gt; &lt;style&gt; .cont { margin-top: 20px } .filter-label { font-size: 16px; margin-top: 8px; margin-bottom: 5px; } &lt;/style&gt; &lt;input type="hidden" id="spaceData" value="${jvar_space_data}"&gt;&lt;/input&gt; &lt;input type="hidden" id="siteStr" value="${gs.getMessage('Select a site')}"&gt; &lt;/input&gt; &lt;input type="hidden" id="campusStr" value="${gs.getMessage('Select a campus')}"&gt; &lt;/input&gt; &lt;input type="hidden" id="buildingStr" value="${gs.getMessage('Select a building')}"&gt; &lt;/input&gt; &lt;input type="hidden" id="spaceStr" value="${gs.getMessage('Select a room')}"&gt; &lt;/input&gt; &lt;div class="container"&gt; &lt;div class="row"&gt; &lt;div id="site-container" class="col-md-3 col-xs-12 col-sm-12"&gt; &lt;div class="filter-label"&gt; ${gs.getMessage('Site')} &lt;/div&gt; &lt;select class="select2" id="siteSelect" style="width: 100%" aria-label="${gs.getMessage('Select a site')}"&gt; &lt;/select&gt; &lt;/div&gt; &lt;div id="campus-container" class="col-md-3 col-xs-12 col-sm-12"&gt; &lt;div class="filter-label"&gt; ${gs.getMessage('Campus')} &lt;/div&gt; &lt;select class="select2" id="campusSelect" style="width: 100%" aria-label="${gs.getMessage('Select a campus')}"&gt; &lt;/select&gt; &lt;/div&gt; &lt;div id="building-container" class="col-md-3 col-xs-12 col-sm-12"&gt; &lt;div class="filter-label"&gt; ${gs.getMessage('Building')} &lt;/div&gt; &lt;select class="select2" id="buildingSelect" style="width: 100%" multiple="true" aria-label="${gs.getMessage('Select a building')}"&gt; &lt;/select&gt; &lt;/div&gt; &lt;div id="site-container" class="col-md-3 col-xs-12 col-sm-12"&gt; &lt;div class="filter-label"&gt; ${gs.getMessage('Room')} &lt;/div&gt; &lt;select class="select2" id="spaceSelect" style="width: 100%" aria-label="${gs.getMessage('Select a room')}"&gt; &lt;/select&gt; &lt;/div&gt; &lt;/div&gt; &lt;/div&gt; &lt;/j:jelly&gt;</LI-CODE><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 11 Sep 2024 22:20:44 GMT https://www.servicenow.com/community/csm-forum/dashboard-with-dynamic-content-filter-for-reservation-mgmt/m-p/3042773#M39772 JuliaHowells 2024-09-11T22:20:44Z