Z9_MV Field Clean Up Z9_MVFieldCleanUp True Removes second value from a mutivalue field WF_Agent-10 -1 f5684e96-2676-458e-bbbb-66fe8e02273b 6gcoJuirnQk5blBoiB9wvr/ILt++7j/F /PKR396ID4DrCy1bz62XhZZDOfuoH9uBHnx2GwPW6fG6bsCCeICKi2PZK2nvesUE2ro/1zMr2XuRSzDyzaN2SOAOo1LL2RvxleVS2EuL+9uDABhDRP7FdbBsR7Kqk4wnpFMSDiVcysW/EotlRduukZz2ciQO5hhrJ+JYY2QmJdo9UFbNcEuxJRuSCZXOIxuVkMtTQ/sPn9siNmTgIvPRV5yuWmI66N8r9thAvmOJzPWiZA5WlNVnLmYK+QYoJx4s3WCw5WDnGJBVWuSkEQuaANRqK6ariwMT7j/PEvxAf77S0HncvEqUe5f10XXwJTq6tlhU3gL2IqtDdgSD0T9EnDceDof+Ys+cxBXyJnM7BaspAQMGhNBmRO5YGZiTMpi7a8zMNeBCPkca1W+33dHR8cYphZL0rdl9wS4yG34Hr16fwN4QU5EEcvzivzz0BWv2FVCfqhiPQOLm0MOodwYEKbfwf6e5Nk4VDJXkMOPcwQ+DYZcrgllKNiUEx9PuyM4DK2ZLwuA5+IXTV+dYKrcpT56QomSWecgIUKkt4btMKxpgUqDPK3S8x++R10xWLxYILD5C8yEnb3QA7lEsDOWPTbjvImuKZMVJ5tLici6foj9OJvOYoLkkIBBAcxWyNnAX4MqdYc8l44TdDopExtCw/TmtSEqkiDsD3CTtk9YGgx+128cnQX7dg9AKP3mhOjio6OF0DjQlthI5GAYi1JPdNvt/5ljtIX/ssC2aXnIpSyyIAcPRRFm1wNbNbapoFERiUr+ghNGFvFZIv9NOI4YOeUd2LKfLrXD7K0ntASUGxHVh7wGzWx1VhHxStF37ILLRvmyD2x0faRT/iZBjuKZ466M6VZVP1kiz/IV5dcY6Oq1EitS5Yj9qkQ3G4jAsPrD6A/WbJ1xR2qbqbYvOq930fsWVLJO/TzXvEuYN3y8hkpxuN6ABGXqIsM9CXiRdLRCH8XM+wIM5WgxFozwrkXyS5Yj/DfaPwYxAKB85m8k+wqeQpww0LJfEKvGmxYpSRdPc6GCL38sjhZKjIe35M3DJwvAVKX6s3Vr3XX0oom/WXlaIUgdfsZR96eD/Pq+/IuGAmXN5pql3LLg= LF Support Lookup 14 1603ff32-8011-4d63-8442-30e2d4d6dd2e LFSQL10 LF_Support WF_Lookup Running Completed Terminated en-us Administrator 2017-05-23T00:44:47.897Z 54 11 LFSRVDAS10 24307997-0840-44f3-839e-53e4953f555f Track Tokens TrackTokens True Records the values of selected tokens when the workflow runs. You can view these values in the Tokens tab in the workflow's Search Details pane. Get the TOCIDs GettheTOCIDs True 1603ff32-8011-4d63-8442-30e2d4d6dd2e Select TOCID from dbo.MVFieldCleanUp Where Status = '0' Order by TOCID Iterate through the table Iteratethroughthetable True Working Tokens WorkingTokens True TOCID %(Iteratethroughthetable_TOCID) MVFieldArray Find Entry FindEntry True Find an entry using its ID or location and make it available to other Activities in your workflow definition. f5684e96-2676-458e-bbbb-66fe8e02273b %(TOCID) Is the document there? Isthedocumentthere True f5684e96-2676-458e-bbbb-66fe8e02273b Doc Exists DocExists True FindEntry Get the Claim Staff Field Values GettheClaimStaffFieldValues True f5684e96-2676-458e-bbbb-66fe8e02273b Claim Staff For Each Value ForEachValue True String %(GettheClaimStaffFieldValues_Claim Staff_All) Index 1 or 1+ Index1or1 True f5684e96-2676-458e-bbbb-66fe8e02273b First Value FirstValue True ForEachValue 1 Assign Token Values AssignTokenValues True MVFieldArray MVFieldArray WorkingTokens %(GettheClaimStaffFieldValues_Claim Staff_All#[%(ForEachValue_Iteration)]#) All Other values AllOthervalues True Replace with Blank ReplacewithBlank True MVFieldArray MVFieldArray WorkingTokens Assign Field Values AssignFieldValues True f5684e96-2676-458e-bbbb-66fe8e02273b Claim Staff List true Replace %(MVFieldArray) Do Nothing DoNothing True Update Data UpdateData True Updates the column values of a subset of rows in the selected data source. 1603ff32-8011-4d63-8442-30e2d4d6dd2e %(TOCID) 1 True True True True True True True True True false 1.0 14 LF Support Lookup DataSource Z9_MV Field Clean Up <SourceInformation DataSourceType="Direct" DSNType="User" Authenticated="true"> <Location> <HostName>LFSQL10</HostName> <ServerInstance /> <DatabaseName>LF_Support</DatabaseName> <LocationType>ServerDatabase</LocationType> </Location> <Authentication> <UserName></UserName> <SecureString Version="2" Value="" /> </Authentication> <Adapter> <type key="sql" default="false" category="DirectDataSource"> <typename>Laserfiche.Project.Data.Runtime.Sql, Laserfiche.Project.Data, Version=8.3.1.0, Culture=neutral, PublicKeyToken=607dd73ee2bd1c00</typename> <names default="Sql"> <add code="en" value="Sql" /> </names> </type> </Adapter> <OtherOptions ActualType="Laserfiche.Collections.PropertyBag, Laserfiche.Base, Version=9.0.0.0, Culture=neutral, PublicKeyToken=607dd73ee2bd1c00"> <Properties /> </OtherOptions> </SourceInformation>