SQL Keyword - Print & Delivery

Completada

Oliver Syner

• 4 de abril de 2019 12:52

Hello, 

Is it possible to have a $[Keyword] that could be a SQL query? e.g. $[SQL: SELECT Top 1 FilePath From ListofFilePaths] 

We use P&D to generate and save all of our documents to a folder on a server using current Keywords to build up the string. We have had several instances where this folder has had to be moved for one reason or another and it takes a long time to change all of the report actions. I've tried to make them as dynamic as I can to reduce the number but there are still quite a few, and I always miss one :).

By using a $[SQL Keyword] at the beginning of the file path we could have that look at a UDT / UDF which can hold the file path information. This way we update the UDT / UDF and it will mean all documents now get saved to that one location. e.g. \\$[SQL Keyword]\SAP-Folders\$[DATABASENAME]\Attachments\23\$[$8.0.NUMBER]\QTE_$[$8.0.NUMBER]

This is just one possible use case for us.

Thanks 

Oliver Syner

Vote

0

• Comentario oficial

  

  Rasmus Jensen

  • 4 de abril de 2019 15:34

  Hi Oliver

  In almost all places you can write the Dynamic Syntax you can also write the SQL: syntax

  So you can already write something like this:

  SQL:SELECT '\\SAP-Folders\$[DATABASENAME]\Attachments\23\$[$8.0.NUMBER]\QTE_$[$8.0.NUMBER]'

  ... So if you can write a SQL Sentence that in as first column/row give you back your path you can do it.
• 

  Oliver Syner

  • 4 de abril de 2019 15:49

  Hi Rasmus, 

  Not that I didn't trust you :) but I've just tried it and it works perfectly, thank you I didn't know you could do that.

  It will save me so much time
  
  Thanks again.

  Oliver
• 

  Rasmus Jensen

  • 4 de abril de 2019 16:43

  Good to hear. In general, you can do this in almost all fields throughout B1UP (if you can use Dynamic syntax you can also use SQL:)

Iniciar sesión para dejar un comentario.