Topic
6 replies Latest Post - ‏2014-03-27T10:30:36Z by MyDeveloerWorks
montapas
montapas
5 Posts
ACCEPTED ANSWER

Pinned topic How to search Changed Objects within in a Item Interval

‏2014-03-25T06:44:53Z |

Dear All,

I am working on DOORS integration. I want to get the objects for a project which are modified for a certial time period.

Please help me.

  • MyDeveloerWorks
    MyDeveloerWorks
    41 Posts
    ACCEPTED ANSWER

    Re: How to search Changed Objects within in a Item Interval

    ‏2014-03-25T07:44:59Z  in response to montapas

    Hello,

     

    What type of tool do you want to integrate with ? If its a SCM/VC tool then which one?

    There is another forum on DOORS integrations, I suggest you look there if there are any previous solutions regarding the tool you want to integrate with.

    https://www.ibm.com/developerworks/community/forums/html/forum?id=11111111-0000-0000-0000-000000001504

    BTW, I have a related topic open on which attributes were modified over a certain time period, specifically "Test Run Attributes", but this deals with an internal feature of DOORS. If you watch how that topic develops (opened yesterday),  you might get some hints

    HTH

    Colm

  • llandale
    llandale
    2943 Posts
    ACCEPTED ANSWER

    Re: How to search Changed Objects within in a Item Interval

    ‏2014-03-26T21:01:17Z  in response to montapas

    Don't know about "integration", but you can query the "Last Modified On" attribute of Objects to find out when they changed at all.  You could also query History of Objects looking for modifications to a certain list of attributes, such as "Object Heading" and "Review Notes".  Once you got the relevant modification date of an object you can check to see if it is within which ever Window you care about; within last 7 days, in Februrary, or whatever.

    -Louie

    • MyDeveloerWorks
      MyDeveloerWorks
      41 Posts
      ACCEPTED ANSWER

      Re: How to search Changed Objects within in a Item Interval

      ‏2014-03-27T09:18:38Z  in response to llandale

      Hello Louie,

      This follow up is probably related more to my question "Harvesting out Test Run Attributes", so apologies if this deviates from orginal question too much. The "Last Modified On" is an attribute I had not considered  when I wanted to run a query of all Test Runs that occurred between a particular set of dates.  Here is the code I put together. I have some Test Runs that were modified on 7 Feb 2014. But if I put the interval date on 6 Feb, the TR on 7th Feb is not found. I also found it doesnt run for certain dates entered. 

      void print(History h,Date d1, Date d2) 
      {
          
          clear();
          HistoryType ht = h.type 
          print h.author "\t" h.date "\t" ht "\t" 
          if ( ht == modifyObject) 
          {
                      Date d= h.date
                      /// Check d is earlier than d1 and later than d2
                      if((d<d1)&&(d>=d2))
                      { 
              
                              string s= h.attrName
                              if (matches("Test Status",s) )
                              {
                              
                                      string stringForm = stringOf(d, userLocale) 
                                      print "Test Run Data" "\t"
                                      print h.absNo "\t" 
                                      print stringForm "\t" 
                                      print h.author "\t" 
                                      print "\n"
                              }
                      }
       
              }
          //print "\n"
      } 
      History h_global
      
      Date date1 = today
      int iDate1= intOf(today)
      Date date2 =  dateOf(iDate1-(24*60*60*31))
      int iDate2= intOf(date2)
      
      DB TestCaseHistoryDB = create("TestCaseHistory ", styleCentered)
      
      DBE cNameDBE = field(TestCaseHistoryDB, "Test Author", "John Doe", 20, false)
      DBE dateLblDBE1 = label(TestCaseHistoryDB, "End Test Interval")
      DBE oDateDBE1 = date(TestCaseHistoryDB, 30,null, true)
      DBE dateLblDBE2 = label(TestCaseHistoryDB, "Begin Test Interval:")
      DBE oDateDBE2 = date(TestCaseHistoryDB, 30,null, true)
      
      
      void makeTestCaseHistory(DB winDB) {
          string cName = get(cNameDBE)
          Date oDate = get(oDateDBE1)
          Date oDate2 = get(oDateDBE2)
      
          for h_global in current Module do print(h_global,oDate,oDate2) 
      
      
      }
      apply(TestCaseHistoryDB, "Go", makeTestCaseHistory)
      realize(TestCaseHistoryDB)
      show(TestCaseHistoryDB)