Hi,

So is there anyway which we can concat 2 fields together in JSON Facet?

Regards,
Edwin


On 16 January 2017 at 22:58, Zheng Lin Edwin Yeo <edwinye...@gmail.com>
wrote:

> Hi,
>
> I have been using JSON Facet, but I am facing some constraints in
> displaying the field.
>
> For example, I have 2 fields, itemId and itemName. However, when I do the
> JSON Facet, I can only get it to show one of them in the output, and I
> could not get it to show both together.
> I will like to show both the ID and Name together, so that it will be more
> meaningful and easier for user to understand, without having to refer to
> another table to determine the match between the ID and Name.
>
> I have tried to do something like the below, but it will only show the 2nd
> field.
>
> http://localhost:8983/solr/collection/select?q=*:*&json.facet={
>    item:{
>                  type:terms,
>                  field:itemId,
>                  field:itemName,
>                  limit:200
>     }
> }
>
> If I do the following, I'll get error.
>
> http://localhost:8983/solr/collection/select?q=*:*&json.facet={
>    item:{
>                  type:terms,
>                  field:itemId;itemName,
>                  limit:200
>     }
> }
>
>
> This will probably work, but it will greatly increase the size of the
> output, as 2 buckets will be produced.
>
> http://localhost:8983/solr/collection/select?q=*:*&json.facet={
>     itemId:{
>                  type:terms,
>                  field:itemId,
>                  limit:200
>     },
>     itemName:{
>                  type:terms,
>                  field:itemName,
>                  limit:200
>     }
> }
>
>
> Is there any way which I can do to concat both the itemId and the itemName
> into a single JSON together?
>
> Regards,
> Edwin
>
>

Reply via email to