If you want to confirm group membership, use the Application-Confirm-Group run process. You can pass the username and group id to the command and you will get back a 0 for false or a 1 for true. This will give more reliable results than using the GROUP keyword.
So, assuming you created a display only field zTmpGroup-ConfigManager and set that using the run process. Then your qualification would be: 'zTmpGroup-ConfigManager' != 1 AND 'Completed?' != 'DB.Completed?' If Completed is a required field, you could alternatively use this qualification, which is more efficient (1 less trip to the DB): 'zTmpGroup-ConfigManager' != 1 AND 'TR.Completed?' != $NULL$ These things can also be enforced through field permissions. You can give a group write access to a field and Public read access to a field. Axton Grams On Wed, Nov 2, 2011 at 3:48 PM, Drew Shuller <[email protected]> wrote: > Hello listers, can I get a sanity check please? > > How do you write a filter Run If that allows a person that owns an RFC > (this is a custom app) to modify the record, but only if he is > changing a specific field? Otherwise, an error message should stop the > filter. The Configuration Manager and the system admin should be able > to change the record whenever they want. No one else should be able to > modify the record. > > These two Run If statements do what I want unless I put them into one > Run If statement, joined with an OR: > > (( 'Completed?' != 'DB.Completed?') AND ($USER$ != 'ChangeOwnerLoginName')) > > and this one: > > (( 'DB.RFC Status' = "Approved With Changes" ) AND (NOT ($GROUPS$ > LIKE "%Configuration Management%" )) AND (NOT ($GROUPS$ LIKE > "%Admin%" ))) > > During testing, the Config Manager can update the RFC, but not if he's > changing the "Completed?" field. The Change Owner can't modify the RFC > at all. After a couple of days of hacking away I'm pretty confused. > Thanks for any and all help! > > Drew > Comayagua > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
