MySQL query + function

Post Reply
p.dimitrov
Posts: 166
Joined: 12 Jul 2017, 09:35
Name: Pavel
Location: Varna

MySQL query + function

Post by p.dimitrov »

Hi, I'm using MySQL query in formula field [1052]. Formula is [1018]*[1194], which works well.
entity.jpg
Then I'm linking results in other entity with related items [1186] and using function {48:1186} to calculate total cost of attached items. Function doesn't work if "perform dynamically" is checked in MySQL query in field [1194].
function dont work.jpg
If it's unchecked function works:
function works.jpg
Attachments
function dont work.jpg
entity.jpg
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: MySQL query + function

Post by support »

This way is just not supported at the moment.
p.dimitrov
Posts: 166
Joined: 12 Jul 2017, 09:35
Name: Pavel
Location: Varna

Re: MySQL query + function

Post by p.dimitrov »

Ok, thanks Sergey.
Post Reply