Павел Разуваев (Все сообщения пользователя)

$state = \Bitrix\Bizproc\Workflow\Entity\WorkflowStateTable::getList([
    'filter' => [
        'STATE' => CBPWorkflowStatus::Out(CBPWorkflowStatus::Completed),
        '>=MODIFIED' => $oldDate
    ],
    'select' => [
        '*',
        'IBLOCK_ID' => new ExpressionField('IBLOCK_ID', 'MID(%1$s,8)', ['TEMPLATE.DOCUMENT_TYPE']),
        'IBLOCK_INFO'
    ],
    'runtime' => [
        'IBLOCK_INFO' => [
            'data_type' => '\Bitrix\Iblock\IblockTable',
            'reference' => array(
                'this.IBLOCK_ID' => 'ref.ID'
            ),
            'join_type' => "left"
        ]
    ]
]);

$state = \Bitrix\Bizproc\Workflow\Entity\WorkflowStateTable::getList([
    'filter' => [
        'STATE' => CBPWorkflowStatus::Out(CBPWorkflowStatus::Completed),
        '>=MODIFIED' => $oldDate
    ],
    'select' => [
        '*',
        'IBLOCK_ID' => 'TEMPLATE.DOCUMENT_TYPE',
        'IBLOCK_INFO'
    ],
    'runtime' => [
        'IBLOCK_INFO' => [
            'data_type' => '\Bitrix\Iblock\IblockTable',
            'reference' => array(
                'ref.ID' => new SqlEx * pression('MID(this.IBLOCK_ID, 7)'),
//                'this.IBLOCK_ID' => 'ref.ID'
            ),
            'join_type' => "left"
        ]
    ]
]);

[Bitrix\Main\DB\SqlQueryException]
Mysql query error: (1054) Unknown column 'this.IBLOCK_ID' in 'on clause' (400)
SEL ECT
`bizproc_workflow_entity_workflow_state`.`ID` AS `ID`,
`bizproc_workflow_entity_workflow_state`.`MODULE_ID` AS `MODULE_ID`,
`bizproc_workflow_entity_workflow_state`.`ENTITY` AS `ENTITY`,
`bizproc_workflow_entity_workflow_state`.`DOCUMENT_ID` AS `DOCUMENT_ID`,
`bizproc_workflow_entity_workflow_state`.`DOCUMENT_ID_INT` AS `DOCUMENT_ID_INT`,
`bizproc_workflow_entity_workflow_state`.`WORKFLOW_TEMPLATE_ID` AS `WORKFLOW_TEMPLATE_ID`,
`bizproc_workflow_entity_workflow_state`.`STATE` AS `STATE`,
`bizproc_workflow_entity_workflow_state`.`STATE_PARAMETERS` AS `STATE_PARAMETERS`,
`bizproc_workflow_entity_workflow_state`.`MODIFIED` AS `MODIFIED`,
`bizproc_workflow_entity_workflow_state`.`STARTED` AS `STARTED`,
`bizproc_workflow_entity_workflow_state`.`STARTED_BY` AS `STARTED_BY`,
`bizproc_workflow_entity_workflow_state_template`.`DOCUMENT_TYPE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_TEMPLATE_DOCUMENT_TYPE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`ID` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_ID`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`TIMESTAMP_X` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_TIMESTAMP_X`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`IBLOCK_TYPE_ID` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_IBLOCK_TYPE_ID`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`LID` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_LID`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`CODE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_CODE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`API_CODE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_API_CODE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`NAME` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_NAME`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`ACTIVE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_ACTIVE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`SORT` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_SORT`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`LIST_PAGE_URL` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_LIST_PAGE_URL`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`DETAIL_PAGE_URL` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_DETAIL_PAGE_URL`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`SECTION_PAGE_URL` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_SECTION_PAGE_URL`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`CANONICAL_PAGE_URL` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_CANONICAL_PAGE_URL`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`PICTURE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_PICTURE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`DESCRIPTION` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_DESCRIPTION`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`DESCRIPTION_TYPE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_DESCRIPTION_TYPE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`XML_ID` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_XML_ID`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`TMP_ID` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_TMP_ID`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`INDEX_ELEMENT` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_INDEX_ELEMENT`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`INDEX_SECTION` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_INDEX_SECTION`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`WORKFLOW` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_WORKFLOW`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`BIZPROC` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_BIZPROC`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`SECTION_CHOOSER` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_SECTION_CHOOSER`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`LIST_MODE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_LIST_MODE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`RIGHTS_MODE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_RIGHTS_MODE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`SECTION_PROPERTY` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_SECTION_PROPERTY`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`PROPERTY_INDEX` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_PROPERTY_INDEX`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`VERSION` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_VERSION`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`LAST_CONV_ELEMENT` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_LAST_CONV_ELEMENT`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`SOCNET_GROUP_ID` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_SOCNET_GROUP_ID`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`EDIT_FILE_BEFORE` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_EDIT_FILE_BEFORE`,
`bizproc_workflow_entity_workflow_state_iblock_info`.`EDIT_FILE_AFTER` AS `BIZPROC_WORKFLOW_ENTITY_WORKFLOW_STATE_IBLOCK_INFO_EDIT_FILE_AFTER`,
`bizproc_workflow_entity_workflow_state_template`.`ID` AS `UALIAS_0`
FR OM `b_bp_workflow_state` `bizproc_workflow_entity_workflow_state`
LEFT JOIN `b_iblock` `bizproc_workflow_entity_workflow_state_iblock_info` ON `bizproc_workflow_entity_workflow_state_iblock_info`.`ID` = MID(this.IBLOCK_ID, 7)
LEFT JOIN `b_bp_workflow_template` `bizproc_workflow_entity_workflow_state_template` ON `bizproc_workflow_entity_workflow_state`.`WORKFLOW_TEMPLATE_ID` = `bizproc_workflow_entity_workflow_state_template`.`ID`
WHERE UPPER(`bizproc_workflow_entity_workflow_state`.`STATE`) like upper('Completed')
AND `bizproc_workflow_entity_workflow_state`.`MODIFIED` >= '2021-01-13 17:40:57'
/var/www/app/bitrix/modules/main/lib/db/mysqliconnection.php:137

Mysql query error: (1054) Unknown column 'this.IBLOCK_ID' in 'on clause' (400).

window.JSSets.prototype.Add2Set = function(){
    if (this.add2SetCalled)
        return false;

    if($('.sets-table').is(':hidden')) {
        $('.sets-table').fadeIn();
    }

    this.ConstructSetsTableRow();

    $('.check-table').append(this.tableRow);
    

    BX.bind(BX(this.deleteRowId), "click", BX.proxy(this.RenameAddButton, this));
    
}

window.JSSets.prototype.DeleteTableRow = function() {

    alert('УРА! Работает!');

}

(function (window) {
    window.JSSets = function (arParams) {
        this.containerId = '';
        this.addButtonId = '';
        this.product = {
            id: 0,
            name: '',
            img: '',
            price: 0,
        };
        this.obProduct = null;
        this.obAddButton = null;
        this.obSetTableRow = null;
        this.emptyTableRow = '#empty_row';

        if ('object' === typeof arParams){
            this.containerId = arParams.PRODUCT_CONTAINER_ID;
            this.addButtonId = arParams.ADD_BUTTON_ID;
            this.tableRowId = this.containerId + '_row';
            this.product.id = arParams.PRODUCT.ID;
            this.product.name = arParams.PRODUCT.NAME;
            this.product.img = arParams.PRODUCT.SRC_IMG;
            this.product.price = arParams.PRODUCT.PRICE;
            this.product.article = arParams.PRODUCT.ARTICLE;
        }
        BX.ready(BX.delegate(this.Init, this));
    }

    window.JSSets.prototype.Init = function(){
        this.obProduct = BX(this.containerId);
        this.obAddButton = BX(this.addButtonId);
        if(!!this.obAddButton){
            this.prop = 1;
            BX.bind(this.obAddButton, "click", BX.proxy(this.RenameAddButton, this));
        }

        if(this.obSetTableRow === null) {
            this.obSetTableRow = $(this.emptyTableRow);
        }
    }

    window.JSSets.prototype.Add2Set = function(){

        alert(this.prop);

    }

    window.JSSets.prototype.RenameAddButton = function() {

        BX.unbind(this.obAddButton, 'click', BX.proxy(this.RenameAddButton, this));
        $(this.obAddButton).text('Добавлен');

    }
})(window);

BX.unbind(this.obAddButton, 'click', BX.proxy(this.RenameAddButton, this));
$(this.obAddButton).text('Добавлен');
this.Add2Set();

BX.unbind(this.obAddButton, 'click', BX.proxy(this.RenameAddButton, this));
$(this.obAddButton).text('Добавлен');
BX.proxy(this.Add2Set, this));

BX.unbind(this.obAddButton, 'click', BX.proxy(this.RenameAddButton, this));
$(this.obAddButton).text('Добавлен');
BX.delegate(function(){
        this.Add2Set();
    }, this));

а также и вот так: 

BX.unbind(this.obAddButton, 'click', BX.proxy(function(){
   this.Add2Set();
}, this));
$(this.obAddButton).text('Добавлен');

<div id="comp_72f8219f96395bf34e419e6a1b5a7657">

.......

</div>