Tag: Java

What is a Pre Query? Pre Query Script lets you to specify any custom search clause that would get appended to the default search criteria generated by the platform. You can manipulate the whereClause that gets used during search. Pre Query script can be defined for Datasource When do we use it? When your application requires to implement custom search, you can write Pre Query Script on the Datasource. The platform invokes the Pre query script to perform search and return the ... [Read More]

What is Post Query? Post Query Script lets you to alter the data being fetched from the database, before it's presented to the User on the browser. You can choose between Java and/or PL/SQL to do the data manipulation. Java Example Let's say you have an attribute "Status" that contains values I for Inactive & A for Active. But on the UI instead of display I or A, we want to display "Inactive" or "Active". Though you can achive this by definin... [Read More]

What is Server Side Validation Scripts? Server Side Validation Scripting allows Telidos Application Developers to write custom validation code on any Data Source using Java. Unlike traditional Java development, you don't have to do a compile & run. Any changes to these scripts will be picked up by the platform at runtime without the need for an application server bounce. Standard Java Syntax You can use normal Java statements and expressions. Statements and expressions a... [Read More]

Sample ObjectHandler to report all the exceptions at once during an excel import To use this, set the "Object Handler Class" at the datasource definition to "xxra.customobjects.ExcelImportBulkErrorHandler" package xxra.customobjects; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Timestamp; import java.util.Date; import java.util.List; import org.apache.commons.dbutils.DbUtils... [Read More]