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

Nested multivalue field

These three fields are part of multivalue field, but I need to make the field Business Groups a multivalue field as well, which should save its values as a list. See my configuration But the problem is that I can't save the values and I get…
user2390742
  • 117
  • 1
  • 14
0
votes
1 answer

Multifield in magnolia

I want to make a multifield in magnolia. See my configuration below But when I open my dialog, it is empty and doesn't contain any fields except the buttons and in the tomcat log I see the following errors: Can't set property [transformerClass] to…
user2390742
  • 117
  • 1
  • 14
0
votes
0 answers

How to design SSRS report to filter multi-value parameter?

I developed an RDL which takes a multivalue parameter and I want to set a visibility expression or filter based on this parameter. This parameter uses an "All" value equal to '660E4583-7F29-4D37-8038-5096AE6A1A7F'. I want to make the main tablix…
salvationishere
  • 3,461
  • 29
  • 104
  • 143
0
votes
1 answer

I'm not getting matches on my multiValued fields

I'm not getting matches when using edismax defType and multiValued fields. explicit edismax
Tom
  • 23
  • 7
0
votes
1 answer

Elasticsearch query to select all documents where one field's value is contained multi-valued field

Is there a way to query elastic search for all documents that contain the value of one property in the multivalued field; i.e.: I have a list of property values in field COLORS: Red, Blue, Black, Green another property has a single value in field…
Alex Smirnov
  • 537
  • 1
  • 5
  • 12
0
votes
1 answer

SSRS drop down and input parameter

I am creating an SSRS report in Visual Studio 2008 and I was wondering if it is possible to have a drop down parameter that also allows user input. I have done a lot of research and haven't found anything that talks about this issue. I have a…
ola
  • 882
  • 2
  • 12
  • 29
0
votes
0 answers

How to join with a column having comma separated values

I have written a query that joins multiple table and gets the result in the below format. 16-Jan-14 16-Jan-14 4 9860,9846,9861,11040,11038,11043 100 The comma separated values is a single column. Now I want to map this csv in the column to their…
user3243766
  • 1
  • 1
0
votes
1 answer

SheepIt: Data injection on multiple values per duplicated form?

I have two fields I want to duplicate using SheepIt: Email-Address and Email-Address-Type. These should be duplicated every time. I have this working already, here is the HTML:
…
Bing
  • 3,071
  • 6
  • 42
  • 81
0
votes
0 answers

Querying LDAP multivalue attribute for entries which doesn't contain specific value alone

Let's say my LDAP has a multivalue-attribute foo. Foo contains one or more strings, each ending with a 2 digit number, from 01 to 99: dn: object1 foo: text$01 foo: text$02 foo: text$03 dn: object2 foo: text$03 To exclude all objects where foo…
Dennis
  • 1
  • 2
0
votes
1 answer

Doing a SSRS snapshot in C# with multi value

Trying to create a SSRS snapshot from C# code. It works fine except when the parameter in the report is a multivalue parameter. How should the multi value field be set up? parameters[0] = new ReportParameter(); parameters[0].Name =…
Peter
  • 23
  • 4
0
votes
3 answers

php preg_match - multivalue pattern

iam using preg_match as follows: case 1: pattern has two words. with the preg-match solution - it return two results. case 2: pattern has three words. with the preg-match solution - it return two results. in my opinion case 2 will return only one…
gammacode
  • 3
  • 3
0
votes
1 answer

Populating multi select control from multiple values when form opens in AX

I need to populate multi select dropdown from multiple values from table like this value1;value2;value corresponding to each record (which is in list box). When I select any record in list, the value of multiselect combo box changes corresponding to…
QAA
  • 1
  • 3
0
votes
1 answer

Displaying a multivalued list box/combo box in Access 2010

I have a table containing information about teachers for a university. One of the fields is a multivalued list box containing choices for the types of students that the person teaches (pre doctoral/post doctoral/residents etc). I an trying to…
Mike D
  • 23
  • 4
0
votes
1 answer

Sphinx multi value attribute filter

Yes, each tag has unique Id. It is not necessary that I have to store these unique id's in a table. I can store them in this way… $tags = array("Music","Sports","Food","Books",………) Array is the best way for me as it is easily alterable. Moreover…
Jay
  • 744
  • 4
  • 14
  • 30
0
votes
1 answer

Unable to use Sphinx MVA sql_attr_multi

I have a field called "tags" and it has values (say) "Music, Art, Sports, Food" etc. How can I use setFilter function in PHP-Sphinx for this field. I know that it has to be an integer and should be used as an array in PHP. So, if I use a numeric…
Jay
  • 744
  • 4
  • 14
  • 30
1 2 3
…
22 23