Automate

 View Only
  • 1.  Log in Queries when no records found

    Posted 04-16-2024 05:59

    Hello. 

    I have a Winshuttle Query with a JOIN that extracts records from different tables. When records are found the LOG is filled in the cell stated in mapping. However, when no records are found, the Log cell is not filled at all. Is there any way to get a log even with zero records? Maybe a setting somewhere in the Studio?

    I need this as there is a Macro that calls the Query and waits for the cell to be filled.

    Thanks,

    Fernando



    ------------------------------
    Fernando Martin
    Asian Infrastructure Investment Bank
    ------------------------------


  • 2.  RE: Log in Queries when no records found

    Employee
    Posted 04-18-2024 10:26

    I tested this quickly and you are right! 

    The log setting had everything turned on. This is the only spot I know that could influence how the log is written. 

    For some reason, it sounds like this does not apply to query scripts returning zero rows. 

    @Charles Howard Would you say this is a bug or improvement request?



    ------------------------------
    Jayasri Varyani
    SE
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: Log in Queries when no records found

    Employee
    Posted 6 days ago

    @Fernando Martin

    Update on this issue (5/13): 

    Engineering confirmed that this behavior has always been this way (Log is not written if query has no results). 

    We have raised an improvement request and will be picked up by Product Management for prioritization into a future release. 

    Thank you for reporting. 



    ------------------------------
    Jayasri Varyani
    SE
    Precisely Software Inc.
    ------------------------------