Automate

 View Only
  • 1.  Query build from tables - join issue

    Posted 20 days ago

    Hi - I don't seem to have the ability to change a join to an outer left join. Functionality always greyed out.

    I am a Query Data Dictionary Administrator

    image


    ------------------------------
    Renette Nienaber
    Mrd
    VIVO ENERGY SOUTH AFRICA (PTY) LTD
    ------------------------------


  • 2.  RE: Query build from tables - join issue

    Posted 20 days ago

    found it :-)

    image


    ------------------------------
    Renette Nienaber
    Mrd
    VIVO ENERGY SOUTH AFRICA (PTY) LTD
    ------------------------------



  • 3.  RE: Query build from tables - join issue

    Employee
    Posted 19 days ago

    Thanks for sharing, Renette. You got to it before I could. :)

    The defaults are pretty limited, as you can see. You can change the settings up to 25 tables and then check or uncheck options, as you have found.

    The documentation for that setting and other preferences is here: https://help.precisely.com/r/t/1016755376/2025-10-28/Automate-Evolve/pub/Latest/en-US/Automate-Evolve-User-Guide/Preferences?tocId=FRLj4oyKG7O1UgJtAMqOvw

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    *Precisely Software Inc.
    ------------------------------