On 08/01/2019 09:20, Hullegård, Jimi wrote:
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?
This also does some basic URL splitting:
https://www.freeformatter.com/url-parser-query-string-splitter.html
Cheers
Charlie
/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>
--
Charlie Hull
Flax - Open Source Enterprise Search
tel/fax: +44 (0)8700 118334
mobile: +44 (0)7767 825828
web: www.flax.co.uk
