JSON does not have a binary data type, so true BLOBs are not possible in JSON.
Sorry, I wasn’t clear.
The payload I use is JSON in a string. It looks like this:
suggest: {
skill_names_infix: {
m: {
numFound: 10,
suggestions: [
{
term: "<b>m</b>icrosoft office",
weight: 14,
payload: "{"count": 1534255, "id": "microsoft office"}"
},
{
term: "<b>m</b>icrosoft excel",
weight: 13,
payload: "{"count": 940151, "id": "microsoft excel"}"
},
wunder
wunder
Walter Underwood
wun...@wunderwood.org
http://observer.wunderwood.org/ (my blog)
> On Apr 15, 2017, at 9:07 AM, OTH <omer.t....@gmail.com> wrote:
>
> Hi - just wondering, what would be the difference between using a blob /
> binary field to store the JSON rather than simply using a string field?
> Thanks
>
> On Sat, Apr 15, 2017 at 2:50 AM, Walter Underwood <wun...@wunderwood.org>
> wrote:
>
>> We recently needed multiple values in the payload, so I put a JSON blob in
>> there. It comes back as a string, so you have to decode that JSON
>> separately. Otherwise, it was a pretty clean solution.
>>
>> wunder
>> Walter Underwood
>> wun...@wunderwood.org
>> http://observer.wunderwood.org/ (my blog)
>>
>>
>>> On Apr 14, 2017, at 1:57 PM, OTH <omer.t....@gmail.com> wrote:
>>>
>>> Thanks, that works! But is it possible to have multiple payloadFields?
>>>
>>> On Sat, Apr 15, 2017 at 1:23 AM, Marek Tichy <ma...@gn.apc.org> wrote:
>>>
>>>> Utilize the payload field.
>>>>> I don't need to search multiple fields; I need to search just one field
>>>> but
>>>>> get the corresponding values from another field as well.
>>>>> I.e. if a user is searching for cities, I wouldn't need the countries
>> to
>>>>> also be searched. However, when the list of cities is displayed, I
>> need
>>>>> their corresponding countries to also be displayed.
>>>>> This is obviously possible with the regular Solr index, but I can't
>>>> figure
>>>>> out how to do it with the Suggester index, which seems to only be able
>> to
>>>>> have one field.
>>>>> Thanks
>>>>>
>>>>> On Fri, Apr 14, 2017 at 8:46 AM, Binoy Dalal <binoydala...@gmail.com>
>>>> wrote:
>>>>>
>>>>>> You can create a copy field and copy to it from all the fields you
>> want
>>>> to
>>>>>> retrieve the suggestions from and then use that field with the
>>>> suggester.
>>>>>>
>>>>>> On Thu 13 Apr, 2017, 23:21 OTH, <omer.t....@gmail.com> wrote:
>>>>>>
>>>>>>> Hello,
>>>>>>>
>>>>>>> I've followed the steps here to set up auto-suggest:
>>>>>>> https://lucidworks.com/2015/03/04/solr-suggester/
>>>>>>>
>>>>>>> So basically I configured the auto-suggester in solrconfig.xml,
>> where I
>>>>>>> told it which field in my index needs to be used for auto-suggestion.
>>>>>>>
>>>>>>> The problem is:
>>>>>>> When the user searches in the text box in the front end, if they are
>>>>>>> searching for cities, I also need the countries to appear in the
>>>>>> drop-down
>>>>>>> list which the user sees.
>>>>>>> The field which is being searched is only 'city' here. However, I
>> need
>>>>>> to
>>>>>>> retrieve the corresponding value in the 'country' field as well.
>>>>>>>
>>>>>>> How could I do this using the suggester?
>>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>> --
>>>>>> Regards,
>>>>>> Binoy Dalal
>>>>>>
>>>>
>>>>
>>
>>
