Re: Help with Boolean search using Solr parser edismax

Hi Erick, Yes. Currently I re-index the database on a weekly basis because we only have weekly release. As part of the Solr weekly re-index, the batch job will delete the /solr/core/data folder, restart Solr server, then re-index. We use Luigi to build/control pipelines of Solr re-index batch

Re: Help with Boolean search using Solr parser edismax

Hi Erick, Thank you very much for the clarification. I will keep it in my mind since we are now in the process of migrating MySQL database to mongoDB. Best Regards, Wendy a happy Solr user -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Help with Boolean search using Solr parser edismax

>From the ref guide: "Field names should consist of alphanumeric or underscore characters only and not start with a digit. This is not currently strictly enforced, but other field names will not have first class support from all components and back compatibility is not guaranteed." You need to

Re: Help with Boolean search using Solr parser edismax

Good morning, Emir, Thanks for letting me know that. I used dots to add tableName. as a field prefix because several columns from different tables have the same names. In your opinion, what will be the best way to replace dots? Happy Friday! Wendy -- Sent from:

Re: Help with Boolean search using Solr parser edismax

>From the reference guide: Field names should consist of alphanumeric or underscore characters only and not start with a digit. This is not currently strictly enforced, but other field names will not have first class support from all components and back compatibility is not guaranteed. Best,

Re: Help with Boolean search using Solr parser edismax

Hi Wendy, A bit off-topic, but forgot to mention in previous mail: dots in field names are not recommended. Even it obviously works for you, I think I’ve seen people reporting some issues caused by dot in field names (I cannot find some reference now). So, if you plan some system upgrade in the

Re: Help with Boolean search using Solr parser edismax

And the coupon has no expiration date on it (LOL). Thank you again, Emir! Best Regards, Wendy -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Help with Boolean search using Solr parser edismax

Hi Wendy, You are welcome! I’ll put your lunch coupon in my wallet, just in case I get hungry around NJ ;) Regards, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > On 1 Feb 2018, at 16:26, Wendy2

Re: Help with Boolean search using Solr parser edismax

Excellent!!! Thank you so much for all your help, Emir! Both worked now and I got 997 result counts back as the expected number :-) /rcsb/search?q=method:"x-ray*" "Solution NMR"=1 /rcsb/search?q=+method:"x-ray*" +"Solution NMR"=1 I will keep this in my mind regarding query with multiple

Re: Help with Boolean search using Solr parser edismax

Hi Wendy, Query now looks as expected but you are not getting results as expected. The reason for that is edismax’s mm parameter is what matters. You are setting it to 7 and you have two parts to match so it is always AND and you don’t have such documents. You can set it to 1 and it will be OR.

Re: Help with Boolean search using Solr parser edismax

Good morning, Emir, Here are the debug output for case 1f-a (q=method:"x-ray*" "Solution NMR"), 1f-b (q=+method:"x-ray*" +"Solution NMR"). both returned zero counts. It looks that the querystrings are the same. Thanks for following up on my post and your help! -- Wendy

Re: Help with Boolean search using Solr parser edismax

Hi Wendy, I was thinking of query q=method:“x-ray*” “Solution NMR” This should be equivalent to one with OR between them. If you want to put AND between those two, query would be q=+method:”x-ray*” +”Solution NMR” Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr &

Re: Help with Boolean search using Solr parser edismax

Hi Emir, Listed below are the debugQuery outputs from query without "OR" operator. I really appreciate your help! --Wendy ===DebugQuery Outputs for case 1f-a, 1f-b without "OR" operator= *1f-a (/search?q=+method:"x-ray*" +method:"Solution NMR") result counts = 0: *

Re: Help with Boolean search using Solr parser edismax

Hi Wendy, With OR with spaces OR is interpreted as another search term. Can you try without or - just a space between two parts. If you need and, use + before each part. HTH, Emir On Jan 31, 2018 6:24 PM, "Wendy2" wrote: Hi Emir, Thank you so much for following up with

Re: Help with Boolean search using Solr parser edismax

Hi Emir, Thank you so much for following up with your ticket. Listed below are the parts of debugQuery outputs via /search request handler. The reason I used * in the query term is that there are a couple of methods starting with "x-ray". When I used space surrounding the "OR" boolean search

Re: Help with Boolean search using Solr parser edismax

Hi Wendy, I see several issues, but not sure if any of them is the reason why you are not getting what you expect: * there are no spaces around OR and that results in query being parsed sometimes with OR, e.g. (pdb_id:OR\”Solution)^5 * wildcard in quotes - it is not handled as you expected - the

Re: Help with Boolean search using Solr parser edismax

Hi Emlr, Thank you for reading my post and for your reply. I updated my post with debug info and a better view of the definition of /search request handler. Any suggestion on what I should try? Thanks, Wendy -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Help with Boolean search using Solr parser edismax

Hi Emir, Thank you so much for your response. I updated my post with an image which display the configuration of the /search request handler. Any suggestions? Thanks, Wendy -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html

Re: Help with Boolean search using Solr parser edismax

Hi Wendy, It is most likely that you need to list fields that can appear in query using uf. The best way to see what is going on is to use debugQuery and you can see more details how your query is parsed. HTH, Emir -- Monitoring - Log Management - Alerting - Anomaly Detection Solr &