Error outputting message for values.

Pelcig

Hello.
It seems to me that the frontend is working with variables a little incorrectly.
I created a backend function:
`$BODY$
DECLARE
--n1 TEXT := 'HP';
--n2 TEXT := 'HP';
N integer;
BEGIN

IF EXISTS (SELECT 1 FROM {app_izdeliya}.[tip_izdeliy] WHERE (app_izdeliya.tip_izdeliy.tip_izdeliya)=text_for_check LIMIT 1) THEN
	N := 1;
ELSE
	N := 0;
END IF;
RETURN N;

END;
$BODY$`

It works correctly and returns 0 or 1.
I also created a frontend function:
app.call_backend({app_izdeliya.check_tip_in_base}, app.get_field_value({F0: 0 tip_izdeliy.tip_izdeliya})).then( res => {app.set_field_error({F0: 0 tip_izdeliy.tip_izdeliya}, res) }, // if success: return value in 'res' err => { } // if error: error message in 'err' )
If I enter something that is not in the database, then 0 is displayed.
If I enter something that is not in the database, then either nothing is displayed (if it was not entered previously), or 0 continues to be displayed (if there was a check previously that it was not in the database).

But if you do something similar for relation, the display occurs correctly. (0 if there is none and 1 if there is).

Platform version 3.9.2.5465

gabriel

Pelcig But if you do something similar for relation, the display occurs correctly. (0 if there is none and 1 if there is).

To troubleshoot your issues, please take a look at the return value from your function call and check the error case too, such as:

app.call_backend({app_izdeliya.check_tip_in_base}, app.get_field_value({F0: 0 tip_izdeliy.tip_izdeliya})).then(
	res => {
		console.log(res);
		app.set_field_error({F0: 0 tip_izdeliy.tip_izdeliya}, res);
	},
	err => {
		console.warn(err);
	}
);

The console.log() / console.warn() calls, will output the values to your browser console - to view the console, enable developer mode (F12 on most browsers, and then click on the 'console' tab).

Please try this and report the results.

Pelcig

I tried your option with both variables and field and didn't see any errors.
But it doesn't work with my form, log attached, I'll try to describe the problem more precisely and compare what works with what doesn't.

But it doesn't work with my form, the log is attached, I'll try to describe the problem more precisely and compare what works and what doesn't later. In the log, what's in yellow is the button press when the HDD was selected (the zero doesn't disappear, but remains.)

There is also a point that I did not understand.

In the variable I select some value. In the field I select to show the value (it's text) and the text is shown in the form.

But if I try to get the value of what is in the field, instead of the value I get the ID of this value (which is specified in relations ). Is this how it is intended or should the values be obtained differently?
app.get_variable({app_izdeliya.add_tip_i_podtip_v2.Tip})

gabriel

The logging was not for checking if there are errors - it was primarily for checking if the function executed and what it returned.

In your screenshot, it logged 0 once, which makes sense. If you then try it again and the 0 does not disappear, does the log also show something? Or does nothing appear? If its the later, then your function is not executed a second time. In this case, you need to check, where your function is executed from. Is it a form function? Or does is run on value change of an input field?

To your other question regarding the variable input: Relationship inputs always return the ID (or IDs if multi-input) of the records that you select. This is on purpose and can be used to filter for relationships somewhere else. You won´t get any other data from a relationship input.

Pelcig

The log shows the error: "failed to encode args[0]: unable to encode 2 into text format for text (OID 25): cannot find encode plan"
As I understand it, this error is caused if the base function accepts TEXT, while "variable read" passes integer.
When I changed both sides to integer, the error disappeared.
It can be considered that this happened because such work was not obvious to me, and I expected to see the value that I saw on the screen.

Thanks for explaining how the element works.

gabriel

This makes sense. Thank you for the update.