Siebel Problem with isNAN eScript

Recently I was working with a requirement where the field needs to be validated to accept only numeric values. This requirement looked to be a simple one. Adding a validation on the PreSetFieldValue of the Business Component solved the problem.

Below is the code added

...............................
...........
if(isNaN(FieldValue){
           TheApplication().RaiseErrorText("Sorry, invalid number, please enter numbers alone.");
}

 .......


Thats it....


Now when testing all looked fine until accidentally I entered 123123e. There was no error thrown and the value was accepted. How ever this is not what the code is suppose to be doing. So thought of getting in deeper, tested with 88779e no error thrown, then with 2341209d error thrown.

So "e" at the end was the killer. Some how a number ending with e is considered as a infinite number (not sure if I am correct).

As an alternative and get rid of this scenario changed the code as below and it worked like a charm.

...............................................
.................
.....
var CheckString = FieldValue;
var Pattern = /[^0=9]/g; //non numeric pattern search
var result = CheckString.match(Pattern); //Get all the values which are not numeric

 //if result is not null and length of result is non zero then the string is non numeric
if( result && result.length){
              TheApplication().RaiseErrorText("Sorry, invalid number, please enter numbers alone.");
}

 ...................................
isNaN problem solved !!!!

Comments

Post a Comment

Popular posts from this blog

Siebel - DeleteRecord Method in eScript

Let me take this opportunity to share a unique issue that I faced during one small requirement development. Requirement: Contacts with a specific roles are created due a configuration miss in the EAI. As the product is live the fix can be put only after the root cause is found and change window is available. Till then these records needs to be deleted. As the number of records is huge deleting these records manually is a time consuming task and no back end deletion is allowed as the product is live. As a work around a client side BS would be developed to over come the problem. Siebel  Version : 7.7 Below is the pseudo code BusCom = "TechLabHelp" With BusCom                clear Query()                Search for Contact with Role "TECHLABS"                FirstRec = FirstRecord                While (FirstRec)                        FirstRec = DeleteRecord                End While End With Hope pseudo code is simple and self explanatory. Now
Read more

How to call a Business Service from a PM/PR file in Siebel Open UI

I was working on a requirement where I had to call a Siebel Business Service from PM/PR files. Oracle Support gave a pretty simple steps to the same. But for each of the Business service to be called had to register it as a user property in the Siebel Application user property. This would need a SRF change every time and was not that easily feasible. So came up with the below practice which avoided the SRF change. Below are the steps to create call a Business Service from the Siebel PM/PR file. 1. Add the below Application User Property ClientBusinessServiceN = Business Service Name Here " N " would be the value in sequence of the application user property ClientBusinessService and Business Service Name is the name of the Business Service to be called. 2. In the PM/PR file add the below code to call the Business Service // Get the Object for the Business Service. Get the Business Service by passing the Business Service Name var sBusService = SiebelApp.S_App.GetSe
Read more

Siebel Business Service Part-4

Image
In this post I will discuss on how to create a business service. How to create a BS in Siebel Tools • Lock the project on which BS should be based on • Select the Business Services object in the Tools Object Explorer. • Right-click , and then choose New Record .( Ctrl+N ) • Type a name of the BS in the Name field of the new business service and Select the Project. • Choose the appropriate class Data transformation – CSSEAIDTEScriptService class. Other business services - CSSService class . Defining a Method for BS • With the business service selected in Siebel Tools, expand the Business Service tree in the Object Explorer, and then select Business Service Method. • Right-click , and then choose New Record. • Type the name of the method in the Name field of the new method. Defining Method Arguments… • With your business service method selected in Siebel Tools, expand the Business Service Method tree in the Object Explorer, and then select
Read more