Hi Charlie, Care to elaborate on that a little? I can't seem to find any tool in that blog entry that formats a given solr query. What tool did you have in mind?
/Jimi -----Ursprungligt meddelande----- Från: Charlie Hull <char...@flax.co.uk> Skickat: den 8 januari 2019 15:55 Till: solr-user@lucene.apache.org Ämne: Re: Tool to format the solr query for easier reading? On 08/01/2019 04:33, Hullegård, Jimi wrote: > Hi, Hi Jimi, There are some suggestions in part 4 of my recent blog: http://www.flax.co.uk/blog/2018/11/15/defining-relevance-engineering-part-4-tools/ Cheers Charlie > > I often find myself having to analyze an already existing solr query. But > when the number of clauses and/or number of nested parentheses reach a > certain level I can no longer grasp what the query is about by just a quick > glance. Sometimes I can look at the code generating the query, but it might > be autogenerated in a complex way, or I might only have access to a log > output of the query. > > Here is an example query, based on a real query in our system: > > > system:(a) type:(x OR y OR z) date1:[* TO > 2019-08-31T06:15:00Z/DAY+1DAYS] ((boolean1:false OR date2:[* TO > 2019-08-31T06:15:00Z/DAY-30DAYS])) > -date3:[2019-08-31T06:15:00Z/DAY+1DAYS TO *] (((*:* -date4:*) OR > date5:* OR date3:[* TO 2019-08-31T06:15:00Z/DAY+1DAYS])) > > > Here I find it quite difficult to what clauses are grouped together (using > parentheses). What I tend to do in these circumstances is to copy the query > into a simple text editor, and then manually add line breaks and indentation > matching the parentheses levels. > > For the query above, it would result in something like this: > > > system:(a) > type:(x OR y OR z) > date1:[* TO 2019-08-31T06:15:00Z/DAY+1DAYS] ( > (boolean1:false OR date2:[* TO > 2019-08-31T06:15:00Z/DAY-30DAYS]) > ) > -date3:[2019-08-31T06:15:00Z/DAY+1DAYS TO *] ( > ((*:* -date4:*) OR date5:* OR date3:[* > TO 2019-08-31T06:15:00Z/DAY+1DAYS]) > ) > > > But that is a slow process, and I might make a mistake that messes up the > interpretation completely. Especially when there are several levels of nested > parentheses. > > Does anyone know of any kind of tool that would help automate this? It > wouldn't have to format its output like my example, as long as it makes it > easier to see what start and end parentheses belong to each other, preferably > using multiple lines and indentation. > > A java tool would be perfect, because then I could easily integrate it into > our existing debugging tools, but an online formatter (like > http://jsonformatter.curiousconcept.com) would also be very useful. > > Regards > /Jimi > > Svenskt Näringsliv behandlar dina personuppgifter i enlighet med GDPR. > Här kan du läsa mer om vår behandling och dina rättigheter, > Integritetspolicy<https://www.svensktnaringsliv.se/dataskydd/integrite > t-och-behandling-av-personuppgifter_697219.html?utm_source=sn-email&ut > m_medium=email> > -- Charlie Hull Flax - Open Source Enterprise Search tel/fax: +44 (0)8700 118334 mobile: +44 (0)7767 825828 web: www.flax.co.uk Svenskt Näringsliv behandlar dina personuppgifter i enlighet med GDPR. Här kan du läsa mer om vår behandling och dina rättigheter, Integritetspolicy<https://www.svensktnaringsliv.se/dataskydd/integritet-och-behandling-av-personuppgifter_697219.html?utm_source=sn-email&utm_medium=email>
