Hi Sergie,
I tested it and it's working thanks alot :D
4. using advanced filtering or the sysComputedColumn, then i have to use range on data project level. I can't do it in code?
Few questions related to your sentence
Range on data source it's a hard-coded range that can't be changed without development. The range on entity-level doesn't work for me, but I suppose that it should work as ranges on the query: a predefined set of ranges which can be changed in a data project
a. Range on data source it's a hard-coded range that can't be changed without development:
You mean if the range in dataSource query is A. Then i can't change A in data project? what if i put in data project level !A what would happen?
also if in data project i put Status = B and dataSource range was A.... would it take is A or B OR A and B?
b. The range on entity-level doesn't work for me, but I suppose that it should work as ranges on the query: a predefined set of ranges which can be changed in a data project
Here you mean if range in entity range was A, if i try to put anything on data level project ranges, it will clear A at all. and will start looking at my new data project level or what?
c. since entity range is the same as query range. Then i can write something hardcoded right?
what should i put the property value exactly? how can i write it? and should i include quotations somewhere?