Stack Overflow
Stack Overflow

Questions tagged [multivalue]

The term "multivalue" refers to a nested data structure where a data column in a database table can contain multiple levels of nested columns.

In some databases, such as the namesake MultiValue database, an example of which is UniVerse, a number of top-level columns can be associated with each other, so that the data in, for example column 1, sub-column 2 has a direct relationship with the data in column 2, sub-column 2.

An example structure could look as follows:

Column one being order numbers, column 2 being order dates and column 3 being part numbers:


Column 1: 00001]00002]00003
Column 2: 26/07/12]27/07/12]28/07/12
Column 3: P123^P124]P125]P126

Multivalue data structures can often lead to excellent performance, one of the reasons being that they eliminate the need for resource consuming table joins.

Apart from the original MultiValue Databases, other examples which use multivalued data structures are many of the NoSQL databases and many Business Intelligence and Reporting tools.

342 questions
0
votes
1 answer

How to search over documents with 2 or more entries in multivalued field in Solr?

I have a schema that allows a multivalued field, how do I construct a search that only returns documents that have 2 or more entries in that field? for example in this subset of data: A …
Jorge Lazo
  • 388
  • 7
  • 18
0
votes
0 answers

Access - Cannot Clear Multi-Value Field Via Form Control

I have a relatively simple Access Form that I use to catalog items in a collection I have. It all works beautifully...most of the time. The one thing that I cannot seem to figure out this: I have one control bound to a Multi-Value field in a table…
cowboyish1
  • 3
  • 2
0
votes
1 answer

How to iterate over MultiValueMap of type where can be another MultiValueMap and so on

I want to iterate over a MultiValueMap of type where Any can be another MultiValueMap of type and the Any can be another MultiValeMap and so on. The code I have is to extract only the first level of the Map:- ("result"…
david419
  • 435
  • 3
  • 8
  • 18
0
votes
1 answer

Elasticsearch sort based on element in multivalue field

Is it possible to sort based on element existing in multi value field? Example: a) document with "111" put test/test/1 { "bit_position" : [ 1, 2, 3 ] } b) document with 010 put test/test/2 { "bit_position": [ …
Seperman
  • 4,254
  • 1
  • 28
  • 27
0
votes
2 answers

search for solr multivalued field over more than 1 fields

I have following structure of databse in solr 123 java JMD BBH RBH 120 …
Akhilesh
  • 57
  • 8
0
votes
1 answer

MultiValueDictKeyError at /registroEstudianteMayor/ "'Acudiente'"

I have this error MultiValueDictKeyError at /registroEstudianteMayor/"'Acudiente'" ", I searched a lot for an answer to this error but I couldn't find any. I have this controller: def post(self, request, *args, **kwargs): generos =…
Luis Fernando Salazar
  • 3
  • 1
0
votes
1 answer

Hide SSRS chart based on multivalue parameter

Good Afternoon, I have a multivalue parameter where if the last value in the array has the value "Reentry", it should always display the report. However, if the last value in the array is not "Reentry" it should hide the chart because it doesn't…
Mike C.
  • 11
  • 2
0
votes
2 answers

How to use more than one multivalued field in solr search

I have documents that has multivalue fields in my solr. I want to make search according to these multivalue fields. When I want to query with; http://localhost:8983/solr/demo/select?q=*:*&fq=id:FEAE38C2-ABFF-4F0C-8AFD-9B8F51036D8A it gives me the…
Mustafa Çakıroğlu
  • 1,618
  • 1
  • 11
  • 10
0
votes
0 answers

Solr - Join Query return array of values of a field

I am trying to get array of values of a field based on a join query , but return all the values from the second table . And my expected result is {"description":"", "id":479, "brand":"Lowepro", "mrp":4900, "name":"Lowepro Photo…
Anju
  • 15
  • 3
0
votes
2 answers

How to deal with multi-valued foreign key in SQL Server

I have a table Authors in SQL Server with Author_ID as primary key. Authors table structure Author_ID | Author_Name ---------------------------- 677 | Nuno Vasconcelos 1359 | Peng Shi 6242 | Z. Q. Shi ... | ... ... …
maliks
  • 1,102
  • 3
  • 18
  • 42
0
votes
0 answers

Filter query with multi-valuable field

I have a form name frm_Report_Filter for the user to enter the filter criteria. Then, I have a query named qry_NCR_Report_Finder to pull out data from a table: tbl_NCR, based on the criteria on frm_Report_Filter. The problem started when I tried…
Jason Chan
  • 45
  • 10
0
votes
2 answers

Solr field with tens of thousands of values

I have a multivalued solr field, which is only used to filter the search results. This field contains a number of groups and if the user belongs to one of this groups then this document will be in his search resalt.
MrLang
  • 629
  • 1
  • 6
  • 15
0
votes
1 answer

Manipulating data from a field with multi-valuable

I have a table with a field containing multi-valuable as shown below: In the form, I want to let the user enter a NCR_Num in the textbox then using VBA to do some input validation then add it to the "text_Pool" as shown below: This Text_Pool has…
Jason Chan
  • 45
  • 10
0
votes
1 answer

MS Access: lookup values for string-based multi-value field

Here is my situation: linked table (so I can't actually modify the column config) has a column with a comma-separated list of values. this is a text string -- not a true multi-value field. I need to map those values to a lookup table and return a…
lcdservices
  • 841
  • 1
  • 9
  • 20
0
votes
0 answers

Highlighting Mutivalue field returns String, not List

In Solr, I have several multivalue fields configured, but whenever I query them using highlighting, I get back a single result, instead of a list. For example, here's my…
mlissner
  • 17,359
  • 18
  • 106
  • 169
1 2 3
…
22 23