Getting Export Path from PDF

AK

October 17, 2024 18:00

After we create a PDF through the print definition, I'd like to get the export path. 

 

I've tried making an Optimizer rule with the Event Type as Designer Queue. However I'm not able to retrieve the Export Path.

1

• 

  Lothar Hasenkämper

  October 21, 2024 06:37

  Hi,

  you can get it in the PrintDef

    SELECT 
  	[T0].[U_ExpPath]
    FROM 
  	[dbo].[@SWA_LD_PRNDEF] [T0]
    WHERE 
  	[T0].[Code] = 'XXXX'

  regards Lothar

   

  0
• 

  AK

  October 21, 2024 21:20

  How would we get the file name of the PDF that was just create in that folder or the tempfolder\swald\dbname\export folder? 

  0
• 

  Lothar Hasenkämper

  October 22, 2024 05:00

  Hi it depends on the Name-Settings in the Print-Def. You have to rebuild this (by query e.g.)

  It can be found here

  SELECT 
  	[T0].[U_EFileName] 
  FROM 
  	[dbo].[@SWA_LD_PRNDEFORD] T0
  WHERE 
  	[T0].[Code] = 'XXXX'

  Exportpath

  

  Name

  

  regards Lothar

  0

Please sign in to leave a comment.