SegmentDataTable::deleteByGroupId

static function deleteByGroupId(int $groupId)
{
	$entity = static::getEntity();
	$connection = $entity->getConnection();

	$selectedRows = SegmentDataTable::getList([
		'select' => ['ID'],
		'filter' => ['GROUP_ID' => $groupId],
		'limit' => 1000,
	])->fetchAll();

	$idsToDelete = array_column($selectedRows, 'ID');
	if (empty($idsToDelete))
	{
		return '';
	}

	$ids = implode(',', $idsToDelete);

	$sql = "DELETE FROM b_sender_group_data WHERE ID IN ($ids)";
	$connection->queryExecute($sql);

	return SegmentDataClearJob::getAgentName($groupId);
}