I think you should still be able to set up data selection rules based on instance variables or project variables? E.g. project variable Environment Name (of type System): 

Hi @RLB,

Unfortunately for instance variables, there is no “Environment Name” System type variable or equivalent that I have found. This is indeed what we use in version 20 when using project variables. 

@pontus.berglund You can create a Dynamic variable like this:

SELECT CASE 
    WHEN RIGHT(@@SERVERNAME,4)='-DEV'
	AND RIGHT(DB_NAME(),4)='-DEV'
	THEN 'Development'
    WHEN RIGHT(@@SERVERNAME,4)='-DEV'
	AND RIGHT(DB_NAME(),5)='-TEST'
	THEN 'Testing'
    ELSE 'Production'
END

Hi @rvgfox,

Thanks, yeah we were discussing doing something like this, and I agree it’s probably the best solution as of now. It would be nice if there was a no (or low) code solution, but I’m sure that’s on its way.

@pontus.berglund  Did you ever implement a workable solution? We also want to limit the amount of records ingested in our DEV environment. Right now you can't use custom data selection rule when the data is coming from ODX Server, so the dynamic variable is not going to work on the DSA.

@RobertU, we ended up creating an instance variable that we named “storage database” where we used “SELECT DB_NAME()”. We then used a data selection rule on an appropriate date field filtering on “greater than 2024-01-01” with a condition that “storage database = DB_Dev”.

It’s not very dynamic unfortunately, but it did the trick for us.

Hi,

upvoting this: 

should hopefully help to get this improved in future.

@pontus.berglund Thank you for your response. Will try your solution, it is something at least. Hopefully they will come up with a proper solution in the foreseeable future.