Search: db

String userName = db.getSessionValue("username"); List<RPCModelData> userRolesList = db.assignRoles(userName, new String[]{"ordermanagement"});. RPCModelData, cacheGetObjectsByNameValues(String ds, String attr,Object... nameValues) This method can be used whenever you want to return RPC model data from database and cache it. Instead of querying databse every time, It will query once and store values in the cache. The subsequent calls will fetch from the cache instead of querying ...

Email: This is the reference email, and once the installation is complete, access details are mailed to this Email. New Password: This is the login id that you will be using to login to the platform. Confirm Password: This is to reconfirm your password. Then Click on Continue. Step 2: Setup Platform Schema. Database Type: Oracle is mandatory for platform schema. DB Host Name: Enter your DB host name. Example: server.telidos.com. DB Port: Enter your DB Port. Example: 1521. SID: Enter your SID details.

if ("Y".equals(config.getParam("ExcelExport"))) { String status = data.get("Status"); if ("I".equals(status)) { data.set("Status", "Inactive"); } else if ("A".equals(status)) { data.set("status", "Active"); } }. You can also pass values from Pre-Query script to Post-Query thru' user's server session. db.setSessionData("Session Variable Name", data.get("Attribute To Be Carried Over From Pre-Query to Post-Query")); data.set("Attribute To Be Carried Over From Pre-Query to Post-Query", db. getSessionData("Session ...

db: An instance of ScriptUtil.java; dateUtils: An instanceof DateUtils.java; user: Logged in Username; userid: Logged in User ID; subDomain: You application sub-domain; dbdata: An instanceof RPCModelData with the values populated from the database. Will be null for Insert operations; data: An instanceof RPCModelData with the values populated from the user's input; operation: I for Insert, U for update, D for delete & V for validation. errorMsg: Initialized with empty String. Set a value if you want the ...

Creating a Custom link in Email Actions. Steps to create a custom link in the email actions. 1) Create a Caluculated Column in the data source for which you want to create an Email Action eg:- testlink. Server Side Validation Script:-. 2) Import com.rapapp.platform.client.mdata.RPCModelData;. 3) Generate a Link by using the method db.getLink("Link Name","Page Code","Other Parameters") in server side validation scripts. 4) Assign the returned Link from db.getLink() to the String ie, String link ...

SEQUENCE: RA_LOG_S;; TABLE: RA_FILES; RA_LOG; RA_OBJECT_ATTRIBUTES ; RA_ROLES; RA_USER_ROLES; RA_AUDIT_HISTORY; RA_USERS;; VIEW: RA_AUDIT_HISTORY_V; PACKAGE: RA_GLOBAL; RA_GLOBAL_PUB;. Note: If you have any uploaded attachments in your application that needs to be moved as well, you must move the table RA_FILES along with the data. After successfully migrating the schema, navigate to Administration -> Setup and update the DB URL, DB Username ...

return val; } String fileName = "/tmp/_hs"+ db.getUserId().longValue()+".csv"; FileWriter writer = new FileWriter(fileName); String paramId = request. getParameter("paramId"); static final SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ"); try{ Map<String,Object> map = new HashMap<String,Object>(); map.put("paramId",Double.parseDouble( paramId)); List<RAObjectAttribute> objectAttributes = db.getRAObject(" DatasourceName").getAttrList(); int size = objectAttributes.size();

(Redirected from Publish Notification Using Server Side Validations). Publish Notifications Using Server Side Validation Scripts. First you need to import com. rapapp.platform.client.mdata.RPCModelData;. Now Use the Method db. publishUserNotification("Subject","body","RoleId","UserId") to Pulish a Notification . Subject:- Subject of the Notification. This will be displayed as the Header in notification. Body:- Content of the Notifications. Role-Id:- It is Optional to Specify the Role ID. If you want to send the ...

RPCModelData data = (RPCModelData)row; //use the HandlerContext object to get access to ScriptUtil ScriptUtil db = context.getScriptUtil(); //Its a custom method that creates a XML file InputStream xmlStream = writeXMLFile(data); // generate a sequence id using the ScriptUtil utility methods double xmlId = db. getNextVal("T_APP_NOTE_XML_S"); //Use the connection object to write data into a table insertXML(con,context,data,xmlStream,xmlId); //use the sendEmail method to sent an email String noteTitle ...

boolean showAll = "Y".equals(db.getProfile("SHOW_ALL_ACTIVITIES")); // from a given customer... show all activities for that customer if (whereClause.indexOf(" CUST_ACCOUNT_ID") == -1) { String group = data.get("groupcode"); String dueBy = data.get("dueby"); if ("MY".equals(group)) { if (whereClause.length() > 0) { whereClause.append(" AND "); } whereClause.append("x.OWNER_ID = ?"); params.add(userid); } else if ("ME".equals(group)) { if (whereClause.length() > 0) { whereClause.append(" AND ...