Adhoc filter query

Like (0) Share

Report

Posted on 23 Mar 2022 03:48:48 by Axal

945

Hi,

In Dataverse, when in one table and looking at Data tab, will it be possible to do some adhoc query or filter ? ->

I know I can create View and adding filter on that view, but I only need to do this temporarily and could be different field every time, and will have so much unused view cluttering my table if I create it for this matter.

Thanks

Categories:

Tables

Microsoft Dataverse

All responses (1)

Answers (1)

Verified answer

ChrisPiasecki 6,397 Most Valuable Professional on 23 Mar 2022 at 03:56:21

Like (1)

Report

Re: Adhoc filter query

Hi @Axal,

From within the maker portal, you're a bit constrained with using views in that data tab.

If you are in a model driven app, you can use the Advanced Find feature to do ad-hoc querying.

You can also run ad-hoc queries in SQL Server by connecting to Dataverse via the TDS Endpoint.

Another useful tool is SQL 4 CDS via the Xrmtoolbox.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.