Workflow scheduler relationship issue

[JackBuchanan]

Issue

Query fails for workflow when condition is based on a studio made relationship when run in scheduler

Expected Behavior

Workflow should run as expected

Actual Behavior

Workflow fails to run

Possible Fix

Steps to Reproduce

1. Create a relation on Calls module with type one to many to Opportunities module
2. Go to Workflow module and create new Workflow on Opportunities module
3. Add condition on module Opportunities and field Calls to be equal to empty
4. Run scheduler
5. See fails query in logs: Query Failed: SELECT opportunities.id AS id FROM opportunities WHERE opportunities.calls_opportunities_1calls_ida = '' AND opportunities.deleted = 0 : MySQL error 1054: Unknown column 'opportunities.calls_opportunities_1calls_ida' in 'where clause'

The query fails because the relation is not taken into an account.

Context

Cann use scheduler for workflow

Your Environment

• SuiteCRM Version used: 7.10.25
• Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): chrome lastest
• Environment name and version (e.g. MySQL, PHP 7): MySQL, PHP7.2
• Operating System and version (e.g Ubuntu 16.04): ubuntu 18.04