Page 1 of 1

SQL QUERY

Posted: 12 Mar 2024, 22:56
by vesb
Hi,

I am attempting to create two SQL queries for Entity 1 with specific conditions.

The first query is functioning correctly. However, the second query, despite having the same conditions, returns a result of 0.00

Logically, given the same conditions, the data should be displayed. Please advise on what might be incorrect. Thank you in advance.

Regards
Razli

Re: SQL QUERY

Posted: 13 Mar 2024, 19:19
by support
6795 - is input field?

Re: SQL QUERY

Posted: 13 Mar 2024, 21:17
by vesb
6795 is sql formula field.

Re: SQL QUERY

Posted: 13 Mar 2024, 23:23
by support
You have to include sql formula, not field id because this is dynamic filed and stored in db.

Re: SQL QUERY

Posted: 17 Mar 2024, 10:58
by vesb
Hi ,

Noted and thanks.

br
Razli