ServiceInterface:FetchData (FetchDataRequest) Cancel The title field is required!

1. Roger Blanchard

   

   413 posts
   Registered:
   29 Jun 2018
   12 Jun 2019

   Link to this post

   It appears that the table names passed in the NEW FetchDataRequest have to be in the order of how they are defined in the PDS. If not we only get data for the first table. Is this by design?
   
   DO ON ERROR UNDO, THROW:
      
   oRequest = NEW FetchDataRequest ("eCardTypeTotal,eDeptTotal,eGeneralTotal,eMediaTotal,eModifierTotal,eNonSaleTotal,eProductivityTotal,eTaxTotal,eSpecialFunctTotal",
                                       cCardTypeWherestring + CHR (1) +
                                       cDeptWherestring + CHR(1) +
                                       cGeneralWherestring + CHR(1) +
                                       cMediaWherestring + CHR(1) +
                                       cModifierWherestring + CHR(1) +
                                       cNonSaleWherestring + CHR(1) +
                                       cProductivityWherestring + CHR(1) +
                                       cTaxWhereString + CHR(1) +
                                       cSpecialFunctWherestring,
                                      
                                       0) .
      
       
                        
                   ServiceInterface:FetchData ("Osprey.Pos.FinancialTotals.FinancialTotalsBusinessEntity",
                                               oRequest,
                                               OUTPUT DATASET dsFinancialTotals). 
       
                    
       
         
      
      
      FINALLY:
       DELETE OBJECT oRequest NO-ERROR.  
      END FINALLY.
      
     END.
      
     
     CATCH e AS Progress.Lang.Error:
      ErrorHelper:ShowErrorMessage(e).
     END CATCH.
     
     FINALLY:
      
      DELETE OBJECT oRequest NO-ERROR.
        
     
     END FINALLY.
   
2. Mike Fechner

   

   342 posts
   Registered:
   14 Sep 2016
   Answered

   25 Jun 2019 in reply to Roger Blanchard

   Link to this post

   Hi Roger,
   
   I'd expect that the first entry needs to be the topmost table. All other entries should be in any order.