SQL Keyword - Print & Delivery Completada
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
Comentarios
3 comentarios
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.
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
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.