setRulesFromSql method not working as expected

[Alejandro]

HTML:

<ejs-querybuilder width="80%" #constructorConsultas class="row" locale="sigaIdiomas" (created)="setRules2()" (actionBegin)="obtenerComboCampo($event)">

            <e-columns>

              <div *ngFor="let campo of configColumnasDTO.configColumnasQueryBuilderItem; let i = index">          

                <e-column *ngIf="campo.selectayuda == null && campo.tipocampo != 'date'" [field]="campo.idcampo" [label]="campo.nombreenconsulta" [type]="campo.tipocampo" [operators]="customOperators"></e-column>

                <e-column *ngIf="campo.selectayuda == null && campo.tipocampo == 'date'" [field]="campo.idcampo" [label]="campo.nombreenconsulta" [type]="campo.tipocampo" [operators]="customOperators" format="dd/MM/yyyy"></e-column>

                <e-column *ngIf="campo.selectayuda != null" [field]="campo.idcampo" [label]="campo.nombreenconsulta" [type]="campo.tipocampo">

                  <ng-template #ruleTemplate let-data>

                    <div class="e-rule e-rule-template">

                      <div class="e-rule-filter">

                        <ejs-dropdownlist (change)="fieldChange($event)" [fields]="data.fields" [dataSource]="data.columns" [value]="data.rule.field">

                        </ejs-dropdownlist>

                      </div>

                       <div class="e-rule-operator e-operator">

                        <ejs-radiobutton id="{{data.ruleID}}_operator1" label="Es igual" name='{{data.ruleID}}_operator' value='equal' (change)="operatorChange($event)" [checked]="(data.rule.operator == 'equal')"></ejs-radiobutton>

                        <ejs-radiobutton id="{{data.ruleID}}_operator2" label="Distinto" name='{{data.ruleID}}_operator' value='notequal' (change)="operatorChange($event)" [checked]="(data.rule.operator == 'notequal')"></ejs-radiobutton>

                      </div> 

                      <div class="e-rule-value e-value e-custom-value">

                        <ejs-dropdownlist (change)="valueChange($event)" [fields]="fields" [dataSource]="listaCombosObject.get(campo.nombreenconsulta).combooItems" [value]="data.rule.value">

                        </ejs-dropdownlist>

                      </div>

                      <div class="e-rule-value-delete">

                        <button class="e-removerule e-custom-delete e-rule-delete e-css e-btn e-small e-round">

                          <span class="e-btn-icon e-icons e-delete-icon"></span>

                        </button>

                      </div>

                    </div>

                  </ng-template>

                </e-column>

              </div>

            </e-columns>

          </ejs-querybuilder>

TS:

 setRules2(): void{

    if(this.constructorConsultas != undefined){

     /*  this.constructorConsultas.setRules({

          'condition':'and',

          'rules': [{

              "label": "TIPO COLEGIADO",

              "field": "3000",

              "operator": "equal",

              "type": "string",

              "value": "20"

          },

          {

            "label": "RESIDENTE",

            "field": "226",

            "operator": "equal",

            "type": "string",

            "value": "0"

        }

      ]}); */

      this.constructorConsultas.setRulesFromSql("450 = 'hfhg'");

      //this.constructorConsultas.setRulesFromSql("(TaskID = 1 and Status LIKE ('Assigned%')) and (TaskID = 1 and Status LIKE ('Assigned%'))");

      console.log(this.constructorConsultas.getRules());

    }   

  }

- Content of configColumnasDTO.configColumnasQueryBuilderItem:

1. onfigColumnasQueryBuilderItem: [{tipocampo: "string", idcampo: "226", nombreenconsulta: "RESIDENTE",…},…]
1. 0: {tipocampo: "string", idcampo: "226", nombreenconsulta: "RESIDENTE",…}
2. 1: {tipocampo: "number", idcampo: "3407", nombreenconsulta: "AÑOS EJERCICIO NATURALES", selectayuda: null}
3. 2: {tipocampo: "number", idcampo: "222", nombreenconsulta: "AÑOS COLEGIACION", selectayuda: null}
4. 3: {tipocampo: "string", idcampo: "3000", nombreenconsulta: "TIPO COLEGIADO",…}
5. 4: {tipocampo: "number", idcampo: "3002", nombreenconsulta: "AÑOS EJERCICIO", selectayuda: null}
6. 5: {tipocampo: "number", idcampo: "3412", nombreenconsulta: "SEMESTRES COLEGIACION", selectayuda: null}
7. 6: {tipocampo: "date", idcampo: "3037", nombreenconsulta: "FECHA INCORPORACION", selectayuda: null}
8. 7: {tipocampo: "string", idcampo: "455", nombreenconsulta: "ESTADOCIVIL",…}
9. 8: {tipocampo: "number", idcampo: "3410", nombreenconsulta: "AÑOS NATURALES DESDE F. JURA",…}
10. 9: {tipocampo: "string", idcampo: "230", nombreenconsulta: "COMUNITARIO",…}
11. 10: {tipocampo: "number", idcampo: "454", nombreenconsulta: "EDAD", selectayuda: null}
12. 11: {tipocampo: "string", idcampo: "3004", nombreenconsulta: "TIPO DE SEGURO",…}
13. 12: {tipocampo: "number", idcampo: "3408", nombreenconsulta: "AÑOS COLEGIACION NATURALES",…}
14. 13: {tipocampo: "string", idcampo: "3003", nombreenconsulta: "GRUPO CLIENTE",…}
15. 14: {tipocampo: "string", idcampo: "450", nombreenconsulta: "NIF/CIF", selectayuda: null}
16. 15: {tipocampo: "string", idcampo: "217", nombreenconsulta: "SEXO",…}
17. 16: {tipocampo: "number", idcampo: "3411", nombreenconsulta: "TRIMESTRES COLEGIACION", selectayuda: null}
18. 17: {tipocampo: "number", idcampo: "3409", nombreenconsulta: "AÑOS DESDE FECHA DE JURA", selectayuda: null}

method setRulesFromSql doesnt work with that code however If I do a simple try like this:

div *ngFor="let campo of configColumnasDTO.configColumnasQueryBuilderItem; let i = index">          

                <e-column *ngIf="campo.selectayuda == null && campo.tipocampo != 'date'" field="dni" label="DNI" type="string" [operators]="customOperators"></e-column>

+

 this.constructorConsultas.setRulesFromSql("dni = 'hfhg'");

changing field for dni instead using 450 in field attribute works, why doesnt work using campo.idcampo (450) and yes using dni value?

Besides when I used getSqlFromRules after doing the sql manually he gives me 450 = 'hfhg' but it doest work in setRulesFromSQl.

Thanks.

[Gayathri KarunaiAnandam]

Hi Alejandro,  

  

We have checked your reported query .We are able to replicate the reported issue. We need to validate more on this. So, we will update further details on 19th November 2021. We appreciate your patience until then.    

   

Regards,              

Gayathri K   

[Gayathri KarunaiAnandam]

Hi Alejandro, 

Thanks for the patience. 

We have checked your reported query and we can reproduce this issue in our end. We have confirmed this as an issue from our side. We have logged a bug report for this. You can track its status from the below feedback link. The fix will be provided in our patch release which will be scheduled on December 1^st,2021. 

Feedback: https://www.syncfusion.com/feedback/30500/when-field-is-set-as-number-setrulesfromsql-is-not-working 

We appreciate your patience until then. 

Regards, 

Gayathri K 

[Alejandro]

Hi Gayathri, despite I m logged the link shows me access denied.

Regards,

Alejandro.

[Sangeetha Priya Murugan]

Hi Alejandro,  

 

We have checked your reported issue and we would suggest you to logoff and login with Syncfusion credentials. Or clear your cache and try again once. If still issue persist, please share us screenshot of the issue.   

 

Regards, 

Sangeetha M 

[Alejandro]

Hi, Has It been released the needed 1st December patch for solving this issue?

[Gayathri KarunaiAnandam]

Hi Alejandro,  

We are sorry for the delay. 

We are facing more complexity in fixing this issue. So, we will include this fix in our upcoming patch release which will be scheduled for December 8th,2021 and we appreciate your patience until then. You can track its status from the below feedback link. 

Feedback: https://www.syncfusion.com/feedback/30500/when-field-is-set-as-number-setrulesfromsql-is-not-working

We appreciate your patience until then. 

   

Regards,  

Gayathri K  

[Alejandro]

Hi, was the patch released? I have tried with v19.3.57 version released 7th December but the problem still persists.

Regards.

Alejandro.

[Gayathri KarunaiAnandam]

Hi Alejandro,   

We are deeply sorry for the delay.  

We need to ensure more test cases for this fix. So, we will include this fix in our Volume 4 main release which will be scheduled for December 17^th,2021. You can track its status from the below feedback link.  

Feedback: https://www.syncfusion.com/feedback/30500/when-field-is-set-as-number-setrulesfromsql-is-not-working 

We appreciate your patience until then.  

    

Regards,   

Gayathri K   

[Gayathri KarunaiAnandam]

Hi Alejandro, 

We are glad to announce that our Essential Studio 2021 Volume 4 release v19.4.0.38  is rolled out and is available for download under the following link. 

 https://www.syncfusion.com/forums/171304/essential-studio-2021-volume-4-main-release-v19-4-0-38-is-available-for-download 

Feedback: https://www.syncfusion.com/feedback/30500/when-field-is-set-as-number-setrulesfromsql-is-not-working 

Sample: https://stackblitz.com/edit/angular-t1nbsn?file=app.component.html 

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

Regards,           

Gayathri K