...
Code Block |
---|
DEFAULT{ Action=SetVar; VarName=LastSync; VarValue=@@LastSyncTime; | Action=SetVar; VarName=CurrentUserId; VarValue=@@CurrentUserId; | Action=SetVar; VarName=AppVersion; VarValue=@@AppVersion; | Action=SetVar; VarName=LastSyncSuccess; VarValue=@@LastSyncSuccess; | Action=SqlQuery; QueryString=SELECT CASE WHEN '%%LastSyncSuccess%%' = 'TRUE' THEN 1 ELSE 0 END AS SyncSuccess; QueryReturnFields=SyncSuccess; QueryTest=%%SyncSuccess%%=1; QueryTestTrue=UpdateUser; QueryTestFalse=NoAction; } UpdateUser{ Action=SqlQuery; QueryString=SELECT CASE WHEN CAST('%%AppVersion%%' AS INT) < 6 AND '%%LastSyncSuccess%%' = 'TRUE' THEN 0 ELSE 1 END AS ReturnVal; QueryReturnFields=ReturnVal; QueryTest=%%ReturnVal%%=0; QueryTestTrue=Update_User_5.0; QueryTestFalse=Update_User_6.0; } Update_User_5.0{ Action=SqlQuery; QueryString=UPDATE User SET LastSuccessfulPulsarSync__c = '%%LastSync%%' WHERE Id ='%%CurrentUserId%%'; } Update_User_6.0{ Action=SFUpdate; ObjectType=User; Id=%%CurrentUserId%%; LastSuccessfulPulsarSync__c=%%LastSync%%; } NoAction{ } |