Wanted to lookup a list of directives, but the list doesn’t populate until you mouse over it.
Thought maybe it was just something odd going on so I rebooted my PC and recreated the query but it has the same issues.
Anyone have any idea what is going on here and can point me in the right direction?
It’s a column of data in your 3rd row there causing it. What does the query look like. Usually it’s data so large in a single cell that it breaks infragistics, or an image column.
It’s the BPDirective table with no criteria. There’s only 448 rows when ran wide open.
I changed it to show only those with IsUpToDate = false and that makes it only 11 rows.
Same performance.
edit it’s 498 not 448 wide open
If I specifically exclude that row, it still has the same performance.
Get rid of the thumbnail column to start
And the body row.
bup bup bup one change at a time @klincecum simmer down meo.
@TDray he’s right though that’s the next column if it still does it.
I removed the thumbnail and it still had the same performance.
Removed the body column and it fixed it.
Thank you both for your help. Greatly appreciated.
I’ve already made this BAQ before 
lol
#First
