Search found 320 matches

by fahmisalim
10 Oct 2018, 14:10
Forum: Discussion
Topic: MySQL Query Result Cannot use as filter
Replies: 8
Views: 965

Re: MySQL Query Result Cannot use as filter

I have send PM to you for other issue come in, but I cannot show screen shot here,

Please check

Thank you
Regards,
Fahmi Salim
by fahmisalim
10 Oct 2018, 12:27
Forum: Discussion
Topic: MySQL Query Result Cannot use as filter
Replies: 8
Views: 965

Re: MySQL Query Result Cannot use as filter

its works well..

thank you sergey
by fahmisalim
10 Oct 2018, 11:40
Forum: Discussion
Topic: MySQL Query Result Cannot use as filter
Replies: 8
Views: 965

Re: MySQL Query Result Cannot use as filter

filter Not work
filter dont have value
Screen Shot 2018-10-10 at 14.37.52.png
by fahmisalim
10 Oct 2018, 11:19
Forum: Discussion
Topic: MySQL Query Result Cannot use as filter
Replies: 8
Views: 965

Re: MySQL Query Result Cannot use as filter

fahmisalim wrote: 10 Oct 2018, 10:56 I cannot find attachment
Your attachment missing
by fahmisalim
10 Oct 2018, 10:56
Forum: Discussion
Topic: MySQL Query Result Cannot use as filter
Replies: 8
Views: 965

Re: MySQL Query Result Cannot use as filter

I cannot find attachment
by fahmisalim
10 Oct 2018, 10:30
Forum: Discussion
Topic: MySQL Query Result Cannot use as filter
Replies: 8
Views: 965

MySQL Query Result Cannot use as filter

Dear Sergey, Finally I success to use MySQL Query field, but result from MySQL Querry CANNOT use as filter either in Automatic status or Automatic status or elsewhere Please see my attachment Screen Shot 2018-10-10 at 13.25.23.png Screen Shot 2018-10-10 at 13.25.06.png Screen Shot 2018-10-10 at 13.2...
by fahmisalim
10 Oct 2018, 07:16
Forum: Discussion
Topic: Mysql Query to get id field
Replies: 9
Views: 1291

Re: Mysql Query to get id field

Case close...using mysql query using e.id that can be related and take any data between sub entity under parent id

Perfecto!!
by fahmisalim
09 Oct 2018, 05:18
Forum: Discussion
Topic: Mysql Query to get id field
Replies: 9
Views: 1291

Re: Mysql Query to get id field

Dear Sergey, I put formula field in entity 29 as below Screenshot_20181009-081419_Samsung Internet.jpg With structure entity as below IMG-20181008-WA0003.jpg I just want get value 1 from entity 34 from field 442 compare to ID entity 29 if same that will be show number 1 Note: field 442 in entity 34 ...
by fahmisalim
08 Oct 2018, 13:35
Forum: Discussion
Topic: Mysql Query to get id field
Replies: 9
Views: 1291

Re: Mysql Query to get id field

Let say entity 29 is orders from customer and to proceed the order, user need to fill entity 34. The only relation id between 29 and 34 is entity_field, let say entity_field id is [422]. So I want to make mysql query field in entity_29 to take any value from entity_34 which [422] should same with id...
by fahmisalim
08 Oct 2018, 12:11
Forum: Discussion
Topic: Mysql Query to get id field
Replies: 9
Views: 1291

Re: Mysql Query to get id field

Please kindly find attachment for my entity structure,
IMG-20181008-WA0003.jpg
I want to get some value from entity 34 to entity 29 that to use in automatic status. That item in entity 29 proceed in entity 34