Skip to main content
On the backlog

Lookup combo values based on table value function

Related products:Software FactoryIndicium Service Tier
Arjan Sollie
Thinkwise blogger

When adding or updating a record I often find myself in a situation where I would like the selection (combo lookup) of field C to be filtered based on values I have set in fields A and B. Currently the Software Factory only allows you to create such a behavior when you include fields A and B to the lookup reference column list. This poses a bit of an issue when for example you would like to filtered based upon a date field.

There is a better way to create such behavior. If the Software Factory would allow you to determine the lookup combo values based upon a tabled value function. You could then include the values of fields A and B into the parameter set of the function. 

Did this topic help you find an answer to your question?

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi,

We are working on allowing function-typed tables to be created in the Software Factory. That will solve this idea :smile:

"Wake me up before you low-code"
Arie V
Community Manager
Forum|alt.badge.img+12
  • Arie V
  • Community Manager
  • February 2, 2023

@Mark Jongeling since your comment is from 1.5 year ago and I am not sure when this was set to status Planned: can we expect this solution to be included in Release 2023.2?

Mark Jongeling
Administrator
Forum|alt.badge.img+23
Planned→On the backlog
 
We are still planning on doing this, but it hasn’t been worked on for quite some time now. I'll set the status to On the backlog to reflect the status of the implementation.
"Wake me up before you low-code"
Freddy
Forum|alt.badge.img+16
  • Freddy
  • Thinkwise Local Partner Brasil
  • April 5, 2023

Hi @Mark Jongeling ,

Does this also include alignment of the combos, only the combo control now allows for example to show image and text.. Does this also gets to be included in this idea and a reference lookup?  Especially in the latter it's something we're missing.  In our case a status.. Where I want to see the icon + text.

LEF — Lift. Empower. Fulfill. [lef.digital]
Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi Freddy,

I do think that is a separate idea to this. This idea focusses on populating a combo box using the dataset retuned by a function-typed table.

"Wake me up before you low-code"
M
Sidekick
Forum|alt.badge.img+1
  • ‘Not yet available’ A function-typed table is read-only and uses a [table-valued function](#table-valued-function-as-a-table) generated by the Software Factory as a data source. It can solve performance problems if data in a query is filtered based on parameters instead of retrieving all data and then filtering.

I see i can add one on the design screen and it add with table type 2 

and it generates a function deff

Coold it be possible to make it a “ multi-statement table-valued functions “  i see the one that is created now  is a single statement

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi @Marco Maat,

It does seem to be present indeed, but I highly discourage you from using this functionality as this is not yet support by our runtimes (Indicium, GUI's etc.).

The current intended way of creating these table valued function is through Subroutines. I'm afraid I do not have a timeline of when we (finally) can release this as table type.

Edit: Next Windows GUI version (2023.3.11.0) will no longer show the option to add the unsupported table type.

"Wake me up before you low-code"
Harm Horstman
Superhero
Forum|alt.badge.img+21

Any news on this? 


3 years old idea and already quite a few votes…

Logic will get you from A to B. Imagination will take you everywhere (Albert Einstein)
Arie V
Community Manager
Forum|alt.badge.img+12
  • Arie V
  • Community Manager
  • January 2, 2025

​@Harm Horstman Applications running on a 3-tier architecture are a pre-requisite for proper implementation of this Idea. We do have it high on the list and I expect we'll implement it in 2025.2 or 2025.3.

Harm Horstman
J. de Lange
2 people like this
  • Harm Horstman
    Harm Horstman
  • J. de Lange
    J. de Lange


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings