List of records by MySQL query

Post Reply
pepe
Sponsor
Sponsor
Posts: 556
Joined: 25 Aug 2015, 21:35
Name: Pepe
Location: Graz, Austria
Contact:

List of records by MySQL query

Post by pepe »

I am getting errors when using the new field type. I have tried this feature on various entities and different field types in coditions. In this example, [314] and [1654] are numeric input fields. Unfortunately, always error message.
Here is the setup:
2020-07-07_List from MySQL query_2.JPG
This is the message:
2020-07-07_List from MySQL query_1.JPG
Thank you for your help.
Best regards, Pepe
enishemed
Posts: 651
Joined: 30 Oct 2017, 11:24
Name: Enis Hemedoglu
Location: Istanbul, Turkey
Company Name: SCORE DANISMANLIK
Contact:

Re: List of records by MySQL query

Post by enishemed »

Hi, I used something like this and it works.
Attachments
Screenshot_20200707-212039_Samsung Internet.jpg
pepe
Sponsor
Sponsor
Posts: 556
Joined: 25 Aug 2015, 21:35
Name: Pepe
Location: Graz, Austria
Contact:

Re: List of records by MySQL query

Post by pepe »

Hello Enis,
if I use an number or string literal on the right hand side of the equal sign then I get it to work as well. However, this is the only way that works for me and I need to use a field value.
Thanks again.
Best, Pepe
Post Reply