Build a new query - OCLC Support

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Build a new query - OCLC Support</title> <link media="screen" type="text/css" rel="stylesheet" href="https://a.mtstatic.com/@cache/layout/legacy-0.css?_=1fc5cf7d1c725a4312efc33fbbc53809_aGVscC5vY2xjLm9yZw==:site_10606" id="mt-screen-css" /> <link media="print" type="text/css" rel="stylesheet" href="https://a.mtstatic.com/@cache/layout/print.css?_=c5d69afcac31700ff9758fde125e8285:site_10606" id="mt-print-css" /> <script type="text/javascript" nonce="67ab91069242c658153f8f6729778214391aee9ed5b6bf7ed85197be8ca2a488" src="https://a.mtstatic.com/deki/javascript/out/grape.min.js?_=aae9f894b8b9c897d72439fee4980c96b51ba5ff:site_10606"></script><script type="application/json" id="mt-global-settings" nonce="67ab91069242c658153f8f6729778214391aee9ed5b6bf7ed85197be8ca2a488">{"apiToken":"xhr_2_1732380970_4a490e900a123861e0b5d6b49a55ab6d52d17a2260e306b6f18cbcad0594f3f9","pageId":58073,"pageViewId":"1bd04a5f-0220-4b58-b994-dad6ad143f2d"}</script> <link rel="stylesheet" href="https://use.typekit.net/gsk4dds.css"> <script src="https://www.oclc.org/apps/settings/wcm/designs/oclc/js/jquery/jquery.hoverIntent.minified.js"></script>  <script type="text/javascript" src="https://cdn.cookielaw.org/consent/999c7907-ac3c-4ce1-9125-172f53ec926f/OtAutoBlock.js"></script> <script src="https://cdn.cookielaw.org/scripttemplates/otSDKStub.js" data-document-language="true" type="text/javascript" charset="UTF-8" data-domain-script="999c7907-ac3c-4ce1-9125-172f53ec926f"></script> <script type="text/javascript">/*<![CDATA[*/ function OptanonWrapper() { } /*]]>*/</script>   <script type="text/javascript">/*<![CDATA[*/ (function() { var sz = document.createElement('script'); sz.type = 'text/javascript'; sz.async = true; sz.src = '//siteimproveanalytics.com/js/siteanalyze_6037648.js'; var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(sz, s); })(); /*]]>*/</script> <script type="text/javascript" nonce="67ab91069242c658153f8f6729778214391aee9ed5b6bf7ed85197be8ca2a488">(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)})(window,document,'script','//www.google-analytics.com/analytics.js','ga');ga('create','UA-69387992-20','https://help.oclc.org/',{allowLinker:true});ga('send','pageview');ga('create','UA-65721316-23','help.oclc.org',{name:'mtTracker',allowLinker:true});ga('mtTracker.require','linker');ga('mtTracker.set', 'anonymizeIp', true);ga('mtTracker.send','pageview');document.addEventListener('mindtouch-web-widget:f1:loaded',function(e){var t=e.data||{},d=t.widget;d&&''!==t.embedId&&document.addEventListener('mindtouch-web-widget:f1:clicked',function(e){var t=(e.data||{}).href;if(t){var n=document.createElement('a');n.setAttribute('href',t),'expert-help.nice.com'===n.hostname&&(e.preventDefault(),ga('linker:decorate',n),d.open(n.href))}})});</script> </head> <body class="columbia-page-main columbia-article-topic columbia-breadcrumb-home-librarymanagement-greenglass-analysis-querybuilder-buildanewquery columbia-live no-touch columbia-lang-en-us columbia-skin-grape"> <div class="grape-messaging"> </div> <div class="grape-header-custom"><div class="header_microbar iparsys parsys"><div class="header_microbar iparsys parsys"><div class="sitebar parbase section"><section class="micro-bar" id="micro-bar"><div class="cont-page mod" id="sitebar-contents"><div class="elm-nav-container"><div id="oclc-return"><a title="OCLC.org Home" href="https://www.oclc.org" target="_blank" rel="external noopener nofollow" class="link-https">OCLC.org</a><ul id="sitebar-sites" style="display: none; "><li><a title="" href="https://www.oclc.org" target="_blank" rel="external noopener nofollow" class="link-https"><span class="oclc-return-home">OCLC.org Home</span></a></li><li><a title="" href="https://community.oclc.org/" target="_blank" rel="external noopener nofollow" class="link-https">Community Center</a></li><li><a title="" href="https://www.oclc.org/developer/home.en.html" target="_blank" rel="external noopener nofollow" class="link-https">Developer Network</a></li><li><a title="" href="https://www.oclc.org/research/home.html" target="_blank" rel="external noopener nofollow" class="link-https">Research</a></li><li><a title="" href="https://www.webjunction.org/home.html" target="_blank" rel="external noopener nofollow" class="link-https">WebJunction</a></li></ul></div></div></div></section></div></div></div><nav class="elm-nav mindtouch-header"><div class="elm-nav-container"><div class="company-logo-container"><a class="internal" href="https://help.oclc.org/" rel="internal"><img src="https://help.oclc.org/@api/deki/site/logo.png?default=https://a.mtstatic.com/skins/styles/elm/logo.svg%3F_%3Daae9f894b8b9c897d72439fee4980c96b51ba5ff:site_10606" alt="OCLC Logo" /></a></div><div><div class="selected-region-dd"><p class="selected-region"><a class="selected-region-title" id="selected-region-title">English</a></p><ul class="languagepicker"><a class="language" id="en" href="#"><li><span language="en">English</span></li></a><a class="language" id="fr" href="#"><li><span language="fr">Français</span></li></a><a class="language" id="de" href="#" style="display:none;"><li><span language="de">Deutsch</span></li></a><a class="language" id="it" href="#" style="display:none;"><li><span language="it">Italiano</span></li></a><a class="language" id="es" href="#" style="display:none;"><li><span language="es">Español</span></li></a><a class="language" id="nl" href="#" style="display:none;"><li><span language="nl">Nederlands</span></li></a></ul></div></div><ul class="mindtouch-site-nav"><li><a title="Find release notes for OCLC products and services." target="_blank" href="https://help.oclc.org/Librarian_Toolbox/Release_notes" rel="internal">Release Notes</a></li><li><a href="https://oclc.service-now.com/status" target="_blank" rel="external noopener nofollow" class="link-https">System Status Dashboard</a></li><li><a onclick="ga('send', 'event', 'External Link', 'Click', 'Contact OCLC Support', '0');" class="internal" href="https://help.oclc.org/Librarian_Toolbox/Contact_OCLC_Support" rel="internal">Contact OCLC Support</a></li></ul></div></nav> <script type="text/javascript">/*<![CDATA[*/ $(function() { $('.tool-tip-link').tooltip(); }); $(document).ready(function(){ /* OCLC sitebar menu */ $('#oclc-return').hoverIntent( function() { $('#sitebar-sites').show(); return false; }, function() { $('#sitebar-sites').hide(); return false; } ); });/*]]>*/</script> <script>/*<![CDATA[*/if (window.location.host == 'help.oclc.org' || window.location.host == 'oclc-sandbox.mindtouch.us') {var priorSelection='';}/*]]>*/</script> <script type="text/javascript">/*<![CDATA[*/ /** * Get a cookie by name * @param {string} cName - Cookie name * @returns cookie value */ function getCookie(cName) { var name = cName + "="; var decodedCookie = decodeURIComponent(document.cookie); var ca = decodedCookie.split(';'); for (var i = 0; i < ca.length; i++) { var c = ca[i]; while (c.charAt(0) == ' ') { c = c.substring(1); } if (c.indexOf(name) == 0) { return c.substring(name.length, c.length); } } return ""; } /** * Set a cookie * @param {string} cName - Cookie name * @param {string} cValue - Cookie value * @param {number} expDays - Expiration time in days */ function setCookie(cName, cValue, expDays) { var date = new Date(); date.setTime(date.getTime() + (expDays * 24 * 60 * 60 * 1000)); var expires = "expires=" + date.toUTCString(); document.cookie = cName + "=" + cValue + ";" + expires + ";path=/"; } /** * Get current site language from url */ const smartlingFr = 'fr-b1887160206b09594.getsmartling.com'; const smartlingDe = 'de-b18871602cd1cb2ef.getsmartling.com'; const smartlingEs = 'es-b18871602e48673f2.getsmartling.com'; const smartlingIt = 'it-it-b1887160218846635.getsmartling.com'; const smartlingNl = 'nl-b18871602833bab44.getsmartling.com'; var thisSiteLanguage = ''; // "help.oclc.org" is getting converted to other domains when in another language site // Separating help.oclc.org stops whatever is converting the string if ([('help' + '.oclc.org'), 'oclc-sandbox.mindtouch.us'].includes(window.location.host)) { thisSiteLanguage = 'en'; document.getElementById('selected-region-title').innerText = 'English'; } else if (['help-fr.oclc.org', smartlingFr].includes(window.location.host)) { thisSiteLanguage = 'fr'; document.getElementById('selected-region-title').innerText = 'Fran莽ais'; } else if (['help-de.oclc.org', smartlingDe].includes(window.location.host)) { thisSiteLanguage = 'de'; document.getElementById('selected-region-title').innerText = 'Deutsch'; } else if (['help-es.oclc.org', smartlingEs].includes(window.location.host)) { thisSiteLanguage = 'es'; document.getElementById('selected-region-title').innerText = 'Espa帽ol'; } else if (['help-it.oclc.org', smartlingIt].includes(window.location.host)) { thisSiteLanguage = 'it'; document.getElementById('selected-region-title').innerText = 'Italiano'; } else if (['help-nl.oclc.org', smartlingNl].includes(window.location.host)) { thisSiteLanguage = 'nl'; document.getElementById('selected-region-title').innerText = 'Nederlands'; } /** * Go to selected language and set cookie for that language */ function goToLanguage(language) { const path = window.location.pathname; setCookie("oclc_helpsite", language, 2); if (language == 'en' && thisSiteLanguage != 'en') { setCookie("oclc_helpsite", "en", 2); // "help.oclc.org" is getting converted to other domains when in another language site // Separating help.oclc.org stops whatever is converting the string window.location = 'https://help' + '.oclc.org' + path + '?sl=en'; } else if (language == 'fr' && thisSiteLanguage != 'fr') { setCookie("oclc_helpsite", "fr", 2); window.location = 'https://help-fr.oclc.org' + path + '?sl=fr'; } else if (language == 'de' && thisSiteLanguage != 'de') { setCookie("oclc_helpsite", "de", 2); window.location = 'https://help-de.oclc.org' + path + '?sl=de'; } else if (language == 'es' && thisSiteLanguage != 'es') { setCookie("oclc_helpsite", "es", 2); window.location = 'https://help-es.oclc.org' + path + '?sl=es'; } else if (language == 'it' && thisSiteLanguage != 'it') { setCookie("oclc_helpsite", "it", 2); window.location = 'https://help-it.oclc.org' + path + '?sl=it'; } else if (language == 'nl' && thisSiteLanguage != 'nl') { setCookie("oclc_helpsite", "nl", 2); window.location = 'https://help-nl.oclc.org' + path + '?sl=nl'; } } /** * Set cookie from prior language selection */ if (typeof priorSelection == 'undefined') { priorSelection = '' } if (priorSelection != '') { setCookie('oclc_helpsite', priorSelection, 2); } /** * Change language based on browser's preferred language */ var userPreferredLang = navigator.languages && navigator.languages[0] || navigator.language || navigator.userLanguage; // if (getCookie("oclc_helpsite") != thisSiteLanguage) {} if (getCookie("oclc_helpsite") == '' || getCookie("oclc_helpsite") == undefined) { if (userPreferredLang.toLowerCase().includes('en')) { goToLanguage('en'); } else if (userPreferredLang.toLowerCase().includes('fr')) { goToLanguage('fr'); } else if (userPreferredLang.toLowerCase().includes('de')) { goToLanguage('de'); } else if (userPreferredLang.toLowerCase().includes('es')) { goToLanguage('es'); } else if (userPreferredLang.toLowerCase().includes('it')) { goToLanguage('it'); } else if (userPreferredLang.toLowerCase().includes('nl')) { goToLanguage('nl'); } } $(function () { $('.selected-region-dd').hover(function () { var show = $('.languagepicker'); show.toggle(); }); /** * Change language on click of language selector */ $('.language li').click(function () { var clickedLanguage = $(this).children("span").attr('language'); goToLanguage(clickedLanguage); }); });/*]]>*/</script> </div> <div class="grape-header grape-wrapper"> <div class="grape-header-container grape-wrapper-container"> <div class="grape-site-logo"> <a class="logo-anonymous" href="/" title="OCLC Support"> <img class="mt-cdn" src="https://a.mtstatic.com/@public/production/site_10606/1510500640-logo.png" alt="OCLC Support" title="OCLC Support"> </a> </div> <div class="grape-site-navigation"> <ul class="mt-site-nav"> <li class="mt-login-sign-in"> <a class="mt-icon-quick-sign-in" href="https://help.oclc.org/@app/saml/login?returnto=https%3A%2F%2Fhelp.oclc.org%2FLibrary_Management%2FGreenGlass%2FAnalysis%2FQuery_Builder%2FBuild_a_new_query" title="Sign in"> Sign in </a> </li> <li class="mt-login-forgot-password"> <a class="mt-icon-login-forgot-password" href="https://help.oclc.org/Special:UserPassword" title="Retrieve lost password"> Forgot password </a> </li> </ul> </div> <div class="grape-site-search"> <div class="mt-quick-search-container"> <form action="/Special:Search"> <input name="path" id="mt-search-path" type="hidden" value="" /> <label class="mt-label" for="mt-site-search-input"> Search </label> <input class="mt-text mt-search search-field" name="q" id="mt-site-search-input" placeholder="How can we help you?" type="search" /> <button class="mt-button ui-button-icon mt-icon-site-search-button search-button" type="submit"> Search </button> </form> </div> </div> </div> <div class="grape-site-nav grape-wrapper-container"> <ul class="mt-breadcrumbs"> <li> <a href="https://help.oclc.org/"> <span class="mt-icon-article-category mt-icon-article-home"></span> Home </a> </li> <li> <a href="https://help.oclc.org/Library_Management"> <span class="mt-icon-article-category"></span> Library Management </a> </li> <li> <a href="https://help.oclc.org/Library_Management/GreenGlass"> <span class="mt-icon-article-category"></span> GreenGlass </a> </li> <li> <a href="https://help.oclc.org/Library_Management/GreenGlass/Analysis"> <span class="mt-icon-article-category"></span> Analysis </a> </li> <li> <a href="https://help.oclc.org/Library_Management/GreenGlass/Analysis/Query_Builder"> <span class="mt-icon-article-guide"></span> Query Builder </a> </li> </ul> </div> </div> <div class="grape-content grape-wrapper"> <div class="grape-content-container grape-wrapper-container"> <div id="flash-messages"><div class="dekiFlash"></div></div> <h1 id="title" class="no-edit" style="visibility: visible;"> Build a new query </h1> <div class="mt-last-updated"> <strong>Last updated:</strong> <span class="modified mt-last-updated-timestamp" data-timestamp="2024-09-05T14:41:21Z"></span> </div> <div class="mt-content-header"> <div id="machine-translation-message" class="highlight-box highlight-box--subtle" style="display:none;">The translation on this website may be generated by machine translation. The quality and accuracy of machine translation can vary significantly from one text to another. Read the page in original English <a onclick="goToLanguage('en')">here</a>.</div> <script type="text/javascript">/*<![CDATA[*/ // Determine if machine translation message should be shown function displayMachineTranslationMessage() { // Show if Italian, excluding certain pages if (thisSiteLanguage == 'it' && !document.querySelector('.columbia-page-home')) { document.querySelector('#machine-translation-message').style.display = null; } } displayMachineTranslationMessage();/*]]>*/</script> </div> <div class="mt-content-side"></div> <div id="mt-toc-container" data-title="Table of contents" data-collapsed="true"> <button class="mt-toggle mt-summary-toggle ui-button-icon mt-toggle-expand">Table of contents</button> <div class="mt-toc-content mt-collapsible-section mt-toc-hide"> <ol><li><a href="#Build_a_new_query" rel="internal">Build a new query</a></li><li><a href="#Sample_Queries" rel="internal">Sample Queries</a><ol><li><a href="#Preservation_criteria_query" rel="internal">Preservation criteria query</a></li><li><a href="#Deselection_criteria_query" rel="internal">Deselection criteria query</a></li></ol></li><li><a href="#Combine_Queries" rel="internal">Combine Queries</a></li></ol> </div> </div> <div id="page-top"> <div id="topic"> <div id="pageText"> <div class="mt-page-summary"><div class="mt-page-overview">Learn how to build a new query within Query Builder in GreenGlass.</div></div> <p>The Query Builder is divided into two panels. The Query parameters are entered in the left panel and the results appear in the right panel. As query parameters are added in the left panel, the results refresh and appear immediately. </p> <ul class="mt-indent-1"> <li>The left and right panels of the New Query screen scroll separately. If the left panel is hidden, click on the <strong>SHOW EDITOR</strong> tab.</li> </ul> <p>At any time, you are invited to <strong>SAVE </strong>your query in the upper right portion of the screen. There is no limit on the number of queries that can be saved. </p> <p>Please contact your GreenGlass liaison if you have query requirements that are not readily satisfied by the tools in GreenGlass. Your GreenGlass liaison can build more complex models and scenarios offline.</p> <div mt-section-origin="Library_Management/GreenGlass/Analysis/Query_Builder/Build_a_new_query" class="mt-section" id="section_1"><span id="Build_a_new_query"></span><h2 class="editable">Build a new query</h2> <ol> <li>Click on <strong>New query </strong>in the upper left area of the screen and replace this with the name of your query. Click <strong>confirm</strong>.  <ul> <li>If you do not, your query will be saved as "New Query". There is a 255-character limit on query names.</li> </ul> </li> <li>Review the available components. Refer to <a title="Query parameters" href="#s58074" rel="internal">Query parameters </a>for more information. <ul> <li>Some of these components may have been customized for your library.</li> </ul> </li> <li>Add query parameters to the left panel. <ul> <li>After naming your query, you will have the opportunity to select All subjects, Specific LC Classes or even Specific LC Sub-Classes.  </li> <li>If yours is a Dewey Library, you’ll also have the opportunity to select specific Dewey ranges at the level of hundreds or tens.</li> <li>You can also control your results by primary language.  Enter the three-letter code from the MARC record. If you wish to include multiple languages, separate the codes with commas.  Query parameters are entered into the left panel and results appear on the right panel.</li> </ul> <ul> <li>As changes are made in the left panel, the right panel refreshes, and the impact of each threshold is seen immediately.</li> <li>As you enter parameters, each one appears under the tallies and above the bar chart.</li> </ul> </li> <li>Click the <strong>[SAVE] </strong>button in the upper right corner of the screen to save the query at any point.</li> <li>Whether or not you have saved the query, you can scroll down the page to view the charted data in tabular form and see a list of books that match the current parameters.  Because the list may be long, use the navigational tool to see the list by subject.  </li> <li>As always, you are free to export the list by clicking on the <strong>[EXPORT]</strong> button.</li> </ol> </div><div mt-section-origin="Library_Management/GreenGlass/Analysis/Query_Builder/Build_a_new_query" class="mt-section" id="section_2"><span id="Sample_Queries"></span><h2 class="editable">Sample Queries</h2> <div mt-section-origin="Library_Management/GreenGlass/Analysis/Query_Builder/Build_a_new_query" class="mt-section" id="section_3"><span id="Preservation_criteria_query"></span><h3 class="editable">Preservation criteria query</h3> <p>The below scenario seeks to identify materials that are scarcely held and which the library may wish to digitize, preserve, or protect on behalf of the collective collections.</p> <ol> <li>Click on <strong>New query i</strong>n the upper left area of your screen and replace this with "Sample Preservation Scenario". Click <strong>confirm</strong>.  <ul> <li>If you do not, your query will be saved as "New Query". There is a 255-character limit on query names.</li> </ul> </li> <li>Add query parameters to the left panel. <ul> <li>Select <strong>All subjects</strong></li> <li>Select <strong>All location codes</strong></li> <li>Select <strong>All record types</strong></li> <li>Do not include any criteria under <strong>Local Circulation History</strong> or <strong>Publication and Acquisition Dates</strong>.</li> <li>Under WorldCat Holdings: <ul> <li>Choose <strong>any edition </strong>under <strong>Edition matching</strong>.</li> <li>Under <strong>US holdings</strong>, select <strong>fewer than</strong> and enter 5 in the resulting box.</li> </ul> </li> <li>Under <strong>HathiTrust</strong>, select <strong>NOT in HathiTrust</strong>.</li> </ul> </li> <li>We can see the number of matched items represents 0.2% of the entire collection.</li> <li>Click the <strong>[SAVE] </strong>button in the upper right corner of the screen to save the query at any point. <ul> <li>Whether or not you have saved the query, you can scroll down the page to view the charted data in tabular form and see a list of books that match the current parameters.  Because the list may be long, use the navigational tool to see the list by subject.  </li> </ul> </li> <li>As always, you are free to export the list by clicking on the <strong>[EXPORT]</strong> button.</li> </ol> <p><img class="internal default" alt="GreenGlass_Sample_Preservation_Query.png" loading="lazy" src="https://help.oclc.org/@api/deki/files/16802/GreenGlass_Sample_Preservation_Query.png?revision=2" /></p> </div><div mt-section-origin="Library_Management/GreenGlass/Analysis/Query_Builder/Build_a_new_query" class="mt-section" id="section_4"><span id="Deselection_criteria_query"></span><h3 class="editable">Deselection criteria query</h3> <p>Use the below query as an example for identifying potential withdrawal candidates.</p> <ol> <li>Click on <strong>New query i</strong>n the upper left area of your screen and replace this with "Sample Deselection Scenario". Click <strong>confirm</strong>.  <ul> <li>If you do not, your query will be saved as "New Query". There is a 255-character limit on query names.</li> </ul> </li> <li>Add query parameters to the left panel. <ul> <li>Select <strong>All subjects</strong></li> <li>Select <strong>All location codes</strong></li> <li>Select <strong>All record types</strong></li> <li>Under R<strong>ecorded uses</strong>, select <strong>fewer than</strong> and enter 2 in the resulting box.</li> <li>Under <strong>Publication year</strong>, select <strong>before </strong>and enter 2010 in the resulting box.</li> <li>Under <strong>Added to collection</strong>, select before and enter 2015 in the resulting box.</li> <li>Under <strong>US Holdings</strong>, select <strong>more than</strong> and enter 100 in the resulting box.</li> <li>Under <strong>California holdings</strong>, select <strong>more than</strong> and enter 2 in the resulting box.</li> </ul> </li> <li>We can see the number of matched items represents 8.3% of the entire collection.</li> <li>Click the <strong>[SAVE] </strong>button in the upper right corner of the screen to save the query at any point. <ul> <li>Whether or not you have saved the query, you can scroll down the page to view the charted data in tabular form and see a list of books that match the current parameters.  Because the list may be long, use the navigational tool to see the list by subject.  </li> </ul> </li> <li>As always, you are free to export the list by clicking on the <strong>[EXPORT]</strong> button.</li> </ol> <p><img class="internal default" alt="GreenGlass_Sample_Deselection criteria.png" loading="lazy" src="https://help.oclc.org/@api/deki/files/16801/GreenGlass_Sample_Deselection_criteria.png?revision=1" /></p> </div></div><div mt-section-origin="Library_Management/GreenGlass/Analysis/Query_Builder/Build_a_new_query" class="mt-section" id="section_5"><span id="Combine_Queries"></span><h2 class="editable">Combine Queries</h2> <div class="mt-contentreuse-widget" data-page="Library_Management/GreenGlass/Analysis/Query_Builder/Query_parameters" data-section="Combine Queries" data-show="false"> <div class="mt-include" id="s58074"> <p>At the bottom of the left panel, users have the option to combine the on-screen query with one or more queries that have been built and saved previously.</p> <p>The Query Builder employs AND logic between all parameters. Occasionally, multiple GreenGlass queries are necessary to use the Combine Queries feature to establish OR logic so that all items can be included in the results.  </p> <p>Options include:</p> <ul> <li>Click the <strong><strong>Combine results with other queries</strong></strong> radio button for an OR query. <ul> <li>This includes all items that match the parameters of either query.</li> </ul> </li> <li>Click the <strong><strong>Intersect results with other queries</strong></strong> radio button for an AND query. <ul> <li>This includes items that match the parameters of both queries.</li> </ul> </li> </ul> <p>To combine two or more lists:</p> <ol> <li>Open one of the lists in the Query Builder.</li> <li>Scroll to the bottom of the left panel, click on the <strong>COMBINE </strong>radio button.</li> <li>All other saved queries appear.</li> <li>Check the query or queries you wish to combine.</li> <li>A final parameter is added to your query.</li> </ol> <p>Combined queries can be saved and exported.</p> </div> </div> <p> </p> </div></div> </div> </div> <div class="mt-content-footer"> <p> </p> </div> <ol class="grape-meta-data grape-meta-article-navigation"> <li class="grape-back-to-top"><a class="mt-icon-back-to-top" href="#title" id="mt-back-to-top" title="Jump back to top of this article">Back to top</a></li> <li class="grape-article-pagination"><ul class="mt-article-pagination"> <li class="mt-pagination-previous"> <a class="mt-icon-previous-article" href="https://help.oclc.org/Library_Management/GreenGlass/Analysis/Query_Builder" title="Query Builder"><span>Query Builder</span></a> </li> <li class="mt-pagination-next"> <a class="mt-icon-next-article" href="https://help.oclc.org/Library_Management/GreenGlass/Analysis/Query_Builder/Query_parameters" title="Query parameters"><span>Query parameters</span></a> </li> </ul> </li> </ol> </div> </div> <div class="grape-footer grape-wrapper"> <div class="grape-wrapper-container"> <ol> <li class="grape-footer-copyright">© Copyright 2024 OCLC Support</li> <li class="grape-footer-powered-by"><a href="https://mindtouch.com/demo" class="mt-poweredby product " title="MindTouch" target="_blank"> Powered by CXone Expert <span class="mt-registered">®</span> </a></li> </ol> </div> </div> <div class="grape-footer-custom"><div class="footer iparsys parsys"><div class="footer section"><footer class="page-footer"><div class="divider blue-green"><div class="bar-1"></div><div class="bar-2"></div></div><div class="footer-banner"><div class="elm-nav-container"><div><h3>Stay in the know</h3><p>Get the latest product updates, research, events, and much more—right to your inbox.</p></div><a href="https://www.oclc.org/en/email.html?utm_campaign=email-subscription-web-organic&utm_medium=digital&utm_source=webpage-email-sub&utm_content=email-subscription-footer-button&utm_term=en" target="_blank" rel="external noopener nofollow" class="ui-button-primary link-https">Subscribe now</a></div></div><div class="elm-nav-container"><div class="parsyscolumncontrol section"><div class="parsys_column cq-colctrl-lt6"><div class="parsys_column cq-colctrl-lt6-c0"><div class="col0 parsys"><div class="text parbase section"><p><a title="OCLC.org Home" href="https://www.oclc.org/" target="_blank" rel="external noopener nofollow" class="link-https"><img src="https://www.oclc.org/content/dam/oclc/design-images/home-page/footer-logo.png" alt="OCLC logo" class="img-nobrdr" /></a></p></div></div></div><div class="parsys_column cq-colctrl-lt6-c1"><div class="col1 parsys"><div class="text parbase section"><div style="padding: 25px 0 0 0;"><div class="other-accounts" style="float: left;"><a title="Like us on Facebook" href="http://www.facebook.com/pages/OCLC/20530435726" target="_blank" rel="external noopener nofollow" class="external"><img class="img-nobrdr" src="https://www.oclc.org/content/dam/common/images/social-icons/footer/footer-facebook.png" alt="Facebook" style="margin: 0 5px 0 0;" /></a><a title="Watch videos on YouTube" href="http://www.youtube.com/OCLCvideo" target="_blank" rel="external noopener nofollow" class="external"><img class="img-nobrdr" src="https://www.oclc.org/content/dam/common/images/social-icons/footer/footer-youtube.png" alt="YouTube" style="margin: 0 5px 0 0;" /></a><a title="Connect with us on LinkedIn" href="https://www.linkedin.com/company/oclc" target="_blank" rel="external noopener nofollow" class="link-https"><img class="img-nobrdr" src="https://www.oclc.org/content/dam/common/images/social-icons/footer/footer-linkedin.png" alt="LinkedIn" style="margin: 0 2px 0 0;" /></a><a title="Connect with us on Instagram" href="https://www.instagram.com/oclc_global/" target="_blank" rel="external noopener nofollow" class="link-https"><img class="img-nobrdr" src="https://www.oclc.org/content/dam/common/images/social-icons/footer/footer-instagram.png" alt="Instagram" style="margin: 0 5px 0 0;" /></a><a title="Read our blog" href="https://blog.oclc.org/next/" target="_blank" rel="external noopener nofollow" class="link-https"><img class="img-nobrdr" src="https://www.oclc.org/content/dam/common/images/social-icons/footer/footer-blog.png" alt="Next blog" style="margin: 0 5px 0 0;" /></a><a style="display: none" title="Subscribe to email updates" href="https://www.oclc.org/en/email.html" target="_blank" rel="external noopener nofollow" class="link-https"><img class="img-nobrdr" src="https://www.oclc.org/content/dam/common/images/social-icons/footer/footer-mail.png" alt="Email" style="margin: 0 5px 0 0;" /></a><a href="https://www.oclc.org/en/rss.html" target="_blank" rel="external noopener nofollow" class="link-https"><img title="Choose your news with RSS feeds" class="img-nobrdr" src="https://www.oclc.org/content/dam/common/images/social-icons/footer/footer-rss.png" alt="RSS feeds" height="34" width="29" /></a></div></div><div style="clear: both;"> </div></div><div class="text parbase section"><div class="copyright"><p class="sl_swap" id="Copyright-Link"><a title="Read the OCLC copyright policy" href="https://www.oclc.org/en/policies/copyright.html" target="_blank" rel="external noopener nofollow" class="link-https">© 2024 OCLC</a></p><p class="sl_swap" id="Trademarks-Link"><a title="View the OCLC and Affiliate Trademarks and Service Marks PDF" href="https://www.oclc.org/en/policies/trademarks.html" target="_blank" rel="external noopener nofollow" class="link-https">Domestic and international trademarks and/or service marks of OCLC, Inc. and its affiliates</a></p><ul><li class="sl_swap" id="Cookies-Link"><a href="https://policies.oclc.org/en/privacy/cookie-statement.html" target="_blank" rel="external noopener nofollow" class="link-https">Cookie notice</a></li><li class="sl_swap" id="Cookies-List-Settings"><a href="https://policies.oclc.org/en/privacy/cookie-statement/oclc-org-cookie-list.html" target="_blank" rel="external noopener nofollow" class="link-https">Cookie list and settings</a></li><li class="sl_swap" id="Privacy-Link"><a href="https://www.oclc.org/en/policies/privacy.html" target="_blank" rel="external noopener nofollow" class="link-https">Privacy policy</a></li><li class="sl_swap" id="Accessibility-Link"><a href="https://www.oclc.org/en/policies/accessibility.html" target="_blank" rel="external noopener nofollow" class="link-https">Accessibility statement</a></li><li class="sl_swap" id="ISO-Link"><a href="https://www.oclc.org/en/trust/compliance.html#trust-certifications" target="_blank" rel="external noopener nofollow" class="link-https">ISO 27001 Certificate</a></li><li class="sl_hide"><a rel="custom nofollow" href="https://help.oclc.org/@app/saml/login?returnto=https%3A%2F%2Fhelp.oclc.org%2FLibrary_Management%2FGreenGlass%2FAnalysis%2FQuery_Builder%2FBuild_a_new_query">Sign in</a></li></ul></div></div></div></div></div></div></div></footer></div></div> </div> <script>/*<![CDATA[*/ $(document).ready(function() { // Expandable list var pageEdit = $("body").hasClass("page-mode-editor"); $('.expand-list').find('dd').hide(); $('.expand-list').find('dt').on('click', function() { $(this).toggleClass('expanded'); $(this).next().fadeToggle('fast'); }); }); // AEM redirect function // Total seconds to wait var seconds = 10; var editMode = $("body").hasClass("elm-user-pro-edit"); var countDown = $("#countdown").length; var redirectUrl = $(".redirect-aem-url").attr("href"); function countdown() { seconds = seconds - 1; if (seconds < 0) { // Change your redirection link here window.location = redirectUrl; } else { // Update remaining seconds document.getElementById("countdown").innerHTML = seconds; // Count down using javascript window.setTimeout("countdown()", 1000); } } if (editMode) { // Do nothing } else { if (countDown) { // Run countdown function countdown(); } }; /*]]>*/</script> <script src="https://help.oclc.org/@api/deki/files/2123/mylist-player.js?origin=mt-web"></script> </body> </html>

CINXE.COM

Build a new query - OCLC Support