Automate

 View Only
Back to discussions
Expand all | Collapse all

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

  • 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 21 days ago

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

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

    Original Message


  • 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 18 days ago
      |   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
    ------------------------------

    Original Message