Page Comparison

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{
}