Skip to Content

Status of Tickets based on their Dates

Scenario:

Sometimes we may get the requirement to find the status of ticket based on their created on and closed date.This document can be applicable for any object which has some validity period and we need to find the status of it based on any date.

Lets say for eg:

Ticket Created on Closed Status
1001 20130101 20130115 CLOSED

So now if user enter any date in between those two dates then we need to get the status of the same.

The approach which we can follow to achieve the same will be sharing with you with all the steps and screenshots.

Data Sheet:

8.JPG

Data Loaded in DSO:

9.JPG

Step 1–Go to  BEx Query Designer–Drag and Drop Created on date in Characteristic Restrictions panel–Right click on Created date—Restrict–Show–Value ranges—Less than or equal to–Choose the variable 0I_DAYWT (User input variable).

1.JPG

Step 2Now drag and drop Closing Date in Characteristic Restrictions panel–Right click on Closing date–Restrict–Variable–Create new variable.Refer the screenshot for details.

2.JPG

Hit the Replacement Path tab and give the details as mentioned in below screenshot

3.JPG

Now Save this variable.

Restrict the Closing date with the newly created variable as shown in below screenshot.

4.JPG

Users also need to see the date which has been entered by them on Selection screen in Query Columns as well.So for that our approach will be explained in furhter steps.

Step 3Go to Columns panel in query designer create a new formula–Under Available Operands–Formula variable–Right click–New variable.Refer the Screenshot for reference.

5.JPG

Hit the Replacement Path tab and give the details as mentioned in below screenshot

6.JPG

Hit the Currency/Unit tab and give the details as mentioned in below screenshot.

7.JPG

Save this Variable and use it in your formula.

Query Format

11.JPG


Variable Screen:

12.JPG

Query Output:

14.JPG

So you can see based on the input date we got the status of tickets and also we got the date entered by user on selection screen in User Input column.

Hope this will be helpful.

63 Comments
You must be Logged on to comment or reply to a post.