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
3
votes
1 answer

PowerShell - regex for changing delimiter in multi-value field

I have a tab delimited data set as such (some columns removed but not relevant here): XYZ 12345671 18884 18912 222.00 222.00 Standard 2 CMD.1 ABC 12345672 18875 397.00 Standard 1 CMD.2 ABC 12345673 18889 18919 18950 …
Ryan.James
  • 47
  • 5
3
votes
1 answer

SSRS 2012: Cannot add multi value parameter '?' for dataset XYZ because it is not supported by the data extension

Scenario: I am working with a Firebird database (somewhat similar to MySQL) connected to Microsoft SSRS 2012 via ODBC connection manager. I have a huge stored procedure (which I am not supposed to modify at all) given by our client. The stored…
user3812887
  • 439
  • 12
  • 33
3
votes
2 answers

Apache Common MultiValueMap iteration

I have a MultiMap suppose Company which has String as a Key and another MultiMap suppose Employee as a Value. Employee Multimap has String as a key and another multimap as a value. My question is how do I retrieve and iterate multimap stored inside…
Mind Peace
  • 905
  • 8
  • 29
3
votes
2 answers

SSRS Multi-Value Parameter Not Selecting default value

How to set Default value in multi-value parameter when one of the parameter is not present in the Available Value In SSRS Report pleas Look this Image I have Multi-Value Parameter Name "Student Id" , available value are "1,2,3,4,5,6,7". Now I…
user3702431
3
votes
1 answer

Web Intelligence report error. #MULTIVALUE error

I've run into an issue with the WEBI report I am making. Here is the code in question: =If([Group Change Task Status Desc] = "Open") Then([Count of GCT]) ElseIf([Group Change Task Status Desc] = "Complete" And [SH Open Date Actual Dt] >= [Current…
woods
  • 243
  • 4
  • 10
  • 20
3
votes
3 answers

In Solr, How to query against one field for distinct set of values in a multi-valued field

I basically want Solr to search each record of the multivalued field for my search parameter.. read on for my example: I am using Solr to index my data. I have application data in parallel arrays (in the form of multi-valued fields) that match a…
Dan
  • 555
  • 3
  • 11
  • 16
3
votes
1 answer

How to find multivalued dependencies that not satisfy R?

I'm currently taking the course on DB and the theme is Relational Design Theory. Sub-theme is Multivalued dependencies and I'm completely lost in them :( I have such a question: R(A,B,C): A | B | C ---------- 1 | 2 | 3 1 | 3 | 2 1 | 2 | 2 3 | 2 |…
Viacheslav Kondratiuk
  • 8,493
  • 9
  • 49
  • 81
3
votes
2 answers

Using SSRS Expressions to see which options a user has selected from a multivalued parameter?

I'm trying to set up a filter against a "Totals" column in an SSRS report using an expression for the field. I have a multivalued parameter setup with the values value1, value2, value3, and value4 as options. Before the filter, this totals column…
Sev09
  • 883
  • 2
  • 12
  • 27
3
votes
1 answer

Solr, how to use the new field update modes (atomic updates) with SolrJ

Solr 4.x has this nice new feature that lets you specify how, when doing an update on an existing document, the multiValued fields will be updated. Specifically, you can say if the update document will replace the old values of a multivalued field…
Shivan Dragon
  • 15,004
  • 9
  • 62
  • 103
3
votes
3 answers

SSRS Grouping multiple tables based on Multi Value parameter

I have a report containing seven tables, each table returning a different set of values for a list of id's selected in a parameter list. I have the tables enclosed in a rectangle so that they print together. Now I would like to group the results…
user137542
2
votes
4 answers

C# & Linq: Grouping list members according to a list of values

I have a list of object which all expose a property of type IList. Now I want to group this list by the values of that list. So let say for example: OB1: Property is A, B, C OB2: Property is D, C, E OB3: Property is B, E, C As output I would…
user1147516
  • 37
  • 2
2
votes
1 answer

Solr query - array having at least one value not in a specific list

I need a way to filter query, in order to get documents containing array with at least one value not in a specific list. For example : { id:1, field:["dog", "cat", "bird"] }, { id:2, field:["cat", "bird"] }, { id:3, field:["bird"] } I…
Thomas Guillot
  • 21
  • 1
2
votes
1 answer

Keycloak multivalued attribute is not sent as array for some users

We are using KeyCloak as SSO directory for our application. We use OAuth 2.0 protocol. We have defined one custom attribute in KeyCloak, and this attributed has "MultiValued" properties on. Then, each user has multiple values entered as…
Alex Schneider
  • 33
  • 5
2
votes
1 answer

Drilling down (combination, via facets) on a Multivalued Solr field

I'm looking to drill down on a multivalued field that contains (space) delimited list of words; but still returning facets at each step of the drill-down. Example Table ID, Properties (multivalued field) 1, "Yellow Green Square" 2, "Yellow Round…
Typhon
  • 285
  • 3
  • 8
2
votes
0 answers

Match solr documents with exact one value in an multi valued field

I have an solr index with an multivalued field named colors, where all the colors stored, related to the document, like: colors: ["blue","red"] colors: ["blue" "brown", "green"] colors: ["blue"] Now I need to get only those documents, which has…
The Bndr
  • 13,204
  • 16
  • 68
  • 107
1 2
3
…
22 23