Main Area and Open Discussion > General Software Discussion

SQLNotes...what is it exactly?

<< < (141/235) > >>

tomos:
You're welcome!
...
EDIT/
* in "WorkDone" I have files as Parent items but wont give them InvoiceIDs themselves
i.e. File has subitems that are given invoice number
- SQLNotes01.psd
- - Drawing of same - 2hrs - Invoice#200
-tomos (February 20, 2008, 11:33 AM)
--- End quote ---
Exactly. This is how I was imagining the structure.  :)
-Armando (February 20, 2008, 01:11 PM)
--- End quote ---

added a few more edits back there!

will try find, havent used it yet :-[
BTW I just made a filters grid myself this morning :)

must try out the "alike" as well...

Armando:
1- ANDable Named filters
2- Grid history. Move backwards/forwards in the grid setting history
-PPLandry (February 20, 2008, 01:15 PM)
--- End quote ---

Nice. I saw #1 in mantis and in the forum, but didn't know about #2. This should ease work flow quite a bit

Armando:
(I've decided to post here instead of the SQLNotes forum because I'm not receiving notices on a regular basis...)

I'm still struggling too with parents and children. I don't understand what I'm seeing.
 
1) Here are  my main settings.
- Item Saved --> OFF
- Context Parents -->OFF
- Hierarchy --> ON
 
No filter and 1 source (a yes/no field called "test").
 
2) I have 6 items (see the screenshot) :
 
1- Girl Rebecca
2- Girl Diane
3- Boy John
 
4- Mummy Rose
5- Daddy Bernard
6- 2nd Daddy Eugene


3) Ok, so here are the relationships in our family :

“Mummy Rose” is the parent of  all children :
- Girl Rebecca
- Girl Diane
- Boy John

“Daddy Bernard” is the parent of two children :
- Girl Rebecca
- Girl Diane

“2nd Daddy Eugene” is the parent of one child :
- Boy John

All the children have the same main parent : Mummy Rose.


4) According to my understanding the grid should look like that (when hierarchical view is enabled, with the settings described earlier):
 
--2nd Daddy Eugene
------ Boy John

--Daddy Bernard
------ Girl Rebecca
------ Girl Diane

--Mummy Rose
------ Girl Rebecca
------ Girl Diane
------ Boy John
 
 

But this is what I see (after refresh etc.) :



Why is that?

As you can see, Mummy Rose appears as the parent as only 2 children, while, in theory, she’s the (main) parent of three (and if you look at the screenshot you can also see that “Boy John” is selected and has 2 parents, his main one being “Mummy Rose”).

Mummy rose is the parent of 3 children, here's the proof  :) :



 :huh:

PPLandry:
For this to work fine, the children must not have test checked. Either that or set hierarchy off

I can explain why later if you want.

Armando:
Sure. Thanks Pierre. I removed the checks as you said, and yes, it works.

(But ... While I still don't understand why I should uncheck the "test" field for children, what I mostly don't understand is why -- when all the children also have the "test" field checked -- is the item "boy john" specifically not represented beneath its 2 parents... while the others are represented (and hence have "duplicates"). Anyhow, take your time!  :)).

Navigation

[0] Message Index

[#] Next page

[*] Previous page