Unable to filter GridForeignColumn using FilterByColumnAsync

[Rahul Shokeen]

1. I have two text box.

<SfTextBox @bind-Value="@Region" Placeholder="Region" FloatLabelType="FloatLabelType.Auto" ShowClearButton="true"></SfTextBox>
<SfTextBox @bind-Value="@PartyName" Placeholder="Party" FloatLabelType="FloatLabelType.Auto" ShowClearButton="true"></SfTextBox>

2. A search button.

<SfButton @onclick="Search" Content="Search" IconCss="e-secondary e-icons e-search" IsPrimary="true"></SfButton>

3. A Grid with two GridForeignColumn

<GridForeignColumn Field="@nameof(Client.ContractPk)" HeaderText="Region" ForeignKeyField="@nameof(ClientParties.ContractPk)" ForeignKeyValue="Region" ForeignDataSource="@ClientParties" Visible="false"></GridForeignColumn>

<GridForeignColumn Field="@nameof(Client.ContractPk)" HeaderText="Party" ForeignKeyField="@nameof(ClientParties.ContractPk)" ForeignKeyValue="PartyName" ForeignDataSource="@ClientParties" Visible="false"></GridForeignColumn>

4. A search filter on external text box

public async Task Search()
{
  await this.ClientGrid.FilterByColumnAsync("ContractPk", "contains", Region ?? "");
  await this.ClientGrid.FilterByColumnAsync("ContractPk", "contains", PartyName ?? ""); 
}

---------

Field name is same for Foreign Column:

await this.ClientGrid.GetColumnFieldNamesAsync();

Is there any way to change the field names for the Foreign Column?

[Monisha Saravanan]

Hi Rahul,

Greetings from Syncfusion support.

currently we are validating the reported query at our. We need some more time to analyze your query. So we will update you the further details in two business days on or before August 21, 2022.

Until then we appreciate your patience.

Regards,

Monisha

[Monisha Saravanan]

Hi Rahul,

Sorry for the delay in getting back to you.

We had tried your requirement using FilterByColumnAsync method and we are facing similar issue when using multiple foreign key with same field name. So we are checking the possibility in achieving your requirement using query property at our end. we are currently checking your requirement with high priority and we will update further details within 24 August, 2022.

Until then we appreciate your patience.

Regards,

Monisha

[Monisha Saravanan]

Hi Rahul,

Thanks for the patience.

We have checked your query and faced complexities in achieving your solution at sample level. We have achieved filtering in our source by using Column Uid so it does not cause any issues while using inbuilt filtering for multiple columns with same field name. Kindly share us whether it will be fine, if we provide support to filter the Grid based on column Uid externally. Based on your response we will proceed further at our end.

Please let us know if you have any concerns.

Regards,

Monisha

[Rahul Shokeen]

Hi Monisha,

Yes, that would solve the issue as well. I couldn't see any filtering on Column Uid, is this something I can do after updating the package ?

If there is another way I can achieve this then that would be great.

[Monisha Saravanan]

Hi Rahul,

Thanks for contacting Syncfusion support.

We have considered it as a usability improvement and logged a task “Need to provide support to filter column using Column UID programmatically”. We have planned to implement and include this improvement in our upcoming 2022 Vol 3, service pack release.

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link. You can also communicate with us regarding the open feature any time using our above feedback report page.

https://www.syncfusion.com/feedback/37346/need-to-provide-support-to-filter-column-using-column-uid-programmatically

Until then we appreciate your patience.

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization”

Regards,

Monisha

[Monisha Saravanan]

Hi Rahul,

Due to some unforeseen circumstances, we could not include the reported issue as promised. So we have planned to include this in our upcoming volume release which is expected to be rolled out on November 16^th    , 2022.

We will update you once the release is rolled out. Until then we appreciate your patience.

Disclaimer : Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.

[Monisha Saravanan]

Hi Rahul,

We are glad to announce that, we have included fix for the issue “Need to provide support to filter column using Column UID programmatically” in our release (20.3.0.60).  So please upgrade to our latest version of Syncfusion NuGet package to resolve the reported issue. Please find the Nuget package for latest fixes and features from below.

Nuget : https://www.nuget.org/packages/Syncfusion.Blazor.Grid

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. 

Please let us know if you have any concerns.