AnsweredAssumed Answered

Need help with FMPXMLRESULT

Question asked by SubSkip on Aug 18, 2015
Latest reply on Aug 18, 2015 by 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 ]

Outcomes