• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to Filter DataWindow Child by Row's Condition?

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

Resolved How to Filter DataWindow Child by Row's Condition?

  1. How-to
0
Votes
Undo
  1. V F
    V F
  2. PowerBuilder
  3. Wednesday, 22 November 2023 07:17 AM UTC

 

Hi...

 

How can filter the DataWindow Child options by each row's value?

 

For example the table (Grid DataWindow) below, how can filter and the SubCategory options based on selected Category?

ID Category SubCategory

1

 

A

 

A1

A2

2

 

 

B

 

 

B1

B2

B3

 

TBH

 

Handling DB connection failures
Hyperlink in Datawindow cell
Responses (1)
John Raghanti
John Raghanti Accepted Answer Pending Moderation
  1. Wednesday, 22 November 2023 12:20 PM UTC
  2. PowerBuilder
  3. # 1

Hi. Are you talking about the SubCategory being a DropDownDW (dddw)? 

The dddw is defined at the datawindow level, so if you try to filter it or change the definition, it will change it for all rows.

Thinking about it, as long as the Display Value is exactly the same as the Data Value, you could filter the dddw on RowFocusChanged. That wouldn't work if the Display Value is different from the Data Value because for all rows that were filtered out, the user would see the Data Value in the UI.

 

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 23 November 2023 16:50 PM UTC
Adding to what John said, if you want to filter DropDownDataWindow PB 2022 R2 and newer now supports this through simple properly configuration: https://docs.appeon.com/pb/whats_new/Autocomplete_for_DDDW_DDLB.html
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.