Modifying a @Authors field

I have performed a survey.  In my views I have used @Name([OU1]; @Author) != "Name" to parse my data my area worked.  It was great and worked well.  I then wrote an agent that would search each document and look for comments and if the document had a comment it performed a action.  So now every document that has a comment as appended my name to the @authors field.

Bobby Socks/name/company, Jaziar/user/company

So now my logic

SELECT Form = "Survey" & @Name([OU1]; @Author) != "name"


Is not working.  I do not know how to parse it out of the view or do I have to edit the @authors field somehow??
Modifying a @Authors field
JaziarAsked:
Who is Participating?
 
Sjef BosmanGroupware ConsultantCommented:
Hm, I read your question again, with a clear mind, and I think I misunderstood you. Correct me if I'm wrong, but what you want is to select all documents that haven't been "authored" by someone with "name" in their name.

SELECT Form = "Survey" & !@IsMember("name"; @Name([OU1]; @Author))

That more like it? If not, replace @Author by $UpdatedBy, and try again.
0
 
Sjef BosmanGroupware ConsultantCommented:
The @Author is evaluated only once, and not for every document. You need a value inside the documents. Maybe, $UpdateBy will do the trick.

Try this one:
SELECT Form = "Survey" & @Name([OU1]; @Subset($UpdatedBy; -1)) != "name"
0
 
JaziarAuthor Commented:
Nope - did not work for me
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
SysExpertCommented:
I would suggest  that you use something like @explode to access just the first Author.
I hope this helps !

0
 
Sjef BosmanGroupware ConsultantCommented:
Heh... $UpdatedBy already is a string list...

If you want to see if "name" is a member of all previous authors of the document, you need to use @IsMember:

SELECT Form = "Survey" & @IsMember("name"; @Name([OU1]; $UpdatedBy))

Did you check the $UpdateBy field in the document properties of a Survey document??
0
 
qwaleteeCommented:
Unless you likit your $UpdatedBy tracking, the value will be there.

You really should have your own field on the form, Modifiers, value:
@If(@Subset(@ThisValue;1) = @UserName; @ThisValue; @UserName : @ThisValue)

Then, you would always be able to tell all the people who had touched the doucment USING YOUR FORM, and who the last one was -- @Subset(Modifiers;1)

That is basically what $UpdateBy does, except it tracks changes made by any method (form, agent, external program, replication conflict resolution).
0
 
JaziarAuthor Commented:
$UpdateBy does include both names.
0
 
JaziarAuthor Commented:
That was it
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.