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 appeon. No 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

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