Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The FooBar thing confuses me so here is my example based on real world objects.</p> <p>ExpenseTransaction has attributes (date, trxDescription, category, amount).</p> <p>Category has a single attribute (name)</p> <p>ExpenseTransaction.category is a To-One relationship to Category (in other words a transaction can belong to only one Category).</p> <p>Category.transactions is a To-Many relationship to ExpenseTransaction (in other words many transactions can belong to the same Category).</p> <p>The UI for creating a new transaction or editing and existing one uses NSPopupButton to display the list of available Categories using the name attribute. For existing transactions the popup will display the selected transactions category.</p> <p>Bindings for the Category popup are as follows:</p> <p><strong>Content</strong> (Category.arrangedObjects)</p> <p><strong>Content Objects</strong> (Category.arrangedObjects) - we want to link to the actual category not its name because the attribute is a relationship not a string value</p> <p><strong>Content Values</strong> (Category.arrangedObjects.name) - we want the name to be displayed in the popup list</p> <p><strong>Selected Object</strong> (ExpenseTransaction.selection.category)</p> <p>Using your FooBar analogy:</p> <p>Category has a relationship to ExpenseTransaction, so Category has a property (transactions) that is a NSSet of ExpenseTransactions. Now this is pretty much the inverse of my arrangement so I don't really know how or why you would populate the popup with ExpenseTransaction objects because only one selected item in the popup could be related to the Category object when in fact you need the whole set to be related. However the other way around works just fine because the popup would contain a list of all the Foo items and so whenever you select a Bar item the corresponding Foo item could be selected from the popup.</p> <p>Hope this makes sense.</p>
    singulars
    1. This table or related slice is empty.
    1. POBinding an NSPopupButton to an NSArrayContraller with NSManagedObject subclasses
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDuncan Groenewald
    1. USDuncan Groenewald
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COMy use case is a little different to yours. I'm using the popup button simply to select which top level object is visible (called Bars in my confusing example) and I have created the Foo object merely to have an object that has a collection of all the Bars so I have something to bind an array controller to. What I have been trying to do is bind the popup to the selection in the arrangedObjects, as that's all it really is - a selection. Do you think it's because I need to store the selection onto a model that has an inverse like yours does?
      singulars
      1. PO
      1. USDownUnder
    2. COI tried binding the selection to a property in the window (given the selection is more to do with the view than the model) but while the popup does change what that property points to the popoup itself always says "no value".
      singulars
      1. PO
      1. USDownUnder
    3. COStill not sure I fully understand what your UI is trying to do but you may want to create two arrayControllers, FooArray and BarArray. Set both to Entity Mode and set the Entity names to Foo and Bar respectively. Now to ensure the BarArray contains only the items related to the selected item in FooArray set the BarArray Content Set binding to (FooArray.selection.bars) where bars is the To-Many relationship (property). Now the BarArray should only ever contain the subset of Bars related to the selected Foo item.
      singulars
      1. PO
      1. USDuncan Groenewald
 

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