There is nothing wrong with the use of TR and DB comparisons - in fact it is the only way out when you really want to compare what is in the database currently, and what is being sent forth as a transaction on modification filters.
You could not use it if you want to but that would mean you would have to build hidden fields and additional logic on GE to set those hidden fields with values that have been retrieved, if you want to compare them with values that are set during the transaction. That is additional work that might not have been necessary. There are examples again when setting hidden fields with current values may be preferred over TR and DB use, for e.g. If you want to use both the values OR if you want to use the 'previous' value in post transaction logic such as notification or other things. But I do not see why the use of TR and DB in filter comparison can be a bad thing IF used correctly. I have capitalized IF because it is easy to misunderstand the use of TR and DB and wrongly construct your qualification, and get a weird result especially when comparing your TR value to NULL. BE VERY CAREFUL in evaluating your qualifiations when comparing your TR value to NULL and understand what TR means thoroughly before you use it. I'm quite certain you might have misunderstood the directions of the likes of Misi if they had a recommendation on this concept. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of James Smith Sent: Thursday, May 08, 2014 11:22 AM To: [email protected] Subject: Transactional (TR) and Database (DB) Hi List, We can achieve things without using TR and DB values in a filter by just using Field but I do not understand why they have been developed to use? I have heard from many remedy developers like Misi and BMC who suggest not to use TR and DB in Run If qualification of a filter but why? Why it is not recommended to use TR and DB values? What if I use TR.Field=DB.Field? Will it yield a correct result? In BMC documentation also they have not given any example where they used TR and DB together in a qualification. Appreciate your thoughts! Cheers, James ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
