Submitted by WayneK on 2016/11/15 11:47
Can someone help me understand why duplicate items are showing up in my To Do grid?
 
I have my tasks organized into projects (TLI's).  Underneath these are subitems representing subprojects and individual tasks.  I have a column for categories and one for priorities.  I repeatedly use column filters to look at various categories and priorities.
 
After doing this a few times, I find new TLI's appearing that are duplicates of subitems.  They have the same Item ID as existing subitems, which still appear in their proper places.  If I move the dupe subitem to its proper location with its original version, the two items merge and the dupe disappears.
 
This is happening over and over again.  Any idea what I could be doing to cause this?
 
Wayne
 
 

Comments

I'll try again.  Original post lost because I inserted an image that was too large.  I'll try this without the image and can upload it if needed to understand.
 
I'm having duplicate items appear spontaneously when working in my To Do grid.  The items are subitems of projects but when the dupes appear, they're TLI's.  If I move the dupe to its correct location in the hierarchy, it merges with the original item and disappears. 
 
This occurs after I use column filters on my category and priority fields.  It's happened at least a dozen times.  Any idea what I'm doing that would create duplicates like this?
 
 
Wayne
 

Armando

2016/11/16 09:41

In reply to by WayneK

[quote=WayneK]
Here's the image.
 
Wayne
 
[/quote]
 
IIRC, this can happen in 2-3 situations. 
 
The first one is normal:
1- Source flat view  if hierarchies  are nevertheless expanded and the children meet the source criteria
 
The two other ones are slightly strange but defendable :
2- Source tree view
3- Normal view 
... but only if the items also appearing as TLIs have multiple parents and the parent under which they appear in current grid isn't the "main" ones. IQ seems to not take into account all parents when filtering out  items (shown as TLIs) that are also found under other TLIs
 
The Workaround is to filter those unwanted TLIs out with some other field.
-
IQ geek
Windows 8.1
CPU: Intel i5 2.6ghz

WayneK

2016/11/16 10:41

In reply to by Armando

Armando,
 
1) & 2) I wasn't using flat views or source tree views when they appeared.  I have experimented with those views a few times recently so I guess it's possible the dupes showed up some time ago and I didn't notice them. 
 
3) The items showing up don't have multiple parents.
 
I'll see if I can figure out what sequence of events causes them to occur.  If my memory is right, they showed up immediately after turning off column filters for priority and category.
 
Wayne
 

WayneK

2016/11/15 12:25

In reply to by Tom

Outline (normal)
Context parents: 9
Outline styles: none
 
Wayne
 
 
 

Hi Wayne,
 
Can you show a little more ? Main toolbar and top of the grid (so I can see the source, filters, display mode, etc)
Also, is the issue present when there is no column filter ?
 
Pierre_Admin
IQ Designer
 

WayneK

2016/11/15 14:35

In reply to by Pierre_Admin

Here you go.
 
Wayne
 

Tom

2016/11/16 06:23

In reply to by WayneK

There used be a bug where items would show twice, exactly like this. Didnt come across it much myself and thought it was *not* with outline mode but cant remember.
Armando would probably remember (?)
 
 

Pierre_Admin

2016/11/21 14:15

In reply to by WayneK

HI Wayne,
 
I got your file, thanks
The Todo grid has 6 main items. All other items are sub-items. Many of the sub-items meet the source (Todo is checked) but not all
 
The dupe is ID 5124. It has parent 5121 which itself has 3 parents (4406, 6838, 6932). Of these, the last 2 have a common parent (7315)
 
In your screenshot, ID 5124 was shown as a top level. I do not see how this can be, as it does not meet the grid source (i.e. it does not have a Todo date value)
Also, in your first screenshot, item 6838 is shown as a top level item, when it has a parent (7315). Again, this is not right
 
[Edit] From your second screenshot, I see that item 5124 has 4 values, so I assume that it had Todo checked at the time
Doing this, I was able to reproduce the issue. It is shown because its parent did not have Todo checked, so it wanted to put it as a top level so you would see it (as it was deep in the hierarchy)
 
The way the grid is populated is as follows
  1. Find all items that have Todo Checked
  2. Rearrange them based on hierarchy
  3. Check the item's main parent, grand parents, etc to see if they are in the grid
  4. If not, show the item as a top level item
So in this case, while 5124 has only 1 parent (5121), it itself as 3 parents, and the main parent (you've guessed it by now perhaps) is 4406, which is not in this grid. The other parents are (6838, 6932) have a parent which is in this grid (7315)
 
 
Pierre_Admin
IQ Designer
 

I believe I was able to duplicate what's happening. 
 
1) I start with Display Mode set to "Outline (normal)"
2) I switch Display Mode to "Source Items (flat list)"
3) I switch Display Mode back to "Outline"
 
When I did the above, 17 orphaned dupes were created.  Does that help explain what's happening? 
 
I'm assuming what seems obvious to me:  If you start in one display mode; switch to a different mode; then return to the first mode, then the display of items should exactly match what you started with.
 
Wayne
 

I merged the dupes with the originals, then closed the file and updated from 9.85 to 9.86b.
 
My first try of switching between Outline and Flat views did not create any dupes.  We'll see how it goes from here.
 
Wayne
 

Armando

2016/11/16 18:29

In reply to by WayneK

[quote=WayneK]
I merged the dupes with the originals, then closed the file and updated from 9.85 to 9.86b. 
[/quote]
 
Hi Wayne,
The dupes are really a "display glitch". They aren't real "dupes" (or "clones") -- you can confirm that as they had de same Iditem number.
(meaning that they don't need to be merged)
 
 
-
IQ geek
Windows 8.1
CPU: Intel i5 2.6ghz

WayneK

2016/11/16 18:44

In reply to by Armando

OK, but they don't go away unless I move them into the same subitem group as the "originals".  I tried refreshing the grid and restarting InfoQube but they were still there.
 
Wayne
 

Armando

2016/11/16 19:20

In reply to by WayneK

[quote=WayneK]
OK, but they don't go away unless I move them into the same subitem group as the "originals".  I tried refreshing the grid and restarting InfoQube but they were still there.
 
Wayne
 
[/quote]
 
After moving them into the same "subitem group", if you refresh the grid (F5), they reappear as TLIs?
 
-
IQ geek
Windows 8.1
CPU: Intel i5 2.6ghz

WayneK

2016/11/16 20:24

In reply to by Armando

As far as I know, as soon as I move them into the proper group of subitems, they disappear.  That's why I say they seem to "merge" with the originals.
 
I can't remember if I ever refreshed the grid after doing that.  I can't test it now because I haven't been able to re-create the problem with the latest update.

Wayne
 

Did you try to do a repair ?
 
 
Pierre_Admin
IQ Designer
 

WayneK

2016/11/16 20:43

In reply to by Pierre_Admin

Not before but I'm doing it now.
 
Wayne80

Copy from my previous post which is quite embedded in the post hierarchy:
 
-------------
 
From your second screenshot, I see that item 5124 has 4 values, so I assume that it had Todo checked at the time
Doing this, I was able to reproduce the issue. It is shown because its parent did not have Todo checked and its main parent path was not shown in the grid
 
The way the grid is populated is as follows
  1. Find all items that have Todo Checked
  2. Rearrange them based on hierarchy
  3. Check the item's main parent, main grand parents, etc to see if they are in the grid (this is called the main parent path or lineage)
  4. If not, show the item as a top level item
So in this case, while 5124 has only 1 parent (5121), it itself as 3 parents, and the main parent path (you've guessed it by now perhaps) is 4406 > 3251, which is not in this grid.
The other parents are (6838, 6932) have a parent which is in this grid (7315)
 
 
 
Pierre_Admin
IQ Designer
 

WayneK

2016/11/21 15:56

In reply to by Pierre_Admin

Thanks for the detailed investigation.  I'll have to work through this carefully to try to understand it.
 
The first thing I don't understand is:  if InfoQube was behaving correctly, why didn't it consistently show the same group of bogus "dupes" .  One time there would be 10+, another time there would be two or three.  Maybe it'll all become clear when I work through it.
 
Wayne
 

Pierre_Admin

2016/11/21 16:07

In reply to by WayneK

[quote=WayneK]
why didn't it consistently show the same group of bogus "dupes" .  One time there would be 10+, another time there would be two or three.  Maybe it'll all become clear when I work through it.
[/quote]
Most likely because you checked or unchecked the ToDo field for some items
So if none of the item's main parent path have ToDo as checked, then the item is shown as a top level item
 
Pierre_Admin
IQ Designer
 

Armando

2016/11/21 18:10

In reply to by Pierre_Admin

That's what I described up there (main parent "problem").
-
IQ geek
Windows 8.1
CPU: Intel i5 2.6ghz