The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday noon (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

removing closed - cancelled request on suggested items list on time sheet suggestions

SOLVED
Go to solution
Highlighted
riznad
Regular Collector

removing closed - cancelled request on suggested items list on time sheet suggestions

Hello All;

We have a configuration as follow:

There is one request type. Request manager can add resources to the request. This resources can add the request to their timesheet.

 

Here the request screen:

 

The resources listed on resources list (Faruk Çevik and Cemal Bahadır) Can see the request on their timesheet

Add items > add from my items / suggested items

 

Suggested items tab:

 

When the request is cancelled or closed, the request is still on the suggested items list.

What should I configure to remove those items when request is closed or cancelled.

Thanks in advance

 

2 REPLIES
riznad
Regular Collector

methinRe: removing closed - cancelled request on suggested items list on time sheet suggestions

riznad
Regular Collector
Solution

Re: methinRe: removing closed - cancelled request on suggested items list on time sheet suggestions

I solved problem. Thansk to Canturk Topraklı.

 

Here the folder contains related folders.

C:\PPM\conf\quicklist

 

the file QuickListMaster.xml

contains the referance to queries.

 

What I did was, create a new folder named custom_derivations

 

I modify

 

request_resources_assignees_derivation.xml file and saved as the modified file under

C:\PPM\conf\quicklist\custom_derivations (I added a new line to sql, status=inprogress)

 

 

Than I modify QuickListMaster.xml file to map new file (do not forget to backup old file) C:\PPM\conf\quicklist\custom_derivations\request_resources_assignees_derivation.xml

I am copying files under the post.

 

I stoped the service than run sh kupdatehtml.sh

Than I restarted the service.

 

<quicklist>
    <derivation>
        <name>tasks_assigned_to_me</name>
        <enabled>Y</enabled>
        <file>core_derivations/tasks_assigned_derivation.xml</file>
    </derivation>
    <derivation>
        <name>work_items_on_last_timesheet</name>
        <enabled>Y</enabled>
        <file>core_derivations/workitems_on_last_timesheet.xml</file>
    </derivation>   
    <derivation>
        <name>requests_available_to_you</name>
        <enabled>N</enabled>
        <file>core_derivations/request_resources_assignees_derivation.xml</file>
    </derivation> 
    <derivation>
        <name>requests_available_to_you</name>
        <enabled>Y</enabled>
        <file>custom_derivations/request_resources_assignees_derivation.xml</file>
    </derivation>  
</quicklist>

 

 

 

 

<derivation>

<name>requests_available_to_you</name>

<description>requestsAvailableToYou</description>

<reason>requestYouAreAssignedToOrInResList</reason>

<resource-bundle>Derivations</resource-bundle>

<context>TIME_WORK_ITEM</context>

<sql>

<![CDATA[

SELECT

TO_CHAR(r1.request_id) work_item_id,

TO_CHAR(r1.request_id) work_item_name,

TO_CHAR(r1.request_type_id) work_item_set_id,

krt.request_type_name work_item_set_name,

r1.description description,

'REQUEST' work_item_type

FROM

kcrt_requests r1,

kcrt_request_types krt

WHERE

r1.request_type_id = krt.request_type_id

AND r1.status_code='IN_PROGRESS'

AND

EXISTS(

SELECT 'Y'

FROM ppm_resource_settings prs, kcrt_requests kr

WHERE prs.entity_id = 19

AND kr.request_id = r1.request_id

AND prs.entity_primary_key = kr.request_type_id

AND prs.use_tm = 'Y')

AND

(EXISTS

(SELECT 'Y'

FROM kcrt_requests r, ppm_resource_settings rs

WHERE rs.entity_id = 19

AND r.request_id = r1.request_id

AND r.assigned_to_user_id = [TMG.RESOURCE_ID]

AND rs.entity_primary_key = r.request_type_id

AND rs.tm_setting_assgn_to = 'Y')

OR

EXISTS

(SELECT 'Y'

FROM kcrt_requests r, ppm_resource_settings rs, kcrt_transactions t

WHERE rs.entity_id = 19

AND r.request_id = r1.request_id

AND rs.entity_primary_key = r.request_type_id

AND rs.tm_setting_assgn_to = 'Y'

AND t.column_name like 'ASSIGNED_TO_USER_ID'

AND t.request_id = r.request_id

AND t.last_update_date between [TMG.START_DATE] AND [TMG.END_DATE]

AND (t.old_column_value = [TMG.RESOURCE_ID] or t.new_column_value = [TMG.RESOURCE_ID]))

OR

EXISTS

(SELECT 'Y'

FROM kcrt_requests r, ppm_resource_settings rs, kcrt_rt_request_resources rr

WHERE rs.entity_id = 19

AND r.request_id = r1.request_id

AND rs.entity_primary_key = r.request_type_id

AND rs.tm_setting_all_res_on_req = 'Y'

AND rr.request_id = r1.request_id

AND rr.resource_id = [TMG.RESOURCE_ID])

)

]]>

</sql>

</derivation>

 

//Add this to "OnDomLoad" event