Add "extra values" from a custom rule to the summary view

Hi SyncFusion Team,

currently I'm trying to add "extra values" within a custom rule.

I tried many things but I didn't get it to make an export of the added values to the "Summary View".

Can you help me somehow with this topic?

Screenshot of the desired output:Desktop - 1 (3).png

Best Regards

J.M.


2 Replies

YA YuvanShankar Arunagiri Syncfusion Team August 25, 2022 12:31 PM UTC

Hi Joachim,


We have checked your reported query and need to validate more on this. So, we will try to achieve this requirement by custom sample, and we will update further details on or before 31st August 2022.


Regards,

YuvanShankar A



YA YuvanShankar Arunagiri Syncfusion Team September 2, 2022 11:53 AM UTC

Hi Joachim,


We have validated your reported query and prepared the sample based on your requirement. Based on our query builder architecture we can set extra value to the SQL value of query builder. But we can achieve your requirement by using the rule with custom object. In custom object of rule, we can set the extra value of column and processing it sample level and get customized SQL value. Please refer the below code snippet and sample link.


[app.component.ts]:

getSql() {

        var SQL = "";

        var rule = this.qryBldrObj.getValidRules();

        for (var i = 0; i < rule.rules.length; i++) {

            var rul = rule.rules[i];

            SQL += rul.field + '( ' + rul.custom.checkBoxVal + ' + ' + rul.custom.headerVal + ' ' + rul.operator + ' ' + rul.value + ' & ' + rul.custom.radioBtnVal + ' ) ';

            if (i !== rule.rules.length - 1) {

                SQL += rule.condition + ' ';

            }

        }

        console.log(SQL);

    }

Sample link: https://stackblitz.com/edit/angular-rnj7gw?file=app.component.ts

Could you please check the above code and get back to us, if you need any further assistance on this. 


Regards,

YuvanShankar A


Loader.
Up arrow icon