Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Ideally, you should have only at most one copy of any object within the same view model. If you can help it, refactor your view model so your objects can reference an array/map containing all objects to minimize replication. Then your actual objects simply need to get the referenced objects.</p> <pre><code>var model = { _FooRefs: [99, 100], _PooRefs: [99], _AllObjects: [ { ID: 99, Title: 'This is item number ninety-nine', Description: 'This is an item included in more than one object' }, { ID: 100, Title: 'This is item number one-hundred', Description: 'This is an item included in only one object' } ] }; </code></pre> <pre><code>function ViewModel(data) { var self = this; ko.mapping.fromJS(data, { _AllObjects: { key: function (obj) { return obj.ID; } } }, self); self.Foo = ko.computed(function () { var fooRefs = ko.utils.unwrapObservable(self._FooRefs); return ko.utils.arrayMap(fooRefs, function (id) { // mappedGet was added to mapping plugin version 2.4.1 return self._AllObjects.mappedGet({ ID: id }); }); }); self.Poo = ko.computed(function () { var pooRefs = ko.utils.unwrapObservable(self._PooRefs); return ko.utils.arrayMap(pooRefs, function (id) { return self._AllObjects.mappedGet({ ID: id }); }); }); } </code></pre> <p><a href="http://jsfiddle.net/jeff1203/XZGek/" rel="nofollow">fiddle</a></p> <p>To add objects to the array, you need to ensure that the object exists in your array/map and then add the object's key to the array of references. To remove an item, remove the reference and optionally remove the object.</p> <hr> <p>If doing this is not an option and you'll need to keep the duplication, you can probably use the <a href="https://github.com/rniemeyer/knockout-postbox/" rel="nofollow">postbox</a> plugin to help keep the objects synchronized. This approach would be best if the objects exist in separate view models.</p>
    singulars
    1. This table or related slice is empty.
    1. POKnockout.js modifying an item with multiple locations in the viewmodel (aka: a 1-many relationship)
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJeff Mercado
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POKnockout.js modifying an item with multiple locations in the viewmodel (aka: a 1-many relationship)
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks for this. I'm refactoring my code to see if this would work. Having trouble with Adding and removing the items dynamically. Take a look here: http://jsfiddle.net/hMutz/5/. The self.addMember and self.removeMember methods are stumping me. Help would be appreciated.
      singulars
      1. PO
      1. USlamarant
    2. COI've updated the fiddle to demonstrate: http://jsfiddle.net/jeff1203/XZGek/3/. It could probably be designed better, it becomes quite a mess when you have to deal with the observables.
      singulars
      1. PO
      1. USJeff Mercado
    3. COThis is fantastic. I think both versions work but architecturally this is the proper way to represent the data in the viewmodel. I added some debugging info to the fiddle: http://jsfiddle.net/XZGek/5/. Appreciate the help!
      singulars
      1. PO
      1. USlamarant
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload