1 Reply Latest reply: Jul 15, 2010 11:17 AM by csimpson@kumc.edu RSS

    How to set query criteria from a test field

    tonyhh Apprentice

      Hi All


      Is it possible to use the results from a text field (multi line), to be used as the criteria to return a query result?


      Basically, I have a query tab at the bottom of the change management window that shows all the services we provide (will be in excess of 40). I want to filter this query on the tab to only show the services that will be affected by the change request (the resulting query must show the service manager, e-mail, 3rd part support details......).   Is this possible? I have tried adding a "List" box and then copying the data to a text field but this only allows you to view 1 field?


      See attched file for view of the window.


      Any help much appreciated be it a different approach.





        • 1. Re: How to set query criteria from a test field

          We added the services to a reference list and then added the services to CI items.  I add 1 or more CI items to my change and all of the services can be shown in a report or a query.  I guess check boxes on a form or adding services to a change also work.  Putting each service in the text area just seems very efficient and prone to mistakes, mis-spellings, or different terminology.