---

var dataTable = new QueryTable("vZjOF9hm", {
    drawCallback: function (settings) {
        clickSecondaryTable();
    }
}, function () {
    var appData = registerTable.data();
    var data = {};

    data.registerId = (appData ? appData.id : -1);
    data.filter_snils = ($('#filter_uops_snils').val() || '').trim();

    var sid = urlParams.get('sid');
    if (sid) {
        data.id = sid;
    }

    return data;
});

$('#filter_uops_snils_search').click(function () {
    dataTable.reload();
});

$('#filter_uops_snils_reset').click(function () {
    $('#filter_uops_snils').val('');
    dataTable.reload();
});

$('#filter_uops_snils').on('keydown', function (e) {
    if (e.which === 13) {
        e.preventDefault();
        dataTable.reload();
    }
});






<div class="row">
    <div class="col-sm-12">
        <div class="row">
            <div class="col-sm-3">
                <label for="filter_uops_snils">СНИЛС</label>
                <input
                    type="text"
                    id="filter_uops_snils"
                    name="filter_uops_snils"
                    class="form-control"
                    placeholder="123-456-789 00"
                >
            </div>
        </div>

        <div style="margin-top: 10px; margin-bottom: 15px;">
            <button
                id="filter_uops_snils_search"
                type="button"
                class="btn btn-success"
            >
                <span class="glyphicon glyphicon-search" aria-hidden="true"></span>
                Найти
            </button>

            <button
                id="filter_uops_snils_reset"
                type="button"
                class="btn btn-warning"
            >
                <span class="glyphicon glyphicon-trash" aria-hidden="true"></span>
                Сбросить
            </button>
        </div>
    </div>

    <div class="col-sm-8">
        <jsp:include page="queryTable.jsp">
            <jsp:param name="queryTableCode" value="vZjOF9hm"/>
            <jsp:param name="queryTableStyle" value="white-space:nowrap;"/>
        </jsp:include>
    </div>
</div>





SELECT
    t.id AS id,
    coalesce(
        '<a target="_blank" href="view?viewCode=Client_list&id='
        || i.id || '">' || t.insurance_number || '</a>',
        t.insurance_number
    ) AS insurance_number,
    t.last_name AS last_name,
    t.first_name AS first_name,
    t.middle_name AS middle_name
FROM report.smev_uops t
JOIN ourpension.individual i
    ON i.insurance_number = t.insurance_number
WHERE t.smev_register_id = :registerId
AND 1 = 1

#if ($id)
    AND t.id = $id
#end

#if ($filter_snils && $filter_snils != '')
    AND regexp_replace(t.insurance_number, '[^0-9]', '', 'g')
        = regexp_replace(CAST(:filter_snils AS text), '[^0-9]', '', 'g')
#end