Stack Overflow
Stack Overflow

Questions tagged [function-query]

14 questions
5
votes
2 answers

How can I multiply the score of two queries together in Elasticsearch?

In Solr I can use the query function query to return a numerical score for a query and I can user that in the context of a bf parameter something like bf=product(query('cat'),query('dog')) to multiply two relevance scores together. Elasticsearch has…
JnBrymn
  • 24,245
  • 28
  • 105
  • 147
2
votes
0 answers

Solr group query based on the sum aggregation of function query

I have tried to implement the Page and Post relation in single Solr Schema. In my use case each page has multiple posts. Page and Post fields are as follows: Post:{post_content, owner_page_id, document_type} Page:{page_id, document_type} Suppose I…
Ali
  • 1,759
  • 2
  • 32
  • 69
2
votes
1 answer

Function_score using score_mode inside a bool query as max but working like sum?

I am using function_score so that i can use its score_mode as maximum score of the bool query i am using actually i have two boolean query inside should now i want the score of the document to be the maximum score among both queries my code is given…
aman verma
  • 732
  • 1
  • 8
  • 26
1
vote
2 answers

ARRAY_LITERAL error when Query Array Function stacking multiple google form responses

So I have a unique problem. I have a Google form used for site inspections that allows up to 25 "issues" to be entered per Form submission. As normal, when submitted the issues are recorded in a single row in the spreadsheet. To more easily be able…
J.Raab
  • 87
  • 7
1
vote
1 answer

How to change score use add field value on Solr result?

I'm used Solr 6.1, I need customized the score in every result, this is Original result: [ { "_id": "59d2face138d070c14fccd0d", "plusrnak": 44.623055, "score": 80.439298 }, { "_id":…
ZivHus
  • 67
  • 1
  • 11
1
vote
1 answer

How to filter on Solr score from functionquery

I have a Solr instance, and I want to compute my own score for each document, using Solr functionqueries. As an example, say that I have the following query: q={!func}termfreq('text', 'foo') When I do this, my result has a numfound that is the…
Boris
  • 5,094
  • 4
  • 45
  • 71
0
votes
1 answer

How to write a select function for converting table data to JSON?

I am using postgresql sp function for getting table data in JSON format. But i am getting this error. structure of query does not match function result type DETAIL: Returned type json does not match expected type uuid in column 1. CONTEXT: SQL…
Nithesh Kumar
  • 3
  • 2
0
votes
0 answers

In Google Sheets, is there a way I can put an if function for columns

I hope I can explain well as I cannot post pictures. I have a google sheet where i have 4 columns with dates Job Start Date - Col53 Break Date - Col54 Return Date - Col55 Job End Date - Col56 The first 52 columns are personal details of employees…
devanshah
  • 1
0
votes
0 answers

Can't read query() function return values from cells with google apps script

I get a small table into my sheet as query() result from huge database and can use these values in other formulas, copy them, etc. But I can't do the same thing using google apps script because it just can't read these values into my variables. I…
user9882409
0
votes
1 answer

Whats wrong with my code Laravel Callback function GroupBy Month

Im going to count my pallet_condition 0,1,2,3 and group it by month but i always got an error like this please help whats wrong with my code. something wrong with my date_format? My Error SQLSTATE[23000]: Integrity constraint violation: 1052 Column…
BlackLeaf
  • 23
  • 1
  • 7
0
votes
1 answer

Could we add custom function query in Azure search like Solr FunctionQueries

I have building search engine of a website by Azure search and need to add some complex logic rule in searching. It's can be written easily in programming languages: C#, python...but hard in query syntax. I saw Solr has feature like FunctionQueries…
khangcv
  • 81
  • 2
  • 8
0
votes
1 answer

Query to View only top counts and counted by group

I wanted to use this query =query(G2:I80,"select G,H,I where H=max(H) group by I",-1) From this: Cdd Cts T NWH 4 A1 LBB 3 A1 MP 3 A1 DC 2 A1 AK 10 A10 CC 3 A10 SC 2 A11 JL 1 …
cokenol
  • 19
  • 7
0
votes
1 answer

Is there a way to make this type of query work?

=query(G2:I80,"select G,H,I where H=max(H) group by I",-1) Columnn G is names Column H is vote count and Column I is Their respective teams. I want to view the top voted names of each team and sometimes the some top voted names are tied so I wanna…
cokenol
  • 19
  • 7
0
votes
1 answer

Solr : How to add conditions in Boost function query

I'm trying to see if it's possible to use conditions within a Solr boost function query. Right now,I'm using the following function to boost on Likes data. bf=recip(ms(NOW/DAY,PublishDate),3.16e-11,1,1)^2.0 sum(Likes,2) What I would like to do is…
Shamik
  • 1,671
  • 11
  • 36
  • 64