userprofilerecord.php

<?php
namespace Bitrix\Main;
 
use Bitrix\Main\Entity;
 
class UserProfileRecordTable extends Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_user_profile_record';
    }
 
    public static function getMap()
    {
        return array(
            new Entity\IntegerField("ID", array(
                'primary' => true,
                'autocomplete' => true,
            )),
            new Entity\IntegerField("HISTORY_ID", array(
                'required' => true,
            )),
            new Entity\StringField("FIELD"),
            new Entity\TextField('DATA', array(
                'serialized' => true
            )),
            new Entity\ReferenceField("HISTORY",
                '\Bitrix\Main\UserProfileHistoryTable',
                array('=this.HISTORY_ID' => 'ref.ID'),
                array('join_type' => 'INNER')
            ),
        );
    }
 
    public static function deleteByHistoryFilter($where)
    {
        if($where == '')
        {
            throw new ArgumentException("Deleting by empty filter is not allowed, use truncate (b_user_profile_record).", "where");
        }
 
        $entity = static::getEntity();
        $conn = $entity->getConnection();
 
        $conn->query("
            DELETE R FROM b_user_profile_record R 
            WHERE R.HISTORY_ID IN(
                SELECT ID FROM b_user_profile_history 
                {$where} 
            )"
        );
 
        $entity->cleanCache();
    }
}