Automate

 View Only

  • 1.  Log in Queries when no records found

    Posted 13 days ago

    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 11 days ago

    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.
    ------------------------------

    Original Message