2 Replies Latest reply on Aug 18, 2015 8:49 AM by SubSkip

    Need help with FMPXMLRESULT

    SubSkip

      Title

      Need help with FMPXMLRESULT

      Post

      Can anyone help me identify why the output is including dates where dtClosed doesn't equal 04/16/2014? If I put these values in a find within FMP 13, the correct results show up. If I run this as a script via the Admin Console, thousands of additional records are exported.

             
      • Go to Layout [ “APPS - View” (Issues Tracking) ]
      •      
      • Enter Find Mode [ ]
      •      
      • Set Field [ Issues Tracking::Fld_DtClosed; 04/16/2014]
      •      
      • Set Field [ Issues Tracking::Fld_IssueState; "Closed" ]
      •      
      • Set Field [ Issues Tracking::Fld_Visibility; "Public" ]
      •      
      • Perform Find [ ]
      •      
      • Sort Records [ Keep records in sorted order; Specified Sort Order: Issues Tracking::Fld_DtLastMod; descending ] [ Restore; No dialog ]
      •      
      • Set Variable [ $FileName; Value:"filewin:/D:/files_for_upload_to_csse/incremental_data_day" & DayOfYear(Get ( CurrentDate )) & ".xml" ]
      •      
      • Export Records [ File Name: “$FileName”; Grammar: "FMPXMLRESULT"; Character Set: “Unicode (UTF-8)”; Field Order: Issues Tracking::Fld_Question_for_XML Issues Tracking::Fld_Answer_for_XML Issues Tracking::Fld_DtEntered Issues Tracking::Fld_ProdFamily Issues Tracking::Fld_DeviceNo Issues Tracking::Fld_TopicGen Issues Tracking::Fld_TopicMain Issues Tracking::Fld_CustName Issues Tracking::Fld_CustProjName Issues Tracking::Fld_SubmitterName Issues Tracking::Fld_SubmitterEmail Issues Tracking::Fld_IssueID Issues Tracking::Fld_SiebelRefNo Issues Tracking::Fld_IssueState Issues Tracking::Fld_DeviceClassification Issues Tracking::Fld_CompassLink ] [ No dialog ]