" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
- Mahatma Gandhi

Zendesk site integration with Servoy using HTTP plugin ( Rest API )

Posted on November 23rd, 2015 by Ashutos Lenka

Zendesk is the site where the customers can raise support requests for the application . In Servoy we can integrate the zendesk inside the application . The users can directly create support request tickets from the application itself . Some Rest API are available for zendesk . We can use the servoy’s http plugin to […]

Clear SVN Credential Cache In Eclipse

Posted on November 23rd, 2015 by Sovan Misra

Sometime we need to change the SVN credentials for the repository which we have already saved to avoid the annoying prompts coming again and again. For doing the same we do not have any option to do it in UI in Eclipse. We have to manually delete the cache. Windows: 1) Close all the open […]

Customize Exception Handler for Servoy applications

Posted on November 23rd, 2015 by Arup Ranjan Sahoo

Servoy’s inbuilt mechanism to handle exceptions is quite effective but there are times when you may want to handle the exception programmatically. For instance, in some situations you may want to customize the Exception Handler to show some custom messages to the user? Whenever Servoy encounters an error, it throws an exception with the pre-defined […]

Create A Stand Alone Version Of Your Servoy Solution

Posted on November 23rd, 2015 by Arup Ranjan Sahoo

Creating a Stand alone version of your Servoy Solution is Easy & Fast. Create A Stand –Alone version of your Servoy Solution You can create a stand alone version of your Servoy Solution, which can be run on any platform (Windows, Mac or Linux) without requiring you to install Servoy or a relevant Database. In […]

Renaming a Servoy Solution

Posted on November 23rd, 2015 by Arup Sahoo

In the eraly days, renaming Servoy solution was as easy as is renaming any other file but with the release of the Eclipse version of Servoy, a lot of things changed including the process of renaming solutions. In this tip I am going to show you the work around, using which you can rename your […]

How to take the screenshot of your Screen in Servoy

Posted on November 23rd, 2015 by Arup Sahoo

Have you ever, thought up for taking the screenshot of your desktop in Servoy? Just like the Print screen button of Windows keyboard. Here is a quick Tip to show how you can do that in Servoy application. Here is a Servoy method I have written which takes screenshot of your desktop and returns the […]

Servoy Branding Settings

Posted on November 23rd, 2015 by Arup Sahoo

Servoy has given us the flexibility to customize the way our applications are deployed and run. Servoy uses Java Web Start Technology for the Rich Client deployment. You can change almost all Servoy related information at the time of deployment and add your own vendor information to give your application a more professional look. You […]

Adding Inline Images to the body of your mail in Servoy

Posted on November 23rd, 2015 by Arup Sahoo

The below Tip describes, How you can send email in Servoy by adding images inline to your message body. We can create the email attachments by using the createBinaryAttachment() method of the mail plug-in and pass the array of attachments to the sendMail() method to send the mail along with attachments. The code snippet below […]

Uploading files in Servoy smart client and Servoy web client.

Posted on November 23rd, 2015 by Prem Mali

Servoy requires a single code base which is common for both the desktop and web. But Servoy also has it’s limitations and oneof them is file uploading in servoy smart client and web client. The following tip demonstrates how a developer can handle file uploading in smart client and web client. File uploading in Smart […]

Avoiding data-loss during sorting records in Servoy

Posted on November 23rd, 2015 by Arup Sahoo

In my current project, it was very surprising to find that some of the records had vanished from the foundset after sorting and listing them. I was shocked, what could I have done that causes loss of data. Then I tried to find the issue. Issue: If you are showing a list of records of […]

Work-around for Busy Indication in Form In Dialogs

Posted on November 23rd, 2015 by Arup Sahoo

Intro You can show Busy Indication in your Servoy solution, by using a FREE Plug-in (http://www.servoy.com/forum/viewtopic.php?f=12&t=7246). Another, good news is Patrick Talbot of Servoy stuff has made this Plug-in, Web Compatible (http://servoy-stuff.net/busy.php). However,one disadvantage of this Plug-in is that the busy indication is only applied to the parent form. That is, if you are showing […]

Printing blob columns in background from Servoy interface

Posted on November 23rd, 2015 by Pradipta Behera

We can print images stored in blob(Media) columns in different ways. One of the interesting way to accomplish this task is by using executeProgramInBackground method. Using this method we can execute actions at the command line. This works on both Mac and WindowsXp Operating Systems. First we need to create a temporary file from the […]

Executing External Applications from Servoy

Posted on November 23rd, 2015 by Arup Sahoo

The below Tip describes you, How we can run/trigger external application directly from your Servoy Solution. For triggering an External Application, You can use application.executeProgram() method. Here, I am quoting the syntax of the method. //Execute a program and returns output specify the cmd as you would do in a console var program_output = application.executeProgram( […]

Think before you loop records

Posted on November 23rd, 2015 by Arup Sahoo

One of the greatest feature of Servoy is that, you can directly interact with the database by using Servoy’s built-in data binding for creating/modifying/editing/searching records using a particular form. This Tip will address one of the important things while looping through the records of your form. We can modify/update the record data of a form […]

Use of elementName while writing Plug-ins for Servoy

Posted on November 23rd, 2015 by Arup Sahoo

The below TIP explain you the use of “elementName” while writing custom Plug-ins for Servoy. When you write any Plug-ins for Servoy, you must have a provider class, which must implement the IScriptObject Interface and the class needs to be referenced to the Servoy Application Server through the getScriptObject() method of the Plug-in’s main class. […]

How to display database stored images in Servoy html field

Posted on November 23rd, 2015 by Prem Mali

Servoy supports html rendering in html area field. We can display database stored images into the HTML and call Javascript function. Following code will demonstrate how we can display database images in html and attach Javascript function into html. var html = ‘<html>’; html += ‘<table border = “0” width = “82” height = “82”><tr>’; […]

Checking Plug-in Existence in Servoy

Posted on November 23rd, 2015 by Arup Sahoo

Servoy Plug-ins are used to extend Servoy’s capability to some extent. We can add Servoy Plug-ins to add more feature to our application which can not be doable with the default installation. Servoy default installation is also coming with number of Plug-ins. We can use them in our application or we can also use Free […]

Reducing Object references with WITH

Posted on November 23rd, 2015 by Arup Sahoo

As the Servoy’s code editor supports Javascript and in-line Java, you can use almost all the Javascript keywords with in Servoy. Among the powerful Javascript keywords, “WITH” keyword is used to reduce Object references in your code dramatically. You can also make your code more readable by using WITH. This TIP will explain you the […]

List View or Table View – A Comparison

Posted on November 23rd, 2015 by Arup Sahoo

While displaying your records in a grid/table view in your application, you may have wondered about choosing the view, whether you should choose List view or Table View?. This TIP will let you help in taking the decision in choosing the List View Or Table View. If you just want to show your records in […]

Updating Records in ONE shot: using Foundset Updater

Posted on November 23rd, 2015 by Arup Sahoo

Have you ever came across in a situation, where you need to update a column for all records in the foundset? Like for an example, you need to modify the current date time stamp of ‘modified_on’ column for all the records in the foundset. To achieve the same, you will update the column for all […]

Flavors of controller.loadRecords()

Posted on November 23rd, 2015 by Arup Sahoo

controller.loadRecords() method is used to load records to a form’s foundset. This TIP will make you familiar with different flavors/ways of loading records by using controller.loadRecords() method. controller.loadRecords() can be used in Three different flavors/ways. The syntax of the method is : controller.loadRecords([foundset/pkdataset/query], [queryArgumentsArray]) You can load records to the foundset by passing a foundset(must […]

Using Scheduler plugin in Servoy

Posted on November 23rd, 2015 by Pradipta Behera

– When a job needs to be executed periodically we need the help of Scheduler plugin. – Using this plugin we can set a schedule for execution of a job in our Servoy application. – We can set the start and end time of the job, the duration or gap of the execution of the […]

Passing A Foundset to the Jasper Report

Posted on November 23rd, 2015 by Arup Sahoo

With the recent release of Jasper Report Plug-in, you don’t need to write huge SQL Query for your report. The below TIP will give a quick start introducing the revolutionary change added to the JasperReport Plug-in. With the recent release of JasperReport Plug-in, Now, you can directly add any fields, calculations(stored/un-stored), aggregations, global variables, related […]

Adding a Sub-Report to the JasperReport by JasperReport Plug-in

Posted on November 23rd, 2015 by Arup Sahoo

With the recent release of JasperReport Plug-in, Now, you can directly add any fields, calculations(stored/un-stored), aggregations, global variables, related fields and many more, to your Jasper Report, as you are doing in  Servoy itself. You don’t have write huge SQL Query for the same. Just pass your foundset to the report and access the fields, […]

RowBGColorCalculation; Updated in Servoy 4.x

Posted on November 23rd, 2015 by Arup Sahoo

With the Servoy 4.x release, some additional parameters has been added to the RowBGColorCalculation to give the developer more control on managing the colors for the records in Table and List View. With this release additional parameters are available with the calculation/global method, that you have set in the ‘rowBGColorCalculation’ property of the form. Here, […]

Showing database images in Jasper Report from Servoy

Posted on November 23rd, 2015 by Pradipta Behera

We can show image in Jasper Report in different ways. 1. Showing static image placed in hard drive : – Create a jasper report file in iReport. – Place an image field in this report. – Set the “Image Expression” property of this field to the url of the image. For example : “C:\\report\\logo.jpg” 2. […]

How to implement log for your data in Servoy

Posted on November 23rd, 2015 by Pradipta Behera

Method 1: Manually maintain log: – To do this we have to create a log table which will store all the data changes. We can have fields like table_name, pk_value_of_the_record, field_name, old_value, new_value, modified_by_user_idx,modification_date, etc.. For this Servoy has some table level events like onRecordInsert onRecordUpdate onRecordDelete To keep track of the updates, create a […]

Getting Server IP Address in Servoy Web Client

Posted on November 23rd, 2015 by Pradipta Behera

In Servoy webclient application.getServerURL() always returns http://localhost:8080 (if port is 8080) For deep linking, we need the server address to point to the solution in the particular server. So we need to write the following code to get the actual server IP in webclient. function serverIP(event) { try { var addr = java.net.InetAddress.getLocalHost(); // Get […]

Creating image thumbnails using Servoy Solution Model

Posted on November 23rd, 2015 by Pradipta Behera

Image Thumbnails can be created at the design time using list view. But the problem is we can show only one thumbnail per row/line. This is fine as long as the number of thumbnails to be created is known but when the number of thumbnails to be created is not known and there is a […]

How To Keep MySQL Connection Alive In Servoy

Posted on November 23rd, 2015 by Arup Sahoo

While using MySQL as databases in Servoy,at times users experience issues of disconncted database services. The tip below describes the potential problem and the quick and easy fix for the same. For using MySQL as database in Servoy, we need to first create a server connection for the same and we generally use the “com.mysql.jdbc.Driver” […]

Integrating Custom YouTube Player in Servoy

Posted on November 23rd, 2015 by Arup Sahoo

Playing Video files in Servoy is still a bit of R&D work for developers. There are no direct Servoy beans and plug-ins available to play video files in Servoy application. And while creating beans and plug-ins for Servoy to play video files, we also need to think about the different video codecs supportability which is […]

Showing image in Jasper report using Servoy foundset

Posted on November 23rd, 2015 by Pradipta Behera

Placing an image field directly in Jasper report will not render the image in the report. However,the image can be shown in the report using these steps : Step 1 : Create a field of type “Object” in iReport for the image. <field name=”image_field”/> Step 2 : Import JRImageLoader which will be used to show […]

Filtering Sub Dataset in Jasper Report

Posted on November 23rd, 2015 by Pradipta Behera

In Jasper Reporting, normally we filter the Sub Dataset by using Servoy relations of type net.sf.jasperreports.engine.JRDataSource but in certain condition we need to filter the dataset manually by adding more filter criteria. This is mainly required in complex reports where multiple group criteria are implemented, where you are not interested to show all the related records […]

Adding Multiple find requests in Servoy

Posted on November 23rd, 2015 by Pradipta Behera

When a user puts a find request, Servoy internally creates a resulting SQL query to fetch data from database. Let us check an example to know how this find request works. (Considering the currentController is based on the same table) Let us check an example to know how this find request works. (Considering the currentController […]

Export Servoy Data To Excel

Posted on November 23rd, 2015 by Pradipta Behera

There are different ways to export data from a table in Servoy. Lets start from the easiest one.   1. Using Servoy’s default Export menu : – Servoy has its own menu to perform data Exports and Imports. It supports the xls and text (.csv, .tab, etc) file formats for Exporting and Importing. To use this feature we […]

How to have a user friendly URL in Servoy

Posted on November 23rd, 2015 by Tyson John

To access some application in the Servoy application server we use a URL and below are the examples of a smart-client and web-client. 1. Smart-Client :- http://<ServerIP>:8080/servoy-client/servoy-client.jnlp?solution=<SolutionName> 2. Web-Client :- http://<ServerIP>:8080/servoy-webclient/solutions/solution/<SolutionName> *<> :-  the content needs to be changed as per requirement. The above two URL are quite long and not user Frieldly. So we make […]

Tree View Bean Implementations for multiple tables and relations in Servoy

Posted on November 23rd, 2015 by Ashutos Lenka

In Servoy “DB Tree View ” and “DB Tree Table View” beans are used to implement tree like structures . Generally the entire tree is based on one single table . The root nodes and the child nodes are based on one single table using the “Parent_to_Child” relation . And the parent to child relation […]

Getting Contents Of A Folder In Servoy

Posted on November 23rd, 2015 by Pradipta Behera

This is the example code to go through the contents of a folder/directory. function traverseFolder(path) { var folderFiles = plugins.file.getFolderContents(path); for (var i = 0 ; i < folderFiles.length ; i++) { var jsFile = folderFiles[i]; if (jsFile.isFile()) {// Processing File application.output('File :' + jsFile.getName()) } else if (jsFile.isDirectory()) {// Processing Directory application.output('Folder :' + […]

Find operation in Servoy

Posted on November 23rd, 2015 by Ashutos Lenka

Find mode should always be checked before entering into the find mode. Find and search operation can basically be done in the following manner. It can be done with foundset and controller both. foudset.find(); foudset.emp_name = ‘MIKE; founset.dept_name = ‘Accounting’; foundset.search(); Reason: But there may be cases when the foundset.find() may fail when there are […]

How to Make Skype Calls & Skype Chats in Servoy

Posted on November 23rd, 2015 by Arup Ranjan Sahoo

What is Skype? Skype is one of the most popular free messenger tool used to do text & voice chat over internet. You can also make a call to any Landline or Mobile Phones through Skype. For more information, please browse www.skype.com. In this Tip, we will see how to integrate Skype with your Servoy […]

Managing Clients from Servoy Solution

Posted on November 23rd, 2015 by Arup Sahoo

Have you ever wanted to get the number of Clients connected a specific Servoy Application Server? Have you ever wanted to alert a specific client from your Servoy Solution itself? Have you ever wanted to check whether a Client is alive or not or want to forcefully terminate the Client session? Further Details Previous Situation […]

Optimization of New record in Servoy

Posted on November 23rd, 2015 by Ashutos Lenka

Suppose we are in a scenario in which we are creating new records in the loop . It affects the perfomance of the application . We need to optimize it. We can consider these points while creating new records : 1.Foundset.newRecord(): We should be using foundset.newRecord() in place of controller.newRecord() . Controller.newRecord() does screen redraws […]

How to stop opening new tab using jquery (Servoy)

Posted on November 23rd, 2015 by Radhakanta Ghosh

This is a small technique to stop opening new tab from a hyperlink using jquery. It will stop to open right click – > open link in new tab and ctrl + click over the link. Simple Example (Prevent to open new new tab by right click and ctrl + click) js code $(document).ready(function(){ $(“.my”).bind(“contextmenu”, […]

Zendesk site integration with Servoy using HTTP plugin ( Rest API ).

Posted on November 23rd, 2015 by Ashutos Lenka

Zendesk is the site where the customers can raise support requests for the application . In Servoy we can integrate the zendesk inside the application . The users can directly create support request tickets from the application itself . Some Rest API are available for zendesk . We can use the servoy’s http plugin to […]