just tried "fq":"NOT year:[1900 TO 2000]"}}, on my data et and also worked as expected, mind if i ask why: (u_lastLendingDate_combined_ls_ns:([8610134693 TO 8611935823]))
there are ()'s around your range query? On Fri, Jan 24, 2020 at 11:01 AM David Hastings < hastings.recurs...@gmail.com> wrote: > having > fq=NOT field:value > works for me, > > On Fri, Jan 24, 2020 at 10:56 AM Sebastian Riemer <s.rie...@littera.eu> > wrote: > >> Hi all! >> >> >> >> Consider a query containing fq-params like this: >> >> >> >> "*fq*":["tenant_id:1", >> >> "u_markedAsDeleted_b:false", >> >> "u_id_s:[* TO *]", >> >> "(u_lastLendingDate_combined_ls_ns:([8610134693 TO 8611935823]))" >> ] >> >> >> >> This gives me a list of users, having a last lending date (somewhat >> encoded as long) in that given numeric range. >> >> >> >> Now, I’d like to get a list of users, **NOT** having a last lending in >> that given numeric range. >> >> >> >> I’ve tried adding NOT and ! to the respective fq-query-part without >> success. >> >> >> >> Additional info: the field is of type *long (TrieLongField)* and it is >> *multiValued**="true"* >> >> >> >> An example of the full query-string would be: >> >> >> >> start=0&rows=50&fq=tenant_id:1&fq=u_markedAsDeleted_b:false&fq=u_id_s:[* >> TO >> *]&q=*:*&facet=true&facet.missing=true&facet.sort=count&facet.mincount=1&sort=u_userName_cp_s >> desc&qf=u_userName_cp_s^20 u_displayName_cp_s^20 text^2 text_en text_de >> text_it&pf=u_userName_cp_s^100 u_displayName_cp_s^20 text^10&mm=100% >> >> >> >> Thank you for your input and a nice weekend to all of you! >> >> >> >> Please let me know if I did not share vital details! >> >> >> >> Mit freundlichen Grüßen >> >> Sebastian Riemer, BSc >> >> >> >> >> >> [image: logo_Littera_SC] <http://www.littera.eu/> >> LITTERA Software & Consulting GmbH >> >> A-6060 Hall i.T., Haller Au 19a >> >> Telefon: +43(0) 50 765 000, Fax: +43(0) 50 765 118 >> >> Sitz: Hall i.T., eingetragen beim Handelsgericht Innsbruck, >> Firmenbuch-Nr. FN 295807k, geschäftsführender Gesellschafter: Albert >> Unterkircher >> >> >> >> D-80637 München, Landshuter Allee 8-10 >> Telefon: +49(0) 89 919 29 122, Fax: +49(0) 89 919 29 123 >> >> Sitz: München, eingetragen beim Amtsgericht München >> unter HRB 103698, Geschäftsführer: Albert Unterkircher >> >> E-Mail: off...@littera.eu >> Homepage: www.littera.eu >> >> >> >> Diese Nachricht kann vertrauliche, nicht für die Veröffentlichung >> bestimmte und/oder rechtlich geschützte Informationen enthalten. Falls Sie >> nicht der beabsichtigte Empfänger sind, beachten Sie bitte, dass jegliche >> Veröffentlichung, Verbreitung oder Vervielfältigung dieser Nachricht >> strengstens untersagt ist. Sollten Sie diese Nachricht irrtümlich erhalten >> haben, informieren Sie bitte sofort den Absender durch Anruf oder >> Rücksendung der Nachricht und vernichten Sie diese. >> >> This communication may contain information that is legally privileged, >> confidential or exempt from disclosure. If you are not the intended >> recipient, please note that any dissemination, distribution, or copying of >> this communication is strictly prohibited. Anyone who receives this >> message in error should notify the sender immediately by telephone or by >> return e-mail and delete this communication entirely from his or her >> computer. >> >> >> >
