Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Answered

Ranges in data entity not working

Posted on by 897

Hi guys,

What is the logic when we added Ranges in Data Entity ?

My issue is, I have created Data Entity, some of the fields are coming from a view method which then I have added a "StringUnmappedField" and then added Ranges in that Data Entity Node using the earlier "StringUnmappedField" which already set to connected to the view method.

The purpose of this range is to exclude empty, so in the range, value is != ""

But nothing's happened, after Build and synchronized, when I checked in SSMS, there are still a lot of empty string on that field.

When I checked the underlying "select query" of that view (data entity), I didn't find my range criteria as well, Is that why my range is not working ? and how to make it work ?

Thanks,

  • Alex VN Profile Picture
    Alex VN 1,994 on at
    RE: Ranges in data entity not working

    Hi,

    I remembered seeing this issue before. The Ranges on the Data entity seems to have no effect, not sure if it is a bug or not.

    A work around that you can try is to set the range on the datasource node instead the ranges on dataentity node, I would expect that to work as expected.

    Hope this helps.

  • supertobi Profile Picture
    supertobi 5 on at
    RE: Ranges in data entity not working

    I had the same problem. This ranges do not work. (I used a BYOD without staging table) You can add a filter like WillWU wrote, but then you have to remember the filter every time you set up the entity. If you ask me, this is a bug from MS.

    pastedimage1644504816482v1.png

  • AnithaEswaran Profile Picture
    AnithaEswaran 2,032 on at
    RE: Ranges in data entity not working

    Hi,

    Can you try (SysQueryRangeUtil::valueNotEmptyString())

  • Verified answer
    WillWU Profile Picture
    WillWU 22,350 on at
    RE: Ranges in data entity not working

    Hi Tony,

    Did you solve your problem?

    If you want to filter the data when using data management, you could add a filter in your data project simply, just click the funnel icon in the Filter column.

  • Tony zhong Profile Picture
    Tony zhong 897 on at
    RE: Ranges in data entity not working

    Hi Andre,

    No, I tried to use the range in the Data entity it self, not the data source which build it.

    It's something like this:

    pastedimage1618838485073v2.png

    So the field which I'm using in that Range is already included in that Data Entity fields.

    Thanks,

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,219 Super User 2024 Season 2 on at
    RE: Ranges in data entity not working

    Hi Tony,

    When I read your question, I'm getting confused. Have you set a range on a data source of the entity or are you trying to achieve that via a computed field? Note that T-SQL used in a method for the computed field is not filtering the records. It is only used to get a value in it.

    You can set ranges on the data sources itself.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans