Questions? Feedback?powered byOlark live chat software
Bug 2844

sort with computed fields in a datawindow are loosing in PB 2019 08 January, 2020

Juan Pedro Sanz Diez
11 June, 2019
Product: PowerBuilder Category: DataWindow
Version: 2019 Build:
Classification: Appeon bug Publishing: Public
Priority: P1
Status: Closed Reason: FIXED
Ken Guo @Appeon 08 January, 2020
Hi Juan,

Glad to hear that. We will close this ticket! 
If you have any further question, please open a new ticket.

Regards,
Ken
Juan Pedro Sanz Diez 08 January, 2020
(In reply to Ken Guo from comment #14)
Hi Juan,

Good news that Appeon PowerBuilder 2019 MR (build 2170) has been officially
released. The issue you reported has been fixed in this release. Please
download and install it to verify your reported issue and let us know if any
problems. 
You can get the installer from our Downloads portal at
https://account.appeon.com/download/2019 (login required). 
Upgrade Notes:
If you are currently using PowerBuilder 2019 (build 2082 or 2151), please
directly apply this MR (build 2170) on the top of your current 2019.

We welcome all feedback from you!

Regards,
Ken
We have downloaded, installed and checked it out and it Works fine!!! You can close the ticket Thanks!!!
Ken Guo @Appeon 06 January, 2020
Hi Juan,

Good news that Appeon PowerBuilder 2019 MR (build 2170) has been officially released. The issue you reported has been fixed in this release. Please download and install it to verify your reported issue and let us know if any problems. 
You can get the installer from our Downloads portal at https://account.appeon.com/download/2019 (login required). 
Upgrade Notes:
If you are currently using PowerBuilder 2019 (build 2082 or 2151), please directly apply this MR (build 2170) on the top of your current 2019.

We welcome all feedback from you!

Regards,
Ken
Chris Pollach @Appeon 15 November, 2019
Thanks for the update Ken!
Ken Guo @Appeon 14 November, 2019
Hi Chris,

This issue doesn’t exist in PB 2017 R3 so we don’t need to fix it in PB 2017 R3 MR.
It will be released to PB 2019 R2 and PB 2019 GA MR. Actually, we already solved this bug in PB 2019 R2 Beta which had been released a few weeks ago.

Regards,
Ken
Chris Pollach @Appeon 14 November, 2019
Hi Ken;

  Has Engineering confirmed this fix 100% yet for the upcoming PB2017R3 MR and new PB2019R2 release in 2020?

Regards ... Chris
Ken Guo @Appeon 01 August, 2019
Hi Juan,

We have fixed this bug on our internal version. But still, we won't release it until we've done the verifications thoroughly. Moreover, we have to be much more careful when fixing this bug since it is related to several bugs.

FYI, there is no official information on the release date of the next MR or the R2.
As far as I know, there may be a version released before November. But it's not for sure as any element could influence the release plan.

Regards,
Ken
Juan Pedro Sanz Diez 01 August, 2019
Is there a fix yet? When will be the next MR?

You know, my mannager is asking me....
Juan Pedro Sanz Diez 14 June, 2019
Ok, 

Thanks you.

Regards.

Juan Pedro.
Ken Guo @Appeon 14 June, 2019
Hi Juan,

We are analyzing and fixing this issue as a priority. Our aim is to have it fixed in the next MR. At this moment, the exact release date is not decided. We will keep you updated. 

Regards,
Ken
Juan Pedro Sanz Diez 14 June, 2019
Good day, Ken.

We need to know if there was any advance with the issue or if there is an expected date for the fix.

Thanks in advance.

Juan Pedro.
Juan Pedro Sanz Diez 12 June, 2019
Thanks a lot for the quik reply. Waiting expectantly for the fix.

regards

Juan Pedro..
Ken Guo @Appeon 12 June, 2019
Hi Juan,

Thanks for reporting this problem! We reproduced it on our end and will do further research to figure it out. We will keep you posted about the progress.

Regards,
Ken
Juan Pedro Sanz Diez 11 June, 2019
Thanks.
Ken Guo @Appeon 11 June, 2019
Hi Juan ,

I'm working on analyzing your case. I will keep you posted of the results here.

Regards,
Ken
Juan Pedro Sanz Diez 11 June, 2019
issue_sort_computed.rar (3KB)

*Phenomenon:
Hello,

My name is Juan Pedro. We have installed the Appeon Powerbuilder 2019 Build 2082. We have realized that in the new version the computed field in the datawindow's sort are loosing.

*Reproduce Steps:
I mean:

Appeon Powerbuilder 2017

1.- Add a field (F) in a datawindow
2.- Add Computed field (CF) in a datawindow.
3.- Go to rows -> sort and select F and CF for the second. OK and close.
4.- Go to rows -> sort and both F and CF are there.
5.- Save datawindow 
6.- Go to rows -> sort and both F and CF are there.
7.- close datawindow
8.- Open datawindow
9.- Go to rows -> sort and both F and CF are there.


Appeon Powerbuilder 2019

1.- Add a field (F) in a datawindow
2.- Add Computed field (CF) in a datawindow.
3.- Go to rows -> sort and select F and CF for the second. OK and close.
4.- Go to rows -> sort and both F and CF are there.
5.- Save datawindow 
6.- Go to rows -> sort and both F and CF are there.
7.- Close datawindow
8.- Open datawindow
9.- Go to rows -> sort and the CF ISN'T there.
10.- Close datawindow
11.- Edit Source Datawindow -> and the CF is There, in the sort. OK
12.- Open datawindow
13.- Go to rows -> sort and the CF ISN'T there. 
14.- Save datawindow
15.- Edit Source Datawindow -> and the CF ISN'T There, in the sort, any more.



Remarks:
1) If the computed field is alone in the sort, it works.
2) All fields behind a lost computed field , are loosing too, computed and not compute. Only not computed fields before the computed field are keeping.

3) see attached files.

Two problems:

1.- At runtime, it doesn't work, althought in edit source the field is in the sort.
2.- At maintenance, if we save any datawindow, computed fields are loosing, for ever.
OS:
Windows 10 
Platform:
All 
Database Type:
Microsoft SQL Server 
Database Version:
I think no matter with the issue. SQL Server 2008