1. Chen Mey Lee
  2. PowerServer 2020 or older (Obsolete)
  3. Tuesday, 6 April 2021 08:57 AM UTC

Hi,

Run PowerServer web in my desktop SetFilter() is not working but run in  web server is worked fine.

Below is filter value :-

dw_list_detail.ShareDataOff()
dw_trans_info.ShareDataOff()
dw_list.SetFilter(ls_filter_edit_row)
dw_list.Filter()
dw_list.ShareData(dw_list_detail)
dw_list.ShareData(dw_trans_info)

 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 6 April 2021 18:46 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 1

Hi Chen May;

  FWIW:  I am surprised that this worked in the first place. You would not turn the ShareDataOff() before a SetFilter() & then Filter() sequence - even in native PB. Note that Sorting and Filtering only works on the secondary DWO and not the primary one where the data is coming from.

Regards ... Chris

Comment
  1. Olan Knight
  2. Tuesday, 6 April 2021 21:22 PM UTC
I am surprised by this, Chris.

It seems that a DW with ShareDataOff() performed on it maked the dw....a normal dw. You can SetFilter() then Filter() normal datawindows all day long.



I'd think that doing the SetFilter()/Filter() on the normal dw PRIOR TO sharing the data would be the way to go in order to filter both datawindows.

  1. Helpful
  1. Chris Pollach @Appeon
  2. Tuesday, 6 April 2021 21:27 PM UTC
Hi Olan;

Filtering on the primary vs secondary DWO can be done as well before the ShareData but that might not be logically possible the PB App may be using other ShareData's over to other DWO's that may require the entire primary DWO's Primary buffer to remain "intact". ;-)

Regards ... Chris
  1. Helpful
  1. Chen Mey Lee
  2. Wednesday, 7 April 2021 01:09 AM UTC
This issue only occur when calling outside web server.
  1. Helpful
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 6 April 2021 19:05 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # 2

Aside from what Chris says, just an observation.

On the messagebox in your picture you can see ...plan_ind='Q ' ... including a space after the Q. Are you sure that is correct?

Maybe the difference between your desktop connection and your powerserver connecting is in the dbparms of sqlca.

Maybe you are missing the parameters which trims trailing blanks?

Does SetFilter() and / or Filter() return a -1 value?

regards

Comment
  1. Chris Pollach @Appeon
  2. Wednesday, 7 April 2021 18:26 PM UTC
Hi Miguel ... Even PowerSoft always recommended YYYY-MM-DD since PB 1.0. PB "loves" ANSI standards. ;-)
  1. Helpful
  1. Miguel Leeuwe
  2. Wednesday, 7 April 2021 18:28 PM UTC
Thanks, so do I.
  1. Helpful
  1. Miguel Leeuwe
  2. Wednesday, 7 April 2021 18:32 PM UTC
.. Though the fact that powerbuilder accepts more than one format string for a date / datetime function doesn't really prove what you are saying in my humble opinion.

:)
  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.