Timestamp format in Query Builder

[Marcelo Oliveira Santos]

Hi,

How to work with timestamp in Query Builder?

Tks,

Marcelo

[Aravinthan Seetharaman]

Hi Marcelo, 

 

Thanks for contacting Syncfusion Support. 

 

We have checked your requirement. We can use TimePicker in QueryBuilder by using ValueTemplate support. Please refer the below code snippet. 

 

 

@using Syncfusion.Blazor.QueryBuilder 

@using Syncfusion.Blazor.Calendars 

 

<SfQueryBuilder TValue="EmployeeDetails"> 

    <QueryBuilderColumns> 

        <QueryBuilderColumn Field="EmployeeID" Label="Employee ID" Type="ColumnType.Number" Step="5"></QueryBuilderColumn> 

        <QueryBuilderColumn Field="FirstName" Label="First Name" Type="ColumnType.String"></QueryBuilderColumn> 

        <QueryBuilderColumn Field="Title" Label="Title" Type="ColumnType.String"></QueryBuilderColumn> 

        <QueryBuilderColumn Field="HireDate" Label="HireDate" Type="ColumnType.Date" Format="HH:mm"> 

            <QueryBuilderTemplates> 

                <ValueTemplate> 

                    <SfTimePicker TValue="DateTime?" Step=60 Format="HH:mm"> 

                        <TimePickerEvents TValue="DateTime?" ValueChange="e => ValueChangeHandler(e, context)"></TimePickerEvents> 

                    </SfTimePicker> 

                </ValueTemplate> 

            </QueryBuilderTemplates> 

        </QueryBuilderColumn> 

    </QueryBuilderColumns> 

</SfQueryBuilder> 

 

@code { 

    public class EmployeeDetails 

    { 

        public int EmployeeID { get; set; } 

        public string FirstName { get; set; } 

        public string Title { get; set; } 

        public DateTime HireDate { get; set; } 

    } 

    public void   ValueChangeHandler  (Syncfusion.Blazor.Calendars.ChangeEventArgs<DateTime?> args, RuleModel Rule) 

    { 

        Rule.Value = args.Value; 

    } 

} 

 

 

For your reference we have prepared Sample here. 

 

Sample: https://www.syncfusion.com/downloads/support/forum/164327/ze/TimePicker_QB_Template883724986  

 

If we misunderstood your requirement, please share more details. So that we can work on this and provide you a better solution quickly. 

 

Regards, 

Aravinthan S

[Marcelo Oliveira Santos]

Hi Aravinthan S,

It works.

Thank you

Marcelo

[Aravinthan Seetharaman]

Hi Marcelo, 

 

Thanks for the update. 

 

We are happy to hear that your requirement has been achieved. Please feel free to contact us if you need any further assistance on this. 

 

Regards, 

Aravinthan S