use parent's fields in column equation

Submitted by reesd on 2011/10/27 17:24
As discussed at http://www.sqlnotes.net/drupal5/index.php?q=node/2070#comment-9119, you can do something like the following to use more than one field of your children in your column equation.
 
Parents = mySum(IncludeField, children)

Function mySum(IncludeIt, x) ' Calculates the sum of the array x if IncludeIt is true
  dim d, i

  d=ubound(x)
  for i=0 to d
    if IncludeIt(i)=true then mySum = mySum+NZ(x(i))
  next

end Function

Show "plus/minus"-signs for collapsing/expanding

Submitted by mca1 on 2011/10/10 06:48
Hi there,
 
meanwhile I used IQ for about 2 month now and every day I am more impressed about the power under its hood.
 
The possibilty to modify the UI to certain degrees is very nice. What I would like to achieve by now is showing the typical "plus/minus" signs inside the grid instead of the ecco-like-buttons or that big black triangles.
 
I've seen screenshots in the online manual that included a very nice looking clean interface with those plus/minus signs.
Is there a way of modification to get them?

Filter in the sourceBar with a "Today"-Date

Submitted by mca1 on 2011/10/09 12:05
Hi there,
 
I need help with the following configuration:
 
I have a grid that is about to show...
a) all entries that have a checkmark in a specific yes/no - field
PLUS
b) all entries that have a date earlier than today in a specific date - field
 
 
I tried to set up a filter in the sourcebar like this
"PreSelected is not null"
to fulfill my first requirement. That works fine.
 
Now an extension like
"PreSelected is not null OR DTStartPlanned < Today
 
doesn't work.

Date entry problem in Property Pane

Submitted by Jon on 2011/10/01 17:40
Using W1.
 
1. In Property Pane, go to Forms. The form has to be long enough to scroll and the field in question needs to be toward the bottom of the form. The field in question also has to be a date field.
2. Click in the field, then the down caret to open the calendar. See what happens? The form field scrolls to the top.
 
This does not happen all the time, but it does happen frequently enough to be annoying.
 
Jon
 
EDIT: I see this happening sometimes when I first use the calendar to enter a date. However, it always happens if, after entering the date once, I change the date. So the steps to reproduce are the same as above, an if you don't see the Property Pane scroll to the top, repeat step 2.

Making "Shown In" available in fields

Submitted by jan_rifkinson on 2011/10/01 13:42
I had a use for this in a view I've created & thought I could add column "Shown In" like you see in search results but it didn't appear in fields so I guess it's not available. Is there a reason for that, am I missing  something, is it possible or does this replicate the discussion about a "home" column?  I see ItemHomeGrid but I don't know how it's populated? That might cover my needs but it's a mystery to me.  Thanks.

Last line in outline half visible or completely off the bottom of the screen

Submitted by Jon on 2011/09/29 10:47
I have meant to post this, but keep putting it off. I also though this was fixed some time ago.
 
If an outline becomes long enough to fill the screen and I continue to add lines, then the last line is partially or wholly hidden. I cannot see what is being typed until I adjust the outline. Very annoying.
 
Using version W.
 
Jon

Find

Submitted by Jon on 2011/09/29 09:04
1. If I search for an item throughout the file, I see the appropriate hits appear.
-BUT-
2. If I search for the same item and specify the current gid, no hits appear unless the outline within the grid is expanded enough to display the items. So, if the items are located several levels deep, but the outline is displaying two levels, no hits will register.
 
I think this behavior is inconsistent and wrong. If others agree, can this be corrected?
 
Jon 

Group by two columns possible?

Submitted by mca1 on 2011/09/29 04:14
Hi all,
 
I just wondered if it is possible to group by TWO columns or only by one...
I am well aware of the way I can group my entries by one column (via the sort bar), but as far as it seems, I cannot group by two columns, right?
 
Example: My sortbar contains: [EntryStatus] -- [EntryType]]
If I group by that, my entries are only grouped by EntryStatus, no second group (EntryType) comes up.. Is this not possible by now or am I doing something wrong here?
 
 
Thanx in advance.

"Sortbar" sort criteria overides "textbox sorting" when opening grid, even if sortbar is hidden.

Submitted by Armando on 2011/09/26 12:30
When opening a grid, if a sort criteria is in the sort bar, it'll sort according to that instead of the filter text box, even if the sort bar is not visible.
Don't know if this is by design or not, but it's not what I'd expect.
Thanks.
 
[EDIT :  Note that a refresh after the grid has loaded fixes the issue. The problem is there only when grid is first loaded]