www.usoft.com To www.usoft.com

- - Knowledge base
Ideas
Events

Welcome to the USoft Community

Find and ask your questions
Stay up to date on the latest USoft topics
Share your best practices and help others

Ask your question

The short way

USoft Knowledge Base

To identify or assess USoft knowledge and skills

USoft version 10 is live!

Explore the new features of our new release.

Sign up for the community

Activate your free account now

USoft community categories

Get inspired

Welcome and getting started

6 topics

News & announcements

9 topics

Community blog

4 topics

USoft Platform Q&A

Got a Question?

37 topics

Share your best practices

8 topics

Release updates

3 topics

USoft headlines

Some of USoft knowledge base topics

Authorisation & Access

Authentication and authorisation together ensure access control.

Business Rules

In the USoft approach, business rules are the primary communication

Web & App UIs

For data-intensive web user interaction with the USoft platform

Recently active

SQL and Web Designer

Modifying underlying SQL of TableDataSources

This article is about modifying or "tweaking” the SQL that underlies TableDataSource objects.This is an optimal strategy in situations where TableDataSources almost fulfil your needs, but you need some small changes or additions to the underlying SQL to get what you really want.Default SQL underlying a TableDataSource Underlying SELECT… WHERE Underlying INSERT… VALUES Underlying UPDATE Underlying DELETE Adding an output column to a TableDataSource Limiting query results Grouping by a column of a TableDataSource Sorting query results Setting record set sizeDefault SQL underlying a TableDataSourceTo understand how you might want to modify a TableDataSource’s SQL, let's first look at the SQL that a TableDataSource executes for you by default - that is, before you start making any modifications.Underlying SELECT… WHEREWhen your user queries data through a TableDataSource that you have not modified in any way, she performs an underlying SELECT statement that retrieves from the RDBMS all

UDB DataSourceContainer

$.udb(ds).setDataSetSize()

This article is about the setDataSetSize() function of the DataSourceContainer object.$.udb(ds).setDataSetSize()Sets the size of a data set of the first data source in the container.Returns a Promise object or the 'this' object. From USoft 10.0.1I, returns a udbPromise instead of a Promise object.To get an existing data set size, call $udbMeta(ds).dataSetSize().Syntax$.udb( ds ).setDataSetSize( value, promise )promise ::= { true | false }The required ds is a data source selector.The required value is an integer specifying the desired target data set size.The optional promise determines the return value of this function. If promise has the value 'true' (the default), a udbPromise object is returned. If promise has the value 'false', the ‘this’ object is returned instead.Example$.udbMeta('EMP').setDataSetSize(20);

Got a Question?

SQL Server lock on T_EVENT

I have a batch job which needs to run as soon as the rules service starts. So there’s a constraint on T_EVENT which invokes that batch job.Sometimes, but not always, that constraint throws an error:<ure:entry host="az048vm3001:7222" time="2022-11-07 07:46:33" source="RulesEngine:1" severity="Error"> <ure:request request-id="0"></ure:request> <uslng:messages app-interface="http" version="1.0"> <uslng:message msg-code="60508" msg-category="Frequent End User Msg" msg-type="Error" system-msg="yes" language="default"> An error occurred when performing the following RDBMS statement: <uslng:param name="Statement">SELECT ''FROM CEP_PCSRD.T_EVENT t1WHERE (t1.EVENT = :1 AND t1.SESSION_ID = :2)</uslng:param> <uslng:param name="Param2">(STARTUP,14482352E4823)</uslng:param> <uslng:param name="Reason">UNIQUE_KEY_REASON</uslng:param> </uslng:message> <uslng

Got a Question?

Missing comma and decimal point characters when using OTS_CSV_UTIL.ToXmlImport

When, with USoft 9.1.1J, the OTS_CSV_UTIL.ToXmlImport function the comma and decimal point characters are removed from the output. Is this by design?

Web Designer classes, objects, properties

Page classes

In Web Designer, a page class is the definition of a browser page in a USoft web application. A page based on a page class can be published to a web service and thus be made available to your end users. They navigate to a page in different ways, for example by selecting a main menu option, or by clicking a hyperlink in a different page.Page classes enable you simply to create-and-publish browsable pages quickly. But they can also be the basis of web parts that you embed in surrounding other pages, and they can also be the (abstract) basis of (concrete) multiple end-user pages that share characteristics defined at the more abstract level.At development time, page classes are visible in the Pages catalog on the left-hand side of the Web Designer tool interface.Pages catalogAs the picture shows, pages are organised in a class inheritance hierarchy. Lower-level pages inherit objects and properties from higher-level parents. The picture also shows a set of default InfoPage classes: they are

Patrick Camphuijsen

renderrow

This article is about the renderrow UDB event handler.renderrowThe renderrow event may be called from web pages developed in Web Designer and processed by a USoft page engine service.Event Applies to Occurs when renderrow Multi-record UI controls After the GUI realisation of the HTML for the row has been completed This event applies to multi-record UI controls only. For single-record UI controls, use the afterrender event instead.How to useFind or create an Event Listener object with Event Type = renderrow. Event Listeners are in the Web Designer Controls catalog:Insert the event listener into the Page object. Insert a callClientScript action into the event listener. Use this action's Script property to code the behaviour that you want to see when the event occurs.

Patrick Camphuijsen

beforeexecutequery

This article is about the beforeexecutequery UDB event handler.beforeexecutequeryThe beforeexecutequery event may be called from web pages developed in Web Designer and processed by a USoft page engine service.Event Applies to Occurs when beforeexecutequery Data source objects Before the data source is queried PurposeYou can use the beforeexecutequery event to supply additional query conditions, to alter query conditions, or to enforce restrictively that the user supplies certain query conditions.How to useFind or create an Event Listener object with Event Type = beforeexecutequery. Event Listeners are in the Web Designer Controls catalog:Insert the event listener into the data source object. Insert a callClientScript action into the event listener. Use this action's Script property to code the behaviour that you want to see when the event occurs. For example, for restrictive action, a typical pattern is to specify the condition under which you want the query to be pre

Patrick Camphuijsen

Rowset.sort()

This article is about the sort() function of the Rowset object.Rowset.sort()Sorts the rows in a rowset.Returns the 'this' object.Syntaxrow-set.sort( target )target ::= { client | server | auto }The optional target is a string that determines where the sorting should take place. Possible values are 'client', 'server' or 'auto' (the default). The 'auto' value sorts on the server except when, for one of the columns, a user-defined sorting function has been specified. In that case the sorting is done on the client.Example$.udb('EMP').rowset('current').sort();

Dennis.van.Vreeswijk

Got a Question?

Datetimestamp in milliseconds

We’re working on a product where timing is quite important. We therefor would like to store a Datetime stamp up to a thousands of a second. I’ve tried multiple solutions manipulating the IO-format of the domain I’m storing the datetimestamp in unfortunately without any luck. The IO formats I tried so far are: YYYY-MM-DD HH24:MI:SS.FF3 YYYY-MM-DD HH24:MI:SS.NNN YYYY-MM-DD HH24:MI:SS.SSSthey each store the datetime stamps without the milliseconds.Even when manually inserting the date via a query in USoft Application, it inserts it without the milliseconds, also shown below Running that exact query directly on the database, and the milliseconds get inserted Is there an easy way to work with milliseconds?

Frans.Willem.Duijnhouwer

Does using the USoft platform cause vendor lock-in?Vendor lock-in

Does using the USoft platform cause vendor lock-in? Customers sometimes ask USoft whether they become completely dependent on us and our software if they go into business with USoft. In short, whether a so-called vendor lock-in occurs when using the USoft low-code platform? Fortunately, this is not the case. This short article explains why not. What is a vendor lock-in? To begin, it is important to provide a good description of vendor lock-in. A vendor lock-in means that customers are and remain dependent on a vendor to a greater or lesser extent. For example, customers cannot easily migrate from one product to another. In addition, changing or adding functionality may no longer be possible or may be limited. This is something you will always need the vendor to address. With any technology, there is always a certain degree of vendor lock-in. Even open-source software is subject to some degree of lock-in. There are often no license fees and sometimes there is not even a vendor, but th

Events Calendar

Badge status

kesselringjhas earned the badge Explorer
dara.samihas earned the badge Scout
marchas earned the badge Scout
Marc van Willigenhas earned the badge Explorer
USoft Supporthas earned the badge Scout

Show all badges

Build better products

Feedback or suggestions for our product? Submit and vote on product ideas.

Watch the welcome video

Make room for innovation with low-code and the power of business rules

Need more help?

Start your conversation here

Off-the-Shelfs components

Powered by inSided

Terms & Conditions Cookie settings

CONTACT

USoft B.V.
IJsselmeerweg 1
1411 AA Naarden
The Netherlands

+31 (0)35 699 0699
info@usoft.com
www.usoft.com

© Copyright 2022 Privacy Policy

EXPLORE MORE

About USoft
Working at USoft
Success stories

Sign up for the USoft Community

Already have an account? Login

Username *

E-mail address *

First name *

Last name *

Company

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login into the USoft Community

No account yet? Create an account

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK