• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • First() - Aggregate Function? Aggregate Function!?!

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (1)

Resolved First() - Aggregate Function? Aggregate Function!?!

  1. Issue
0
Votes
Undo
  1. John Strano
    John Strano
  2. PowerBuilder
  3. Thursday, 21 June 2018 20:29 PM UTC
So for the first time in 28 years of PowerBuilder, I have need of the First() method in a DWo expression.
 
You know where I'm going with this right?
 
Maybe I don't expect an answer; maybe I'm just in denial, but...
 
It's an aggregate function?!?!?!
 
OK, so I wish we were at a bar, or in the driveway with the hood of the pickup open with beers in hand to say, "yuh, yuh. There's yer problem."
 
Left ( ColumnA, 6 ) = 'wabbit' AND pos(first(ColumnA for all), 'Murgatroyd') > 0
 
...so this filter expression is null and void because PowerBuilder considers First() an aggregate.
 
Can anyone think or (or has already thought of) a work-around/-through , an equivalent?
 
Want to have the filter kick in, but only when the first row's value for that column is "Murgatroyd".
  1. DataWindow
  2. Expression
  3. Filter
how to reset a treeview?
Migrating PFC from 2017 Git
Accepted Answer
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Thursday, 21 June 2018 20:39 PM UTC
  2. PowerBuilder
  3. # Permalink

You could say it is an aggravate function.

Since you are doing 'for all', you should be able to use column_name[1] .

Comment
Load more comments
David Peace (Powersoft)
  1. David Peace (Powersoft)
  2. Friday, 22 June 2018 09:09 AM UTC
Simple when you know how

  1. Helpful
John Strano
  1. John Strano
  2. Friday, 22 June 2018 12:24 PM UTC
Odd that the offset is required when the docs say that the first row will be used if the offset is omitted.



Thanks again!



This should allow the filter expression for DWO syntax to include only a context where the processing can be specified to narrow the result set to the desired presentation style.

  1. Helpful
John Strano
  1. John Strano
  2. Friday, 22 June 2018 12:27 PM UTC
@ David - Isn't that life all over! =Legacy emoji

  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from this question.