If you filtered out the corresponding row from the DDDW matching the value of the column, DDDW will display data value because it doesn't have the row. If you select an item from the filtered DDDW, it will display the display value because the row exists in the DDDW.

As a workaround, duplicate the DDDW column inside the DW, overlay them one over the other, set their visible property based on the current row and - apply filter on one DDDW column and no filter on the other DDDW. Filtered DDDW will be visible for the current row only to validate input and unfiltered DDDW will be visible for all other rows to show display values (regardless of if the DDDW is filtered or not).

When you duplicate the column, do not change the column name given by the DW.

HTH

PowerObject!

Slight clarification.

Using Modify to protect the column immediately prior to the dddw causes the dddw to lose the display when first accessed.

Hi, James - 

Can you please supply us with a little more information:

What is the datatype of the column (sounds maybe that it is "time")?

Can you include a snapshot of the column's Edit Properties tab page in the DW Painter?

Can you show us the code that constructs the child DW filter expression and issues the SetFilter function?

When the initial filter is applied to the child DW, is the column's data value included or excluded from the filtered rows in the child DW?

Hi John,

I'm using Windows 10, PB 2019 R3 Build 2703.

1.  Data type of the column (index) is String (char 1)

2.  Properties:

  a.  Required

  b.  Always Show Arrow

  c.  AutoRetrieve (off)

  d.  DataWindow dddw_approval_status

  e.  Display Column  Approval_status

  f.  Data Column  idapproval_status

3.  Code:

datastore lds_staging
lds_staging = CREATE datastore
lds_staging.DataObject = "d_expense_staging_load"
lds_staging.SetTransObject (SQLCA)
lds_staging.Retrieve(il_master)
ii_approver = lds_staging.GetItemNumber(1, "stager")

For li_col = 1 to Long( Tab_1.TabPage_1.dw_1.Object.DataWindow.Column.Count )
Tab_1.TabPage_1.dw_1.Modify( "#" + String( li_col ) + ".Protect = 1" )
Next

ls_status = Tab_1.TabPage_1.dw_1.GetItemString(1, "status")

Choose Case ls_status
Case "S"
If ii_approver = g_loggedon_emp_no Then
Tab_1.TabPage_1.dw_1.Modify("status.Protect = 0")
Tab_1.TabPage_1.dw_1.Modify("return_reason.Protect = 0")
Else
Tab_1.TabPage_1.dw_1.Modify("status.Protect = 1")
Tab_1.TabPage_1.dw_1.Modify("return_reason.Protect = 1")
End IF
ls_filter = "idapproval_status= 'S' Or idapproval_status= 'A' Or idapproval_status= 'R'"
Case Else
Tab_1.TabPage_1.dw_1.Object.DataWindow.Readonly = True
End Choose

DataWindowChild child1
Tab_1.TabPage_1.dw_1.GetChild( "status", child1)
child1.SetTransObject(SQLCA)
child1.setfilter(ls_filter)
child1.Filter()
child1.Retrieve()

4.  All values from the dddw table are present.  The initial record retrieved has a Status of "S" for Submitted and it renders fine (display shows Submitted).  First click on the dddw then changes the display to "S" and the filtered displays all show in the dddw including Submitted.  Also, removing the filter and doing an auto retrieve makes the dddw work fine.

James

Just to be clear, there is only one row in the data window.  All values in the dddw are present for the filter, "S", "R", "A" and more.  I guess that's why it works the second and subsequent times.

I've tried placing the retrieve and filter statements in all different orders.  Nothing makes any difference.  Its like the first time the column gets focus it loses the display.