Ranges in data entity not working

(0) Share

Report

Posted on by Tony zhong

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,

All responses (6)

Answers (1)

Alex VN 1,994 on at

Like (0)

Report

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 5 on at

Like (0)

Report

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.
AnithaEswaran 2,032 on at

Like (0)

Report

RE: Ranges in data entity not working

Hi,

Can you try (SysQueryRangeUtil::valueNotEmptyString())
Verified answer

WillWU 22,350 on at

Like (0)

Report

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 897 on at

Like (0)

Report

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:

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

Thanks,
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (1)

Report

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.