3 Replies Latest reply: Nov 19, 2013 2:27 PM by stijn wuyts RSS

    select in field

      Hi everyone,

       

      I want to make a button that returns a result set where a field doens't contain a certain string.

       

      i already made a button with an action select in field to select all rows where column A contain string B. I can't seem to find how to use this action to return all the rows where column A doens't contain string B...

       

      any help plz

      thanks,

        • Re: select in field
          Stefan Wühl

          One simple solution would be to create two actions, first a Selection - Select in field to filter the column A values that contain string B, then a second action with Selection - Select Excluded.

           

          Another approach is to use a single action Selection - Select in field with a little more complex search string, something like

          ='<>B'

           

          To help you in more detail, it would be best if you post your current search string for the 'contains' filter.

            • Re: select in field

              Hi swuehl,

               

              thanks for the quick reply. I will test the second approach tomorrow.

               

              The first one won't work in my case as i need in fact three buttons. One that shows all sales with credit check  (where certain field <> 'no credit check'). One that shows all sales without credit check and one that shows all (credit check + no credit check check). The action with select excluded woudn't work when they press the button with show all . but i guess second approach will work thanks!

              • Re: select in field
                Steve Dark

                I would suggest that the approach of selecting in field and then reversing the selection in the next step is a good move.  Sometimes it is required to clear the selection on one or more fields before doing that kind of thing.  These would simply be done as clear steps on the same click - just use the Promote and Demote buttons to get the actions in the right order.

                 

                Steve