Our vBulletin migration is complete.
Welcome vBulletin users! All content and user information from the Micro Focus Forums (vBulletin) site has been migrated to this site. READ MORE.
Govardhan07 Super Contributor.
Super Contributor.
321 views

Request Completion date

Jump to solution

Hi,

 

I need to retrieve data related to requests but condition is its completion or cancelled date is between January 1st 2011 to December 31st 2011.

 

My question is where to find exact completion or cancelled date of the request and which table contains this date.

 

Please help me.

 

Regards,

Govardhan

0 Likes
1 Solution

Accepted Solutions
Highlighted
Absent Member.. Niraj Prabhu Absent Member..
Absent Member..

Re: Request Completion date

Jump to solution
Govardhan,

KCRT_REQUESTS_V should give you all the information you need, you are looking for LAST_UPDATE_DATE, and make sure that you use the STATUS_CODE to sight the status of the request you want to search.

You can use the between on the LAST_UPDATE_DATE column within where clause to restrict the search.

Regards,
Niraj
Niraj P.
2 Replies
Highlighted
Absent Member.. Niraj Prabhu Absent Member..
Absent Member..

Re: Request Completion date

Jump to solution
Govardhan,

KCRT_REQUESTS_V should give you all the information you need, you are looking for LAST_UPDATE_DATE, and make sure that you use the STATUS_CODE to sight the status of the request you want to search.

You can use the between on the LAST_UPDATE_DATE column within where clause to restrict the search.

Regards,
Niraj
Niraj P.
Absent Member.. Raj Ghimire Absent Member..
Absent Member..

Re: Request Completion date

Jump to solution

Unless you have custom fields to capture info like Completion date, you can query the LAST_UPDATE_DATE column in KCRT_REQUESTS to get the desired output.

Thanks.

-Raj

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.