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.1 is here!

Explore the new features of our latest release.

Sign up for the community

Activate your free account now

USoft community categories

Get inspired

Welcome and getting started

6 topics

News & announcements

10 topics

Community blog

4 topics

USoft Platform Q&A

Got a Question?

48 topics

Share your best practices

10 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

Got a Question?

xsl:strip-space in XSL Stylesheet component

Using xsl:strip-space in an XSL Stylesheet component (USoft 10.1.1B) results in this error:White space cannot be stripped from input documents that have already been loaded. Provide the input document as an XmlReader instead. Anyone know an easy way to work around this? Thanks!

Blend functions

strings:REReplace

This article is about the strings:REReplace Blend function.strings:REReplaceWithin a specified string, replaces each occurrence of a substring matching a specified regular expression pattern by a specified alternative.Syntaxstrings:REReplace( string, regexp-pattern, alternative )Each of the 3 arguments (string, regexp-pattern, alternative) are required.If there are multiples substrings matching regexp-pattern, the replacement takes place each time.if no substrings match regexp-pattern, then string is returned unaffected.ExampleThis example filters special characters and takes advantage of regexp's escape mechanism:<root xmlns:pc="Processing.Command" xmlns:assign="Processing.Command.Assign" xmlns:strings="USoft:Strings"> <example> <pc:value-of select="strings:REReplace('My\Value\','\\|,|/|\^|~|@|&amp;|\||-|\(|\)|\[|\]|\{|\}|\*|\?|=|\+|\.|,|%','')"/> </example></root>The result value is the input My\Value\ but without the backslash characters:MyValueIf

Blend functions

strings:Replace

This article is about the strings:Replace Blend function.strings:ReplaceWithin a specified string, replaces each occurrence of a specified substring by a specified alternative.Syntaxstrings:Replace( string, substring, alternative )Each of the 3 arguments (string, substring, alternative) are required. Each argument is a character string of any size.If substring appears in string multiple times, the replacement takes place each time.If substring does not appear in string, then string is returned unaffected.Example<root xmlns:pc="Processing.Command" xmlns:assign="Processing.Command.Assign" xmlns:strings="USoft:Strings"> <example> <pc:value-of select="strings:Replace('IS_FOLLOWED_BY', '_', '')"/> </example></root>The result value is:IS FOLLOWED BYTo make a replacement in each substring that matches a specified regular expression pattern, use strings:REReplace() instead.

Got a Question?

Delete from SQL Server without UPDLOCK

Hiya,We use a scheduled clean-up task to delete data from a SQL Server 2019 table when it has become obsolete. During high loads, we regularly run into time-outs in a second process which is attempting to insert data into the same table.In the SQL Profiler screenshot below, you can see clean-up process 73 performing a ‘SELECT FOR DELETE’ statement. That uses the UPDLOCK hint, which result in a lock escalation on (a page beneath) the IN_ICM_EVENT table .Process 69 (which is actually a second rules service) attempts to do an insert into that same table, but times out after 10 seconds due to the lock held by the clean-up.We know the data being deleted is not going to be updated (or even selected) by any other process, so we don’t need the lock held by the clean-up process.Does anyone know if there is any way to force the rules engine to forego that lock?

Got a Question?

xml error transformation

Using RulesEngine.GetLastCaughtErrorsAsXML() gets you the errors in xml format. It looks like you can get those messages with various content (of course) and elements. Would there be any xsd available on these messages so we can write robust transformations on those (e.g. to return to an api call)?

USMeta internal component

USMeta.Tables

This article is about the Tables method of the USMeta internal component.USMeta.TablesAt runtime, gets metadata information about tables from the model developed in USoft Definer. For each retrieved table, this information takes the form of name/value pairs. Each name/value pair expresses a table attribute setting.SyntaxSELECT USMeta.Tables( table-name-pattern Tables, include-database-tables IncludeDatabaseTables, include-logical-views IncludeViews, include-component-tables IncludeComponentTables, interfaces-only InterfacesOnly, module-pattern Module, mime-type MimeType)include-database-tables ::= { yes-value | no-value }include-logical-views ::= { yes-value | no-value }include-component-tables ::= { yes-value | no-value }interfaces-only ::= { yes-value | no-value }yes-value ::= { 'yes', 'Y', 'true', '1' }no-value ::= (A value other than a

CurrentUser internal component

CurrentUser.SetProperty

This article is about the SetProperty method of the CurrentUser internal component.CurrentUser.SetPropertyIn the runtime application, sets or resets, for the current user, an extension property defined for the User context. Such a property is defined in USoft Definer. Its value is set in USoft Authorizer.This method updates the value in the Authorizer table immediately, using a separate transaction. If this is successful, the value as held internally is also updated.Returns 'Y' if the operation was successful, otherwise 'N'.SyntaxSELECT CurrentUser.SetProperty( property-name, property-value )The required property-name is a string that is the name of the extension property. The required property-value is a string that is the new value.ExampleSELECT CurrentUser.SetProperty( 'email', 'new_address@user.com' )

Got a Question?

SQL Server "Connection is busy with results for another command"

We occasionally have locking issues with our SQL Server 2019 database from a USoft 10.0.1 rules service.When the load on the system is high, this error occurs sometimes:HResult of 0x80004005 (-2147467259) returnedError Source: Microsoft OLE DB Driver 19 for SQL ServerError Description: Connection is busy with results for another commandMost suggestions seem to centre on using multiple database connection or using MARS.Does anyone know if either of these are supported by U10.0 (or U10.1)?

News & announcements

USoft 10.1, what is new at a glanceNews

After months of hard work, we are proud to present USoft 10.1 to you. The new range of possibilities of the 10.1 series makes it easier than ever to develop with USoft. At the same time, stability and consistency are ensured.The primary technical improvements and features in USoft 10.1 Further improved deployment versatilityThe possibilities to deploy a software solution are nearly limitless. And with the addition of Linux support in USoft 10.1, you can now reap the benefits of the deployment configuration that best suits your needs. From traditional environments with different operating systems to containerized environments, your USoft solution can now run on it Customized application UIOne of the advantages of the USoft platform is that an application is generated for you, while you’re creating your data model. In USoft 10.1 we have enhanced and improved the options to create beautiful web applications with ease. Web pages can now be based on your own templates, including your custom

Upgrading to USoft 10

Upgrading USoft 10.0 to USoft 10.1

Development EnvironmentTo upgrade your repository tables from USoft 10.0 to USoft 10.1, use the Upgrade tool provided in USoft Binder:In USoft Binder, choose Item, New from the menu and choose Upgrade. Double-click the new Upgrade Tool item. Choose File, Start Upgrade from the menu, or click this icon:Production EnvironmentFor 10.0 to 10.1 , you do not need to perform upgrade procedures that were described in the 9.0 to 9.1 upgrade procedure.

Events Calendar

Badge status

rene.de.bruinhas earned the badge Explorer
rene.de.bruinhas earned the badge Scout
Janhas earned the badge Explorer
kesselringjhas earned the badge Explorer
dara.samihas 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 Gainsight

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 2023 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