Re: Blank/Null value search in term filter

[Ahmet Arslan]

Hi Kishore,

Usually, query clause below is used for the task: 
(+*:* -queryField:[* TO *]) OR queryField:A

Ahmet




On Monday, September 5, 2016 2:33 PM, Kamal Kishore Aggarwal 
 wrote:
Thanks Ahmet for your response and nice suggestion.

But, I was looking if there any way out without making any configuration
change.

Please suggest.

On 02-Sep-2016 9:37 PM, "Ahmet Arslan"  wrote:

>
>
> Hi Kishore,
>
> You can employ an impossible token value (say XX) for null values.
> This can be done via default value update processor factory.
> You index some placeholder token for null values.
> fq={!terms f='queryField' separator='|'}A|XX would fetche docs with A or
> null values.
> Ahmet
>
> On Friday, September 2, 2016 2:03 PM, Kamal Kishore Aggarwal <
> kkroyal@gmail.com> wrote:
>
>
>
> Hi,
>
> We are using solr 5.4.1.
>
> We are using term filter for multiple value matching purpose.
> Example: fq={!terms f='queryField' separator='|'}A|B
>
> A, B, C are the possible field values for solr field "queryField". There
> can docs with null values for the same field. Now, how can I create a term
> filter in above fashion that fetches docs with A or null values.
>
> Please suggest.
>
> Regards
> Kamal
>

Re: Blank/Null value search in term filter

[Alexandre Rafalovitch]

If you only have 3 values, can you do negative queries on the ones you want
to skip?

Regards,
Alex

On 5 Sep 2016 6:33 PM, "Kamal Kishore Aggarwal" 
wrote:

> Thanks Ahmet for your response and nice suggestion.
>
> But, I was looking if there any way out without making any configuration
> change.
>
> Please suggest.
>
> On 02-Sep-2016 9:37 PM, "Ahmet Arslan"  wrote:
>
> >
> >
> > Hi Kishore,
> >
> > You can employ an impossible token value (say XX) for null values.
> > This can be done via default value update processor factory.
> > You index some placeholder token for null values.
> > fq={!terms f='queryField' separator='|'}A|XX would fetche docs with A or
> > null values.
> > Ahmet
> >
> > On Friday, September 2, 2016 2:03 PM, Kamal Kishore Aggarwal <
> > kkroyal@gmail.com> wrote:
> >
> >
> >
> > Hi,
> >
> > We are using solr 5.4.1.
> >
> > We are using term filter for multiple value matching purpose.
> > Example: fq={!terms f='queryField' separator='|'}A|B
> >
> > A, B, C are the possible field values for solr field "queryField". There
> > can docs with null values for the same field. Now, how can I create a
> term
> > filter in above fashion that fetches docs with A or null values.
> >
> > Please suggest.
> >
> > Regards
> > Kamal
> >
>

Re: Blank/Null value search in term filter

[Kamal Kishore Aggarwal]

Thanks Ahmet for your response and nice suggestion.

But, I was looking if there any way out without making any configuration
change.

Please suggest.

On 02-Sep-2016 9:37 PM, "Ahmet Arslan"  wrote:

>
>
> Hi Kishore,
>
> You can employ an impossible token value (say XX) for null values.
> This can be done via default value update processor factory.
> You index some placeholder token for null values.
> fq={!terms f='queryField' separator='|'}A|XX would fetche docs with A or
> null values.
> Ahmet
>
> On Friday, September 2, 2016 2:03 PM, Kamal Kishore Aggarwal <
> kkroyal@gmail.com> wrote:
>
>
>
> Hi,
>
> We are using solr 5.4.1.
>
> We are using term filter for multiple value matching purpose.
> Example: fq={!terms f='queryField' separator='|'}A|B
>
> A, B, C are the possible field values for solr field "queryField". There
> can docs with null values for the same field. Now, how can I create a term
> filter in above fashion that fetches docs with A or null values.
>
> Please suggest.
>
> Regards
> Kamal
>

Re: Blank/Null value search in term filter

[Ahmet Arslan]

Hi Kishore,

You can employ an impossible token value (say XX) for null values.
This can be done via default value update processor factory.
You index some placeholder token for null values.
fq={!terms f='queryField' separator='|'}A|XX would fetche docs with A or null 
values.
Ahmet

On Friday, September 2, 2016 2:03 PM, Kamal Kishore Aggarwal 
 wrote:



Hi,

We are using solr 5.4.1.

We are using term filter for multiple value matching purpose.
Example: fq={!terms f='queryField' separator='|'}A|B

A, B, C are the possible field values for solr field "queryField". There
can docs with null values for the same field. Now, how can I create a term
filter in above fashion that fetches docs with A or null values.

Please suggest.

Regards
Kamal

Blank/Null value search in term filter

[Kamal Kishore Aggarwal]

Hi,

We are using solr 5.4.1.

We are using term filter for multiple value matching purpose.
Example: fq={!terms f='queryField' separator='|'}A|B

A, B, C are the possible field values for solr field "queryField". There
can docs with null values for the same field. Now, how can I create a term
filter in above fashion that fetches docs with A or null values.

Please suggest.

Regards
Kamal