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

Passing multi-value string consisting of TFS area paths to subreport in SSRS

I'm having a problem with passing mulit-value argument to subreport. We have a report that is generating data from Team Foundation Server about velocity, burndown, bugs etc. The main report is pointing to a few subreports (for each team) were this…
D. Kuras
  • 145
  • 1
  • 1
  • 8
0
votes
1 answer

Apache Solr 6.5 Multi-valued field query

I have a Solr 6.5 index with schema: OrderId, OrderType, AirNumber & more.. My document looks like: "OrderId":"-7878676767676", "OrderType:"["Fee", "Insurance", "Air", "Fee"] "AirNumber":["", "", …
Preethi
  • 123
  • 8
0
votes
2 answers

SOLR how to define the data import handler for fields having several possible values per field?

I would like to create an index from my database data. Currently I use a SQL view for extract the data from the base. In my results I have an unique ID per result and each result can contains several possible another ids for one of the column that I…
Vicking
  • 27
  • 6
0
votes
1 answer

SSRS Multi-Value Blank Default Bug

I have a dataset that returns a '' (blank) value amongst the other records. This dataset populates a multi-value drop-down parameter and the "Allow blank value" checkbox is checked in the Report Parameters window. However, when I select Non-queried…
Riegardt Steyn
  • 5,431
  • 2
  • 34
  • 49
0
votes
2 answers

How to parse rdlc report Multivalue with ssrs

What I want to do I want to change rows background color if the column "NCRNumber"'s value is present in the multivalue parameter named listeRNC. Here's the SSRS I am using right now : = iif ((Parameters!listeRNC.Value.ToString() =…
TinkeringMatt
  • 181
  • 1
  • 9
0
votes
1 answer

Magnolia Multivalue Field- start with one option

I have created a multivalue field in a dialog and it looks like this when I initially open the dialog: Is there any way to have it display the field(s) necessary to create the first option when the dialog first opens? This is how we want it to…
Anne
  • 3
  • 1
0
votes
1 answer

Apache HTTPD mod_lua parseargs mutlivalue table not storing all values

I am currently writing a test harness that introduces delays, failures and proxying using httpd with LUA scripts. This includes the parsing of the querystring which could contain multiple values for the same tag ie:…
Stuart Kenworthy
  • 1
  • 2
0
votes
1 answer

multi-valued property query in GAE

class Person{ @Persistent private List tags = ArrayList() } I want to let the user query a person based on his/her tag, so I had my query filter like this: tags.contains(tagValue1) and if the user want to search for multiple tags, I would just…
Tim
  • 61
  • 2
0
votes
2 answers

SQL Using PIVOT for multi valued attributes

I designed an EAV table that looks like this: SID AID VID 1 1 1 1 2 1 1 3 2 1 4 3 1 1 2 SID stand for Subject ID, AID stands for Attribute ID and VID stands for ValuedID also a table to map the…
Norbert Forgacs
  • 605
  • 1
  • 8
  • 27
0
votes
0 answers

SSRS Report with Multi Valued Parameter returning blank page

I have a report with 1 date parameter and 3 multi select parameters. The parameters are not designed to be cascading parameters (where parameter 3 depends on value of parameter 2, etc). I've designed the report so users can select all values or…
user3566128
  • 13
  • 6
0
votes
1 answer

Optimize SQL query in VBA

I am trying to find the most optimized way to do this operation which runs an SQL statement in Access-VBA : SQl = "UPDATE " _ & "MainTable As T1 " _ & "INNER JOIN TableOfLists As T2 " _ & "ON (T2.SecondList = T1.MultiValuedList.value) " _ & "Set…
Seb
  • 508
  • 8
  • 25
0
votes
1 answer

Ms Access 2010 - mimic multivalued fields with real relationships

I've building a database in which I have a main table and then many-to-many relationships with this table. I want to have an easy way to, in a single view (preferably datasheet view), have the ability to supply all data to my tables (with all its…
chrillof
  • 325
  • 2
  • 15
0
votes
2 answers

Create counter with multiple variables that restart within each subgroup

I have a dataframe with two columns (ident and value). I would like to create a counter that restart every time ident value change and also when value within each ident change. Here is an example to make it clear. # ident value…
Demerzel
  • 15
  • 4
0
votes
1 answer

U2 Universe Update Multi value field errror

I am using the Universe U2.net toolkit to update the record in universe database. We have so far no issue with update to non multi value field with the following code Open_Again: Try db_connectionU2 = openConnU2() …
user3651809
  • 11
  • 2
0
votes
1 answer

Why are my default options not being checked off in SSRS?

Why is it that when I set up a multi value parameter in SSRS and default the value to more than one default value, those values are not checked off when the report runs? My parameter gets its values from a query specified in "Available Values". That…
Zolt
  • 2,761
  • 8
  • 43
  • 60
1 2 3
…
22 23