www.usoft.com To www.usoft.com

Replies posted by Harm Hofstee

21 Replies

Patrick Camphuijsen
Patrick Camphuijsen
published in UI Library

Handlebars

If it is necessary to translate 2 different words use:{{"SEARCH”}} {{lang "MySecondWord”}}Always use double quoutes especially if there are spaces in the translatable string.Leaving out the “lang” on the second part will only show the output if a translation exists.Adding “lang” on the first word will give duplicate output for the second word. 

593
Harm Hofstee
11 days ago
Rob.van.Haarst
Rob.van.Haarst
published in JavaScript

Promises for asynchronous Javascript

The udbPromise also has the method wait(). See the following example:   new udbPromise(…..)      .wait(20)      .then(() => console.log($.udb.currentFrameId))   ; 

2601
Harm Hofstee
19 days ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB udb

$.udb.navigateTo()

The option newPage: true does something extra for you, that is very important. It reduces the stack of pages if there is a stack. The stack of pages may be there if you are on a detailPage that you reached through a navigateToRelated(). Your application probably has a menu with items that navigateTo() pages. Here you should use:   navigateTo('the page to navigate to’, {newPage: true}If you do not use the NewPage: true option, you may get unpredictable errors. 

821
Harm Hofstee
1 month ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB Events

dataset

The current data source can be obtained:     $.udb(event.data.dsObj.id)And from there it is possible to get the path (which contains the current page):    $.udb(event.data.dsObj.id).path()

712
Harm Hofstee
1 month ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB Events

colpostupdate

The datasource can be obtained by    $.udb(options.col[0].dsc[0])

301
Harm Hofstee
1 month ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB Events

colpreupdate

The datasource for which the event fires can be obtained from the options parameter:    $.udb(options.col[0].dsc[0])

171
Harm Hofstee
1 month ago
Rob.van.Haarst
Rob.van.Haarst
published in RulesEngine internal component

RulesEngine.MessageLanguage

If you want to give a message and you do not want to define a message for it in the language tables, you can use the following sample:    INVOKE  RulesEngine.MessageLanguage WITH   SELECT  'USoft Message'   ,       'REPORT'   ,       'WARNING'   ,       'This data may be problematic; do you want to continue?' 'TThis data may be problematic; do you want to continue?' is your own string.'USoft Message’/'REPORT’ is an existing System message that accepts one parameter which will be the actual message.

1071
Harm Hofstee
2 months ago
Rob.van.Haarst
Rob.van.Haarst
published in RulesEngine internal component

RulesEngine.SetRole

To get the current role:      select role()

241
Harm Hofstee
3 months ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UI Library

Handlebars

Notice, that most text and labels in Webdesigner are automatically translated. So, in a label you do not need to use the lang helper handlebar.

593
Harm Hofstee
11 days ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UI Library

Handlebars

Nesting of handlebars Handlebars can be nested. Useful for example when you want to translate data from a datasource. The following could be the property of a labelControl residing under a ReplicatedColumnsControl.{{lang (data "TEXT_PROMPT")}}Notice the () around the "data” handlebar.

593
Harm Hofstee
11 days ago
Rob.van.Haarst
Rob.van.Haarst
published in Defining a default web application in USoft Definer

Template defaults: creating and re-applying your own defaults

  Escaping characters within properties Within propterties there are a few handy-to-know rules for dealing with special characters. Some are discussed here. TabEscape the tab with 	 otherwise it wil be replaced by a space. SpaceCan be used. No need to replace it with   NewlineUse 
 Apostrophe, single quoteUse ‘ or '.When using template scripting you can escape the apostrophe ‘ with a backslash \<esi:property name="sql" value="{'select \'' + table.getName() + '\' "TABLE_NAME"'}"/>This will result in the following script within the WebDesigner:select 'MyTable' "TABLE_NAME" The double quoteUse ". Accolade {If you have a property that starts with an {, then you need to escape itBy surrounding the whole property value by {<property value>} By surrounding the property valye by {'<property value>’} Add a space before the {This is useful for example if you use handlebars for example to make a string transla

951
Harm Hofstee
7 months ago
MaxMallon
MaxMallon
published in USMeta internal component

USMeta.Tables

Notice! that USMeta.Tables() only returns information on tables that the user has access to. In other words: the user must have foreground select privileges in order to see the table information for a table.

1031
Harm Hofstee
8 months ago
Rob.van.Haarst
Rob.van.Haarst
published in CurrentUser internal component

CurrentUser.SetProperty

See for how to define properties:  

291
Harm Hofstee
8 months ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB Events

dataset

@Patrick Camphuijsen In the description it says: "For available options, see the Options section at the end of this help topic”. There is no Options section. Would be nice to have. When the dataset event fires on a data source, I assume that the datasource has received its values and that you can retrieve the values from the datasource. This is not clear from the description, though. Please add this with a small piece of sample code.

712
Harm Hofstee
1 month ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB udb

$.udb.executeSQLStatement()

Read here how to create/define a SQL statement: 

1802
Harm Hofstee
11 months ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB udb

$.udb.executeSQLStatement()

    

1802
Harm Hofstee
11 months ago
Rob.van.Haarst
Rob.van.Haarst
published in Rules Engine properties

AllowSetManipulations

@Rob.van.Haarst zie dat de allowed values Yes | No zijn. in mijn applicatie zie ik dat de waarde op auto staat. Is dat ook een toegestane waarde? Dat gaat dan om de setting ALLOW_SET_MANIPULATIONS ik neem aan dat die met elkaar corresponderen.Overigens zie ik hier Yes | No en in de authorizer zie ik voor de meeste settings True | False gebruikt worden.

372
Rob.van.Haarst
1 year ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB Events

renderrow

Sometimes you need to know the corresponding data row for the rendered row. You can find the corresponding data row in the following way within the client script under a renderrow event:```var row = $(event.target).closest('[rowid]')var rowid = row.attr('rowid');var dataRow = $.udb(<your datasource>).rows('id', rowid);```You can use this if you want to enable or disable a button on the row depending on a value of a column in the row.

491
Harm Hofstee
1 year ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB Events

beforeexecutequery

Setting hostvars The beforeexecutequery can be used to set hostvars for a query.     options.options.hostvars.myhostvar = <yourvalue>; Within the beforeexecutequery event the options paramater is available. Using hostvarsThe hostvar can now be used in the where clause of the datasource:                   :myhostvar IS NULL    OR          mycolumn LIKE ‘%’ || :myhostvar || ‘%’ AdvantagesThe advantage of setting hostvars this way, is:that the hostvars are set locally for this query/datasource only and the hostvars are always set when the query is executed

741
Harm Hofstee
1 year ago
Patrick Camphuijsen
Patrick Camphuijsen
published in UDB Rowset

Rowset.sort()

The Rowset.sort() can now be used with    Rowset.sort({success: <success func>, error: <error func>}); It returns a promise, si it can also be used as:   Rowset.sort().then(<succes func>);

171
Harm Hofstee
1 year ago
MaxMallon
MaxMallon

Constraints that fire on query/touchNew

Nowadays there are applications that need to register/log who consulted data and at what time. Think of a patient treatment application where you need to know who consulted a patient dossier when. Or a policing application that has the same need.

2
Harm Hofstee
2 years ago

Badge winners

Show all badges
Terms & ConditionsCookie settings