Tech Articles


Getting PowerFilter to work with Powerserver Web


In order to use PowerFilter in Powerserver Web you need to change 3 things to work around appeon problems.        

1) Structure comment 

Powerserver Web does not support comments in structures and will skip processing the entire structure.  So your structure won’t be in your deployed application and powerfilter won’t work at all.  So, you have to delete all the comments in the 2 structures in powerfilter.  
 

Structure Comment


2) datawindow text object expressions 
 

Both the visible and the text value expressions don't operate the way they do in powerbuilder.   The visible expression seems to be ignored entirely if the visible checkbox is checked.  You can get this to work by removing the checkmark on the visible property.  The visible expression will work then.  You may notice that the TEXT value has an expression too.  That seems to be ignored completely in appeonNo changes are needed for text value.


 

Text Visible expression

The easy way to select this object is to click on the t_blank text object in the control name list.   The t_blank text object is underneath all the columns
 

3) TRIM(string, boolean)

Powerserver Web trim support is limited to just the string argument.  The 2nd argument (boolean) will remove all white space when set to true.  This is the case for the left/right trim functions too.   Powerfilter uses trim.  Powerfilter has additional code to replace the CR/LF with spaces which is needed to remove CR/LF inside the string.  So it already removes CR/LF from the start and end of the string. Change the trim to the one without the TRUE, and handle removing other white space such as tabs with replace.
 

Trim function only partially supported in appeon

 

 

 

Comments (0)
There are no comments posted here yet

Find Articles by Tag

PostgreSQL Excel MessageBox Graph Database Table Debugger OLE Window Class ActiveX .NET Assembly Linux OS Automated Testing License CrypterObject DataWindow Event Handler NativePDF Data SqlExecutor Debug RESTClient UI Modernization UI Themes Database Painter SVN REST Outlook Database Profile TortoiseGit Transaction SnapDevelop Database Table Data PowerServer Web Git Icon PowerBuilder (Appeon) Validation Jenkins Android Variable .NET Std Framework HTTPClient C# PDF Array Filter Charts Stored Procedure Authorization SQL Service Event Handling JSONParser OAuth 2.0 Web Service Proxy JSONGenerator WebBrowser Export JSON TFS Design PowerScript (PS) Event Oracle RibbonBar Builder WinAPI TreeView Source Code Export Error PDFlib Windows OS Installation External Functions OrcaScript BLOB JSON 64-bit Syntax Branch & Merge PFC File PowerBuilder Compiler Interface Resize RichTextEdit Control Mobile Repository Sort Database Connection Database Table Schema SQL Server Source Control Performance Elevate Conference API Import JSON Testing DataType Authentication DLL 32-bit Script PostgreSQL ODBC driver Configuration Visual Studio Deployment COM Encoding Debugging PBNI DevOps PowerBuilder Expression SOAP SqlModelMapper Windows 10 Icons PowerServer Mobile Database Object DataWindow JSON CoderObject Platform .NET DataStore Text Database PBDOM XML Bug InfoMaker RibbonBar CI/CD Trial Model DragDrop ODBC Open Source Web API Messagging Migration Import Menu GhostScript iOS Encryption TLS/SSL IDE SDK PBVM UI Application OAuth Azure SnapObjects