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
SQL QUERY
- support
- Site Admin
- Posts: 6221
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: SQL QUERY
6795 - is input field?
-
- Posts: 35
- Joined: 23 Jun 2021, 17:56
- Name: razli yahya
- Location: kuala lumpur
- Company Name: infracom sb
Re: SQL QUERY
6795 is sql formula field.
- support
- Site Admin
- Posts: 6221
- Joined: 19 Oct 2014, 18:22
- Name: Sergey Kharchishin
- Location: Russia, Evpatoriya
Re: SQL QUERY
You have to include sql formula, not field id because this is dynamic filed and stored in db.
-
- Posts: 35
- Joined: 23 Jun 2021, 17:56
- Name: razli yahya
- Location: kuala lumpur
- Company Name: infracom sb
Re: SQL QUERY
Hi ,
Noted and thanks.
br
Razli
Noted and thanks.
br
Razli