-
Avory Rose Pastoral
- PowerBuilder
- Thursday, 2 September 2021 04:15 PM UTC
Hello,
I'm having trouble with .setfilter function. Well, I manage to make it work. What seems to be my problem is that I have a dropdown list and a datawindow. Everytime I clicked or picked on that dropdown the value will filter in my datawindow and I have that "ALL" item on my dropdown list when I picked that supposed to be it will go back to the original data in the datawindow which didn't filter anything but it's showing nothing. I know I'm missing some logic on my script. Any help would be very much appreciated. Thank you so much!
Here is what I have. I attached the image also for your reference.
string s_colname, s_criteria, s_null, s_dtefrom, s_dteto, ls_datefrom, ls_dateto, ls_filter, s_sysrefno
datetime dt_from,dt_to
long l_count, l_row
int i_sort
datawindowchild dwc_child, dwc_station
s_colname = this.getcolumnname()
this.accepttext()
setnull(s_null)
Choose case s_colname
case "station"
this.accepttext()
is_station = this.getitemstring(1,'station')
// in this part what im trying to do is to reload the datawindow without the filter.
if is_station = '' or isnull(is_station) or is_station = '000' then
messagbox("",is_station)dw_activate_spots.retrieve(is_sysrefno)
//dw_activate_spots.reset()
return
end if
this.getchild('station',dwc_station)
s_criteria = is_station
dw_activate_spots.SetFilter("ordd_stncde = '"+ s_criteria +" '")
dw_activate_spots.filter()
// "ordd_stncde = '"+ is_station +" '"+ " AND " + "ordd_teledte >= Date('" + String(idt_from, "mm/dd/yyyy") + "')" + " AND " + " ordd_teledte <= Date('" + String(idt_to, "mm/dd/yyyy") + "')"
end choose
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.