jquery queryBuilder add alias to sql column

I am using Jquery Query Builder in an PHP application. https://querybuilder.js.org/

How can i prefix sql result with alias
like this

alias.column=value AND alias.column2=value2 AND alias.column3=value3 OR alias.column4=value4

my code is

        var sql = resH = '';
        var result_json = builder.queryBuilder('getRules');
        if(result_json) {
            var res = builder.queryBuilder('getSQL');
            var resH = builder.queryBuilder('getHumanCond');
            if(typeof res.sql != 'undefined') {
                var sql = res.sql;
            }
        }
        $('#cond_sql').val(sql);

Source: Symfony4 Questions

Was this helpful?

0 / 0

Leave a Reply 0

Your email address will not be published. Required fields are marked *