TopLogic - the automated application engine
  • Releases
  • Dokumentation
  • Github
  • Discord
  1. Home
  2. Releases
  3. TL_7.10.3
  4. #29064

7.10.3
TopLogic Release

2026-06-03

enhancement

major
#29064
TL-Script: Optimization of database queries with parameters

defect

major
#29257
Missing object type in transient revisions
minor
#29061
Missing replacement of KnowledgeItem by ObjectKey in Collections in Queries
#29305
Error when creating a configured TL script function
#29318
ChangeSet analysis fails with unversioned types
enhancement

major

#29064

TL-Script: Optimization of database queries with parameters

RESTTLScript

The following TL-Script function is optimized by Top-Logic to a database query that returns a result very quickly:

all(`myModule:myType`).filter(x -> $x.get(`myModule:myType#id`) == "4711")

However, if you outsource exactly the same thing to a method and call it, no optimization takes place and the result calculation takes many times longer:

calcValue = id -> { all(`myModule:myType`).filter(x -> $x.get(`myModule:myType#id`) == $id) }; $calcValue("4711")

This problem occurs, for example, if you have an endpoint in the REST server with the parameter "searchedID" and then make a call in this endpoint like:

all(`myModule:myType`).filter(x -> $x.get(`myModule:myType#id`) == "searchedID")
  • Get Started
  • Github
  • Discord
  • Das Unternehmen hinter TopLogic
  • Softwareentwicklung heute
  • Kontakt

© Copyright – Business Operation Systems GmbH

  • top-logic.com
  • Nutzungsbedingungen
  • Impressum
  • Rechtlicher Hinweis
  • Datenschutz
  • DE
  • Login