GetNamedParameterSql date error

[Ryan Tomko]

Version: 33.2.15

Using the SfQueryBuilder, I can successfully get a filter on a date column using "Greater Than" or "Less Than".  However if I use BOTH at the same time then i get this error:

System.FormatException

  HResult=0x80131537

  Message=The input string 'date' was not in a correct format.

  Source=System.Private.CoreLib

  StackTrace:

   at System.Number.ThrowFormatException[TChar](ReadOnlySpan`1 value)

   at System.Int32.Parse(String s, IFormatProvider provider)

   at Syncfusion.Blazor.QueryBuilder.Internal.QueryLibrary`1.GetNamedParameter(String field, List`1 namedParameters)

   at Syncfusion.Blazor.QueryBuilder.Internal.QueryLibrary`1.UpdateValue(List`1 rules, Boolean isNamedParameter, Object[] ruleVal, Dictionary`2 namedRuleVal, List`1 namedParameters)

   at Syncfusion.Blazor.QueryBuilder.Internal.QueryLibrary`1.UpdateRuleValue(RuleModel rule, Boolean isNamedParameter, Object[] ruleVal, Dictionary`2 namedRuleVal)

   at Syncfusion.Blazor.QueryBuilder.Internal.QueryLibrary`1.GetParameterizedNamedSql(RuleModel qbRule)

   at Syncfusion.Blazor.QueryBuilder.SfQueryBuilder`1.GetNamedParameterSql(RuleModel rule)

when doing this:

        var rules = QueryBuilderObj.GetValidRules();
        var filter = QueryBuilderObj.GetNamedParameterSql(rules);

 

Again, if i only use one condition (either less than or greater than) then it works fine.  Only if there are both conditions does the error happen.

[Priyanka Karthikeyan]

Hi Ryan Tomko,

Thank you for reporting the issue.

We have attempted to reproduce the behavior you described using latest version by applying multiple date conditions (for example, Greater Than and Less Than) on the same date field and invoking:

var rules = QueryBuilderObj.GetValidRules();

var filter = QueryBuilderObj.GetNamedParameterSql(rules);

Sample: https://www.syncfusion.com/downloads/support/directtrac/general/ze/FormatException

However, we were unable to reproduce the reported exception in our testing environment.

To help us better understand and investigate the issue, could you please share the following details:

• A reproducible sample that demonstrates the problem.
• The step-by-step replication procedure.
• The complete column configuration used for the date field.
• The exact date values, operators, and rules used when the exception occurs.
• Any customization or additional logic implemented around the QueryBuilder component.
• A screen recording/video showing the issue, if possible.

With these details, we will be able to validate the scenario in the same configuration and investigate the root cause further.

We look forward to your response.

Regards,
Priyanka K