Forum Discussion

Kostja's avatar
8 years ago

Copy field from one menu to another / Custom fields

Hi everybody,


is it possible to copy a field within a menu to another one or maybe to create a custom field with the same values?


For example: i would like to have the field 'Run Time' from 'Test Library->Test Case #1 -> Run History' in 'Test Library' to see the last run time at first sight.


(Tried to visualize it with the attached file...)

2 Replies

  • Nastya_Khovrina's avatar
    SmartBear Alumni (Retired)

    Hi Kostja,


    You can create a custom field of the following types:
    - Choice List (Based on SQL) – On-Premises feature. You can enter a SQL statement that will return a list of items based on your query. These display in a choice list drop down. (Note: This type of field is not compatible with Fast Edit or Import.) See details: Create Custom Fields based on SQL Queries.


    - Choice List (Based on Another Field) – This allows you to create a custom field that derives the items in the combo box from another feature area. Please see my sample video about adding a release title field to test sets:


    But, note that you cannot add the Run Time field to a Test library screen. The Run Time value is associated with a Test Run, not a Test (one test can has several test runs). For a Test you can add the Avg Run Time field, which show average run time value for a particular test:



    Customer Care Team

    • Kostja's avatar

      Hey Anastasia,


      unfortunately your suggestions were not the solution i was searching for, so now i retrieve the 'Last Run Time' with a more complicated SQL query within the test (just wanted to make it easy to get the value of the last run ).


      Now it looks like this:

      var func = arguments.callee.toString().match(/function ([^\(]+)/)[1];
      var Cmd = ADO.CreateADOCommand();
      Cmd.ConnectionString = "Driver={SQL Server};Server=Server\\SQLEXPRESS;Database=SoftwarePlanner;Uid=uid;Pwd=pwd;";
      Cmd.CommandText = "select TestRunItemRunTimeFormated from dbo.View_TestRunsAdHoc where TestRunItemDateFinished = (select max(TestRunItemDateFinished) from dbo.View_TestRunsAdHoc where TestRunItemTestName = (select Title from dbo.View_TestAutomations where EntryPoint like '%"+ func +"'))";
      var RecSet = Cmd.Execute();
      var rsRT = RecSet.Fields.Item(0).Value;


      Although thank you for reply, still helpful for other purposes.