You’re offline. This is a read only version of the page.
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,
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.
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.
Hi,
Can you try (SysQueryRangeUtil::valueNotEmptyString())
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,
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (