You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@lucene.apache.org by "Vincenzo D'Amore (Jira)" <ji...@apache.org> on 2019/11/04 14:40:00 UTC
[jira] [Updated] (SOLR-13863) New query function for string payload
field (delimited_payloads_string)
[ https://issues.apache.org/jira/browse/SOLR-13863?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vincenzo D'Amore updated SOLR-13863:
------------------------------------
Description:
New query function to read and sort string payload field (delimited_payloads_string)
I have the per-store pricing problem but payload function handles only numbers.
Stores can also be in different countries, for example would be useful having with the price also the currency and other attributes related to the store.
We could have a new function query named *spayload* that helps to read and sort payload field *delimited_payloads_string*.
Example document:
{
{{ "id":"my sample doc",}}
{{ "currencyPayload":[}}
{{ "store1|EUR",}}
{{ "store1|USD",}}
{{ "store3|GBP"}}
{{ ]}}
}
Querying Solr with
{{fl=spayload(currencyPayload,store3)}}
would generate a response like the following:
{
{{ "response": {}}
{{ "docs":[}}{
{{ "id":"my sample doc", }}
{{ "spayload(currencyPayload,store3)":"GBP"}}
{{ }]}}
}
{{}}}
And executing `spayload(payloadCurrency,store2)` returns `EUR`, and so on.
You can use `spayload` even as sorting function.
{{sort=spayload(payloadField,value) asc}}
was:
I started to use payloads because I had the classical per-store pricing problem.
But payload function handles only numbers, but stores can also be in different countries, I mean for example would be useful also have the currency and other attributes related to the store.
Adding a function query named *spayload* that helps to read and sort payload field *delimited_payloads_string*.
Example document:
{
{{ "id":"my sample doc",}}
{{ "currencyPayload":[}}
{{ "store1|EUR",}}
{{ "store1|USD",}}
{{ "store3|GBP"}}
{{ ]}}
}
Querying Solr with
{{fl=spayload(currencyPayload,store3)}}
would generate a response like the following:
{
{{ "response": {}}
{{ "docs":[}}{
{{ "id":"my sample doc", }}
{{ "spayload(currencyPayload,store3)":"GBP"}}
{{ }]}}
}
{{}}}
And executing `spayload(payloadCurrency,store2)` returns `EUR`, and so on.
You can use `spayload` even as sorting function.
{{sort=spayload(payloadField,value) asc}}
Summary: New query function for string payload field (delimited_payloads_string) (was: Add a query function that helps to read and sort string payload field (delimited_payloads_string))
> New query function for string payload field (delimited_payloads_string)
> -----------------------------------------------------------------------
>
> Key: SOLR-13863
> URL: https://issues.apache.org/jira/browse/SOLR-13863
> Project: Solr
> Issue Type: New Feature
> Security Level: Public(Default Security Level. Issues are Public)
> Components: query parsers, search, SearchComponents - other
> Reporter: Vincenzo D'Amore
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> New query function to read and sort string payload field (delimited_payloads_string)
> I have the per-store pricing problem but payload function handles only numbers.
> Stores can also be in different countries, for example would be useful having with the price also the currency and other attributes related to the store.
> We could have a new function query named *spayload* that helps to read and sort payload field *delimited_payloads_string*.
> Example document:
> {
> {{ "id":"my sample doc",}}
> {{ "currencyPayload":[}}
> {{ "store1|EUR",}}
> {{ "store1|USD",}}
> {{ "store3|GBP"}}
> {{ ]}}
> }
> Querying Solr with
> {{fl=spayload(currencyPayload,store3)}}
> would generate a response like the following:
> {
> {{ "response": {}}
> {{ "docs":[}}{
> {{ "id":"my sample doc", }}
> {{ "spayload(currencyPayload,store3)":"GBP"}}
> {{ }]}}
> }
> {{}}}
> And executing `spayload(payloadCurrency,store2)` returns `EUR`, and so on.
> You can use `spayload` even as sorting function.
> {{sort=spayload(payloadField,value) asc}}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@lucene.apache.org
For additional commands, e-mail: issues-help@lucene.apache.org