Credits to @m.gechev . Original is KB1670 Record Link Field Since revision 115202, the Expression tools plugin provides a UI element in the architect that can be used to create a link to another record in the application. This field is of numeric type and in a sense, it is an autocomplete eleme…

@Joeri @Joram @HibaalZoobe this would make a lot of concepts much cleaner!

@j.batzke great improvement, love to see this ‘morphing’ feature. Two questions: What are your experiences on performance compared to searchlinks? Are there (future) plans to replace a growing amount of search links on core concepts such as applogs and Activities?

Hey David, thanks for your question. I have no personal experience with the performance of this feature, I am just the messenger :slight_smile: @m.gechev built it and @Stefan has implemented already. They probably have an answer. As far as I know, there are no plans yet except for the gradual impl…

Hi David, What are your experiences on performance compared to searchlinks? I don’t think you can really compare performance between the two. Searchlinks - load Number of records of the configured type and you select one. The record link field is simply a numeri field, used in combination with …

This development was actually launched with a performance case related to Application Logs, in an application with 20k+ log entries per day, 10M+ log entries and 50+ columns. Having 2 columns for all references, means you only need one index on two columns to make it searchable. With 50 columns, y…

Read this if you want to use the plugin to filter records: [image] Creating application logs for your processes Wiki For those that are wondering, these are the exact steps that you need to perform to set up a filter for application log records with the new approach: Mak…

Nice, I know a good application for this in our Database Insights component. Question: I’m trying to use the DB_TypeisDB and in a filter you have: boolean:type_is_db(this) But when I try to add this via the expression editor I’m not able to select this. I’m only able to enter a string, so I tried…

Hi Joeri, It’s an architect bug but with a workaround. When you hold ALT while dragging the THIS element, it works.

Okay, that’s something that should be fixed then, but thanks! Nevertheless, the better questions is: what button to hold on the macbook? Option, command, control don’t seem work…

Hi Joeri, I tried it here on our mac and with the option key pressed we also get the alt-overrule functionality. What is important is to first drag the “this” node in the expression editor, drop it somewhere and only after having it dropped in the expression editor you can drag it again (with optio…

Link records based on expression strings

Wiki

j.batzke September 10, 2024, 9:56am 7

Read this if you want to use the plugin to filter records:

Topic		Replies	Views
Retriving record from record and type reference [Q&A] Components, Datasets and Plug-ins	0	37	May 30, 2025
Querying in an expression, using datatype string [Q&A] General	8	264	June 28, 2024
Database structure plugin question [Q&A] General	2	107	July 1, 2025
Creating application logs for your processes Wiki	11	466	July 1, 2025
Data structure plugins documentation [Q&A] General	5	144	July 15, 2025

Link records based on expression strings

Related topics