Plaza 365
Plaza 365

No results found for your search

RegisterLog in

1

Relationship Columns added to DRB filter

Visit article

#dataverserestbuilder

#errorhandling

#n:1relationships

#querybuilding

#syntaxgeneration

Dynamics 365 CRM - Development

Category

Feb 7, 2022

Published date

Text

Article Type

AI Summary

  • The article discusses the limitations of the previous version of Dataverse REST Builder and introduces the new version (1.0.0.26) that overcomes these limitations.
  • The new version allows users to add "Relationship Columns" from the N:1 relationships, expanding the filter capabilities beyond the columns of the main table.
  • The article provides a screenshot highlighting the new button available in the UI for adding relationship columns, which have a different background color to separate them from primary table columns.
  • However, not all operators are available when dealing with relationship columns, such as the "Today" operator for DateTime columns. These operators have been removed for relationship columns.
  • Additionally, not all relationships can be navigated and filtered, such as the "Owner" relationship. However, relationships like "Owning Team" or "Owning User" can still be used.
  • The author admits to previously "spamming" Dataverse REST Builder when answering questions about Dataverse Web API, as the tool helps generate syntax for code and query errors.
  • The article concludes by acknowledging that some limitations may exist with the platform, but the new version of Dataverse REST Builder is still a useful tool for generating syntax and addressing code and query errors.

Registered users can view the full text for FREE!

Sign In Now!