Carey, Setup is ARS 7.0P2 ORACLE 10G
Adding 600 more temp field wont be a possible solution. Even checking with the transaction value with DB Value for all 596 fields wont be possible with filter Runif... Burning mind to have a generic solution Thanks and Regards, Ganga Prasad Pattnaik, ------------------------------------------------- 988-673-3435 On Thu, Feb 12, 2009 at 11:16 PM, Carey Matthew Black <black....@gmail.com>wrote: > Ganga, > > You did not mention what version of AR System your using.... So YMMV... > > If this message can be issued by a filter then I would look into this > feature. > > Ref: BasicGuide-630.2006.05.09.pdf > Section: Appendix B—Workflow extras > Pg: 619 > > Application-Copy-Field-Value <target_field_ID> <source_field_ID> > > Then you could set up a data driven way to do the following: > ) Loop over the data in the two sets of fields (both group1 and group2) > * You can move the value from the current field into a temp field > * You can use SQL to get the DB value for that field from the DB > into a second temp field > * You can see if the two tmp fields are different, if so set the > "change" flag for the group for the selected field group. > > ) Use the two flag fields that you have set and use the logic you have > posted in your question. > > > This however will be a performance drag. > You will be making 600 trips from the application server to the db > during every Modify. Not to mention the processing time to loop over, > let us say 10 filters per loop, 6000 more filters during each and > every Modify. > > > However... here is another entirely different approach... > > Use the "Log to File" action from a filter. Then write something that > parses the output of that file format and returns an indicator if > field from either of the two "groups" were in the Log to File entry. > The return value could be a "Y" or "N" for each group and ordered by > "Group1" then "Group 2". So the return values would be one of the > following: > "YY", (Yes for Group1, Yes for Group2) > "YN", (Yes for Group1, No for Group2) > "NY", ( No for Group1, Yes for Group2) > "NN", ( No for Group1, No for Group2) > > So the idea would be: > Filter N: > If Action: 1 --> Log to File > If Action: 2 -->'Results_field' = > $ PROCESS $ run_your_script $Request_ID_to_Check_Log_file_for$ > Filter N+1: > Run If: 'Results_field' = "YY" OR 'Results_field' = "NY" > If action: Message: "Bla..." > > But that requires a bit of development outside of AR too. > > > I think their may even be an option to use v7.1 Audit features too. > But that might be harder than it looks given when the Audit feature is > triggered. ( But maybe you could use it with "After Modify" Active > Links if that would meet the need.) > > HTH. > > However, I am also skeptical that a Filter based solution will work > for you given that you referenced the change flag not being enabled. > Maybe your trying to prompt the user and ask them a question rather > than just using a Message action? > > > Anyways.. just some thoughts. > > -- > Carey Matthew Black > BMC Remedy AR System Skilled Professional (BRSP) > ARS = Action Request System(Remedy) > > Love, then teach > Solution = People + Process + Tools > Fast, Accurate, Cheap.... Pick two. > > > > On Thu, Feb 12, 2009 at 10:31 AM, Ganga Prasad <ganga2...@gmail.com> > wrote: > > ** Hello There, > > > > I am playing with good and unique Requirement. Almost exhausted my mind. > Any > > idea would be appriciate.. > > > > I have a Regular Form with around 600 fields. Out of the 50 are Visible > > filed to user, 300 workflow purpose field and rest can be viewed by going > to > > other display only forms via clicking different button. > > > > I came across a requirement where it says if ONLY 4 Particular fields are > > modified, then it should not show any message Else it should show a > pup-up > > while saving. Currently we are showing the pup-up on every modify. > > > > Logically requirement would look as below > > > > Lets call the 4 field as Group1 fields and the rest 596 fields as Group2 > > fields > > any/all G1 fields modified + any/all G2 fields modified -> message should > > display > > any/all G1 fields modified + any G2 fields NOT modified -> message > should > > NOT display > > any/all G1 fields NOT modified + any/all G2 fields modified -> message > > should display > > any/all G1 fields NOT modified + any/all G2 fields NOT modified -> NO > NEED > > TO WORRY CAUSE SAVE BUTTON WONT ENABLE > > > > Thanks and Regards, > > Ganga Prasad Pattnaik > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"