Concat Fields in JSON Facet

[Zheng Lin Edwin Yeo]

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