Use pre defined value in front end function and in conditions

bonkersdeluxe

Hi,
Ive an stupid question?
How must the condition looks?

to Explain what i mean.

Ive created an relation it calls settings.
I will use this table with predefined dataset to control my application.
This table has only one dataset, and every column is an setting.
The first setting called debug_enables as an boolean.
With this value i will check is debug on or off.
I make this dataset not delete able, but changeable

Ive created an basic form were i can change the setting(s)

And now comes the thing ;-)
How can i read the value, this method not work

true or 1 not work

And how can i access this dataset in frontend function do make use of message boxes or form messages.
I did not found an instance function to use it.
Pseudo code, not an real function:
Exist an function like this for example
if(app.getpredfined_dataset("setting.debug_mode") == true) { app.form_show_message("info: "+app.get_field_value({F9: 0 customer_adresses.customerid}), 20000); }

Make use from Global variables are only valid to the browser window/tab. Not the whole site over all browser windows.
Ive tried the first run, with global variable but without success, because the other tabs dont know that the variable change. So i think with predefined dataset was the better approach
Thank you very much!
Best regards bonkersdeluxe

ACCFreiburg

I'm not a member of the official REI3 support team, but maybe I can help you.

It looks like you're comparing the dataset ID of the predefined dataset to a fixed value instead of the value you stored in the dataset.

I implemented something very similar in my applications by reading the value from the settings table using a backend function. This backend function is called by a frontend action when the form is loaded and returns the value that is used to initialize a variable. The condition can then use the value of the variable for its decision.

gabriel

This use case is what collections are built for. They fetch data for a user during login (and event-driven, if an update is requested) - and provide the values as defaults or filter conditions and so on.

To work with collections in functions, you can use the available instance functions to get the current collection values and/or update them when relevent.

When working with collections, be aware that they return a list of rows, with each row containing values for each attribute.

Of course, you can also call backend functions to query the DB on demand, as @ACCFreiburg mentioned. Is a bit more overhead usually, but you get the live data every time and do not need to care about updating your collection on change. 🙂