USoft low-code community platform

Recently active

Does anyone know if there is a way for a service framework server to serve the generated OpenAPI yaml file? So people can access the server's documentation from a browser?I've tried several variations of the server’s URI, but without success….

221

2 months ago

marc

Got a Question?

Release notes U11.0.1B

Hiya, I see 11.0.1B is out 😀, but I can't find the release notes anywhere (either here or in the zip file) - could you add/publish those somewhere?Thanks!

This article is about the EXCEPT set operator as part of the SQL syntax that USoft supports.EXCEPTThe EXCEPT operator removes, from the outcome of the SELECT statement appearing before it, any rows that are also in the outcome of a second SELECT statement appearing after it. The two queries must yield results that exhibit the same structure. ORDER BY is allowed only as a modifier of the entire construct, ie., at the very end, not at the end of each SELECT statement.With EXCEPT, the result is different depending on whether the first or the second SELECT statement appears first.In USoft SQL syntax, EXCEPT is a synonym of MINUS.SyntaxSELECT-statement-1EXCEPTSELECT-statement-2In the USoft platform, EXCEPT is supported in:the SQL Command tool. Subqueries in constraint SQL.EXCEPT is not supported in the main statement of constraint SQL.EXCEPT is not supported in Logical View SQL.

Container health check for web portal

Hiya, We are looking into enabling health checks for our Service Framework containers. This works fine for most containers (either with or without HTTPS), except for containers serving up a web portal, which return a ‘404 Not Found’ response. I’ve been testing with a wget call:wget https://10.128.19.72:7777/health --no-check-certificate The log shows the expected rerouting to the service and connection name:Incoming 'https://10.128.19.72:7777/health' has been mapped to 'https://10.128.19.72:443/APP_PORTAL/APP_OUT/health'server-ip:10.128.19.72 method:GET uri:/health query:- server-port:7777 client-ip:10.131.33.222 client-user-agent:Wget/1.21.2 client-referer:-MediaType unresolved, set to octet stream, for website/health in WebSite/healthstatus-code:404 status-string:Not Found client-ip:10.131.33.222 method:GET uri:/health content-media-type:null time-taken:1 But that is not where the /health endpoint lives, of course… Anyone know of a way to work around this problem?

3 months ago

marc

Got a Question?

Synchronise version control in UDeliver?

Hiya,Is there a way in UDeliver to synchronise a (local) repository with a version control directory? Or better still, to create flat files and service framework servers directly from a version control directory?That would prevent the use of old code in a release if you forget to manually synchronise the (Service) Definer.I checked the UDeliver actions and UBlendIt functions, but there does not seem to be anything there that will do this.

recordStatus and applicationStatus

In USoft C/S UIs, recordStatus and applicationStatus allow you to get the status of the current record and the application as a whole. These are predefined, globally available host variables that you can reference in action script syntax like so:Syntax:recordStatus:applicationStatusrecordStatusThe recordStatus variable can take the following values.Value Meaning unchanged Record was retrieved by a query and has not been manipulated since. changed Record was retrieved by a query and then manipulated. created Record was created but not yet stored. This applies when you have navigated to a blank line in an info box, or opened a new info box showing an empty record, or pressed Create Record, and you have done nothing that causes the new record to be stored. query The current record line is in Query Mode. applicationStatusThe applicationStatus variable can take the following values.Value Meaning unchanged There are currently no uncommitted record manipulations. ch

RDMI middle ware error on mscorlib.dll

When opening the application under USoft 11 the startup event fires, invoking a component I_LOGGING.This component has an Assembly Reference to the mscorlib.dll, which it can not find. It throws an error as below. I do not have this dll in the USoft bin directory e.g. (assumption is that it is part of the windows version on my laptop).Strange thing is: colleagues do not run into this issue and they don’t have the dll either…Any idea what might cause this and how to fix this?

312

5 months ago

Rob.van.Haarst

Data transformation with XSLT

Mixing USoft application data into an XSLT transformation

When calling USXSL.APPLY or USXSL.APPLY2FILE, you can mix USoft application data into the transformation:By including one or more INVOKE statements into the input XML. By including one or more INVOKE statements into the XSLT stylesheet.INVOKE statements in the input XMLYou can get USoft application data into the input XML document at the time when you pass this XML document to be processed by USXSL.APPLY or USXSL.APPLY2FILE.ExampleThis example outputs a combination of customer data and employee data to a single output file. The effect of the XSLT transformation in this case is void: it simply copies the input XML to the output tree and writes that output to the file system.The output XML has the same format as the output of XML.MultiExportTables. This format is described in detail in USoft XML Format.SELECT usxsl.apply2file( '<?usoft-xml version="1.0" action="multi-tables-import"?> <MultiImport> ' || TO_CLOB(( INVOKE xml.export WITH SELECT * FROM CUSTOMER WHERE f

130

5 months ago

Rob.van.Haarst

Data transformation with XSLT

XSLT transformations

You can transform XML data by applying an XSLT transformation.Example: XSLT transformationAs an example, you can transform this input document:<Accredited_Persons documentName="Accredited Persons"> <PERSON ID="177" FAMILY_NAME="Haynes" FIRST_NAME="Deborah"/> <PERSON ID="112" FAMILY_NAME="Smith" FIRST_NAME="John"/></Accredited_Persons>to this different format:<Persons"> <Person ID="177"> <Name>Deborah Haynes</Name> </Person> <Person ID="112"> <Name>John Smith</Name> </Person></Persons>by applying this XSLT transformation:<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" encoding="UTF-8" omit-xml-declaration="yes"/> <xsl:template match="Accredited_Persons"> <Persons> <xsl:apply-templates select="*|text()|comment()|processing-instruction()"/> </Persons> </xsl:t

5 months ago

Rob.van.Haarst

SQL in USoft services

SQL statements in USoft services

USoft Service Definer lets you create REST services on the basis of SQL statements.One of the advantages of this facility is that it enables non-Java-programmers to create full-fledged REST functionality. All that is needed is a functional analysis of what data the REST service should retrieve or manipulate in the RDBMS. This functionality is expressed in simple SQL statements. You can have USoft Service Definer generate practically all the Java code that you need to make many typical REST services work. For this, you do not need any Java programming skills.In Service Definer, a SQL statement expresses a data retrieval or data manipulation action to be executed on behalf of a service caller by the underlying USoft Rules Engine.Valid SQL statements include all SELECT, INSERT, UPDATE, DELETE and INVOKE statements that the Rules Engine accepts to handle. SELECT, INSERT, UPDATE, DELETE statements must operate on one of the Tables or Logical Views declared in the underlying USoft model. INV

210

5 months ago

Events Calendar

Badge status

Ruchahas earned the badge Explorer
bert.wilmshas earned the badge Explorer
Rens Kersbergenhas earned the badge Explorer
rene.de.bruinhas earned the badge Explorer
rene.de.bruinhas earned the badge Scout

Show all badges

Build better products

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

View ideas

Welcome to the USoft Community

The short way

USoft Knowledge Base

Sign up for the community

Introducting USoft Community

USoft community categories

USoft headlines

Some of USoft knowledge base topics

Authorisation & Access

Business Rules

Web & App UIs

Events Calendar

Badge status

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

Need more help?

Start your conversation here

Off-the-Shelfs components

Welcome to the USoft Community

The short way

USoft community categories

USoft headlines

Some of USoft knowledge base topics

Events Calendar

Badge status

Build better products

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

Need more help?

Sign up for the USoft Community

Login into the USoft Community

Scanning file for viruses.

This file cannot be downloaded