We're updating the issue view to help you get more done.Learn more

Rules engine filter count always return 0 when sql select is having error

Case
when custom website_user.cfc have overriding field e.g. `property name="_version_is_draft" autofilter=false;`

function _dbFieldListToSelectFieldsArray appear to show duplicate columns which lead to SQL error and rules engine counter always return 0.

e.g.

select count(1) as `record_count` from ( select `website_user`.`id`, `website_user`.`login_id`, `website_user`.`email_address`, `website_user`.`password`, `website_user`.`display_name`, `website_user`.`active`, `website_user`.`reset_password_token`, `website_user`.`reset_password_key`, `website_user`.`reset_password_token_expiry`, `website_user`.`last_logged_in`, `website_user`.`last_logged_out`, `website_user`.`last_request_made`, `website_user`.`rest_api_enabled`, `website_user`.`rest_api_key`, `website_user`.`rest_api_last_access`, `website_user`.`rest_api_access_count`, `website_user`.`person`, `website_user`.`fpp_id`, `website_user`.`_version_is_draft`, `website_user`.`_version_has_drafts`, `website_user`.`sync_last_in_sync_date`, `website_user`.`sync_last_in_job_id`, `website_user`.`sync_remote_is_missing`, `website_user`.`datecreated`, `website_user`.`datemodified`, `website_user`.`_version_is_draft`, `website_user`.`_version_has_drafts` from `psys_website_user` `website_user` where website_user.sync_remote_is_missing is null or website_user.sync_remote_is_missing = 0 ) `original_statement`

Status

Assignee

Unassigned

Reporter

Johnson Cheng

Accepted

Yes

Fix versions

Priority

Medium