Skip to Content

TVARVC vs SETLEAF - For custom application value maintenance.

Feb 19, 2017 at 08:27 PM


avatar image
Former Member


I have list of values to be pulled from various applications with different conditons. Each value has its application area as top node. For example,

Value = ABC

Area = Sales

Value = XYZ

Area = Services

As I said earlier, I want to pull all values in Application A, want to pull values of area Sales in Applicable B. And, business may come up with more values in future.

I want to leverage SETLEAF or TVARVC to maintain these values.

Question is, in TVARVC if I maintain area name in paramater name (which has scope to modify or new values in future), my query that is intended to pull all areas may not work. I need to try something like below to pull all records with area like 'App_%'

Area = App_Sales, App_Services

I am not liking this approach as it doesnot look clean to me.

How about using SETLEAF here? Can we use SETLEAF for custom application parameters? If yes, should I go for multi-dimentional SETs here?



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers