Hi Md Sahabaj Ansari, The execution information perspective[1] and corresponding metadata types allow you to keep all of the executions in a project. This post provides some more details on how to configure it all (thanks for the reminder to make sure the contents of that post end up in the docs).
[1] https://hop.apache.org//manual/latest/hop-gui/perspective-execution-information.html [2] https://www.leanwithdata.com/blog/apache-hop-execution-information-logging Regards, Bart On Tue, Apr 18, 2023 at 9:52 AM Md Sahabaj Ansari <[email protected]> wrote: > Thanks Hans !! > > > it works . could you also let me know to capture the logging info in txt > file . when I run a pipeline it save the logging in hopgui.log under audit > folder and when I close it also erased . I want to save the logging for > every pipeline in separate txt file . > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows > > > > *From: *Hans Van Akelyen <[email protected]> > *Sent: *18 April 2023 01:02 PM > *To: *Md Sahabaj Ansari <[email protected]>; [email protected] > *Subject: *[EXTERNAL] Re: How to replace Parameter with ? question mark > > > > Hi, > > > > The Execute SQL script is a row processing transform, it requires input > rows to work. > > The values used to replace the ? Need to come from a field in the stream. > > > > The simplest way to make your example work is to add a Data Grid transform > [1] to the canvas, in the Meta tab create a field named “colour” (type > string). > > In the Data tab you can then add the value “Green”. > > > > Then you can use this “colour” field in the Execute SQL Script transform > (where you now have written Green). > > > > Hope this helps, > > > > Hans > > > > > > > > [1] > https://hop.apache.org//manual/latest/pipeline/transforms/datagrid.html > <https://hop.apache.org/manual/latest/pipeline/transforms/datagrid.html> > > > > On 18 April 2023 at 08:20:41, Md Sahabaj Ansari ([email protected]) > wrote: > > Hi, > > Greetings of the day !! > > > > My question is how I replace question mark (?) value with arguments in > Execute Sql scrpt. My value is Green here. > > > > Thanks, > > Md Sahabaj Ansari > > > > > > Sent from Mail <https://go.microsoft.com/fwlink/?LinkId=550986> for > Windows > > > > >
