{"id":293,"date":"2024-11-15T17:46:06","date_gmt":"2024-11-15T17:46:06","guid":{"rendered":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/introduction-to-the-solr-api-accessing-impc-data-programmatically\/using-simple-solr-syntax-in-your-browser\/"},"modified":"2024-11-18T09:18:52","modified_gmt":"2024-11-18T09:18:52","slug":"using-simple-solr-syntax-in-your-browser","status":"publish","type":"page","link":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/introduction-to-the-solr-api-accessing-impc-data-programmatically\/using-simple-solr-syntax-in-your-browser\/","title":{"rendered":"Using simple Solr syntax in your browser"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Here is an example of a simple Solr request that you can paste in a browser:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><a href=\"https:\/\/www.ebi.ac.uk\/mi\/impc\/solr\/statistical-result\/select?q=*:*&amp;fl=marker_symbol,effect_size,p_value&amp;rows=3\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.ebi.ac.uk\/mi\/impc\/solr\/statistical-result\/select?q=*:*&amp;fl=marker_symbol,effect_size,p_value&amp;rows=3<\/a>\n<\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">In this example, we query the statistical-result core and select the first three documents and three fields:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>marker_symbol<\/li>\n\n\n\n<li>effect_size<\/li>\n\n\n\n<li>p-value<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"130\" src=\"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-content\/uploads\/sites\/283\/2024\/11\/fig_3-1024x130.png\" alt=\"Solr request in browser consists of the following parts:\nBase URL: https:\/\/www.ebi.ac.uk\/mi\/impc\/solr\nCore name:\nstatistical-result\nCommand: selec\nParameter 1: q=*:*\nParameter 2: fl=marker_symbol,effect_size,p_value\nParameter 3: rows=3\" class=\"wp-image-339\" srcset=\"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-content\/uploads\/sites\/283\/2024\/11\/fig_3-1024x130.png 1024w, https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-content\/uploads\/sites\/283\/2024\/11\/fig_3-300x38.png 300w, https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-content\/uploads\/sites\/283\/2024\/11\/fig_3-768x97.png 768w, https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-content\/uploads\/sites\/283\/2024\/11\/fig_3-1536x195.png 1536w, https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-content\/uploads\/sites\/283\/2024\/11\/fig_3-2048x259.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Figure 3.<\/strong> Solr request in browser.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s break down the example:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Base URL<\/strong>: The necessary part of the link that allows us to access the database<\/li>\n\n\n\n<li><strong>Core name<\/strong>: We need to specify the collection of data. Currently, we have five cores available: <code><kbd><strong>experiment<\/strong><\/kbd><\/code>, <code><kbd><strong>impc_images<\/strong><\/kbd><\/code>, <code><kbd><strong>statistical-result<\/strong><\/kbd><\/code>, <code><kbd><strong>genotype-phenotype<\/strong><\/kbd><\/code>, and <code><kbd><strong>phenodigm<\/strong><\/kbd><\/code>. More information about the data in these cores is provided in <a href=\"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/understanding-impc-data-resources-and-assistance\/what-impc-data-are-available-solr-cores\/\" data-type=\"link\" data-id=\"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/understanding-impc-data-resources-and-assistance\/what-impc-data-are-available-solr-cores\/\">this section<\/a><\/li>\n\n\n\n<li><strong>Command<\/strong>: <code><kbd><strong>select<\/strong><\/kbd><\/code> is the only available command for the IMPC data. It instructs Solr to execute a search query and return documents matching the specified parameters<\/li>\n\n\n\n<li><strong>Solr Parameters<\/strong>: In this example, we have three parameters: <code><kbd><strong>q<\/strong><\/kbd><\/code>, <code><kbd><strong>fl<\/strong><\/kbd><\/code>, and <code><kbd><strong>rows<\/strong><\/kbd><\/code>, separated by ampersands (&amp;)<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">We will look at the output in the next section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here is an example of a simple Solr request that you can paste in a browser: https:\/\/www.ebi.ac.uk\/mi\/impc\/solr\/statistical-result\/select?q=*:*&amp;fl=marker_symbol,effect_size,p_value&amp;rows=3 In this example, we query the statistical-result core and select the first three documents and three fields: Figure 3. Solr request in browser. Let\u2019s break down the example: We will look at the output in the next section.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":271,"menu_order":4,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-293","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/pages\/293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/comments?post=293"}],"version-history":[{"count":12,"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/pages\/293\/revisions"}],"predecessor-version":[{"id":955,"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/pages\/293\/revisions\/955"}],"up":[{"embeddable":true,"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/pages\/271"}],"wp:attachment":[{"href":"https:\/\/www.ebi.ac.uk\/training\/online\/courses\/impc-solr-api\/wp-json\/wp\/v2\/media?parent=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}