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.  Winshuttle Composer Form - Filtering table display

    Posted 08-13-2020 12:46
    In Winshuttle Composer 12, I have a repeating table that I would like filtered to only display when field1=true.   This was easily accomplished in Infopath with Winshuttle 10.6 with the Repeating Table Properties -> Display ->Filter data (field1 = true).    In Winshuttle 12 I cannot find a similar function.  The filter repeating content action rule wants the results to go to a drop down field.   I just want the table of data to only display where field1=true and not show any of the rows where field1=false.   Any simple functions to do this?

    ------------------------------
    Robert Zsedely | Business Architect
    Seneca Foods Corporation | Marion, NY |
    ------------------------------


  • 2.  RE: Winshuttle Composer Form - Filtering table display

    Posted 08-14-2020 09:35
    Hi Robert,
    We are on 12.1 and the way I managed to filter a list in composer is by using a check box which is triggered by a rule, then I have a button that does the filtering. In the attached image, the button doesn't align with the table shown, but it works the same. A user checks the "Remove" box, which then the rule un-checks the "Run" box. Then the user clicks the "Remove Plants" button which triggers the rule to filter the table to show only rows with unchecked "Remove" boxes. Hopefully that makes sense. This does 2 things for me, removes the plants from the view as well as makes sure they won't be run by the web service and therefore not created in SAP. 
    The reason I set it up this way, instead of deleting the row, is due to the delete rows function not seeming to work. 12.1 Table Filter Example


    ------------------------------
    Vanessa Kutasi | Application Analyst II
    IDEXX | New England WUG Leader
    ------------------------------



  • 3.  RE: Winshuttle Composer Form - Filtering table display

    Posted 08-14-2020 10:43
    Thanks.   This works - but now my screen repaints and positions the cursor to the top of the form (instead of the bottom where the button and table are).  Is there a command to return cursor to the bottom of the page?

    ------------------------------
    Robert Zsedely | Business Architect
    Seneca Foods Corporation | Marion, NY |
    ------------------------------

    Original Message


  • 4.  RE: Winshuttle Composer Form - Filtering table display

    Employee
    Posted 08-14-2020 10:04
    Hi Robert

    If I understand you correctly, the issue with the FILTER DROP DOWN  rule is the Filter itself.
    You want to filter by a literal value instead of a field, like the above, correct?

    If so, you can either assign the value to a field (default value) and use that, or try to type the value in that field 'false'

    I've had mixed results doing this in Foundation, but it seems to work well in Evolve.  

    If I missed the meaning of your question, please provide a bit more info.

    Best Regards,
    Sigrid


    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------



  • 5.  RE: Winshuttle Composer Form - Filtering table display

    Posted 08-17-2020 11:55
    Hi Robert,

    I think I understand what you are saying. Perhaps these screenshots will help. Note that you can type into the drop down field and then select what you typed to act as the filter value. Note that I first put double quotes around it, which works for when filtering based on text but does not seem to for true/false. When you want to filter on something that is true/false, the only way I have been able to get it to work is to have a checkbox outside of the table that I set to true then have the filter on the repeating content filter where column in table = the checkbox.

    Let me know if this information helps!

    Here's how to provide a custom filter option by typing in what you want to filter on then selecting it.


    Here is my rule when filtering on a checkbox value, where field_5 is checkbox value outside of the table that is set to true and field_1 is a checkbox field in the repeating table:


    here is an example form before and after filtering where there is rule on the form to filter based on the checkbox which is true

    Before filtering

    After selecting the button




    ------------------------------
    Lance Yoder | Partner
    Clear Process Solutions | 2162330685
    ------------------------------