Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Query - how to extract all possible selections from field and not specifying it in user input data either in Run-time variable wizard

    Posted 10-31-2025 14:08

    Hello,

    I am trying to give query user possibility to not enter any data in one of the columns (eg. 'plant' value) and to extract all created PIRs in different plants. (so eg. user will specify only material number and get all created PIRs, but if user wants - she/her can enter information about specific plant in line/s)
    "*" value doesn't work for taking all possible values in plant field.
    Is there any possibility to manage this?

    Thank you,
    Daria



    ------------------------------
    Daria Maj
    Precisely U Shared Account
    ------------------------------


  • 2.  RE: Query - how to extract all possible selections from field and not specifying it in user input data either in Run-time variable wizard

    Posted 11-03-2025 02:10

    hi, I would change the operator from "=" to "Like", in that case you can use "*" to my knowledge.



    ------------------------------
    Ed Meiners
    Lead Consultant MDIM
    Wessanen Nederland Holding BV
    Amsterdam
    ------------------------------



  • 3.  RE: Query - how to extract all possible selections from field and not specifying it in user input data either in Run-time variable wizard

    Posted 11-03-2025 02:25
      |   view attached

    Hi, I use the "In" operator.

    User can specify multiple or leave blank for all.



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