Skip to main content
Solved

FSM 6u15 scheduled process date variable


Forum|alt.badge.img+7

I am looking to create a scheduled task that would use the current date +90 days as an input paramater. do you have any suggestions on how i might accomplish this?

 

Specifically on the scheduled end date

<schedule_end_date>today + 90 days</schedule_end_date>
<perform_contract_pm_request_generation>
    <parameters>
      <posting_group>AMERICAS</posting_group>
      <contract_id>
      </contract_id>
      <contract_version>
      </contract_version>
      <contract_type>
      </contract_type>
      <place_id>
      </place_id>
      <model_id>
      </model_id>
      <request_template_id>REQ-TEMPLATE</request_template_id>
      <task_template_id>task Template</task_template_id>
      <schedule_end_date>today + 90 days</schedule_end_date>
      <purchase_order_id>
      </purchase_order_id>
      <consolidate_request>N</consolidate_request>
      <break_on_model_id>N</break_on_model_id>
      <break_on_contract>N</break_on_contract>
      <break_on_contract_type>N</break_on_contract_type>
      <break_on_planned_date>N</break_on_planned_date>
      <bundle_pms>N</bundle_pms>
      <variance_days>
      </variance_days>
      <consolidate_task>N</consolidate_task>
      <autocreate_task>Y</autocreate_task>
    </parameters>
  </perform_contract_pm_request_generation>

 

Best answer by SanjeewaJ

Hi @graeme86 

Please try something like below. Note that, your system should have a task template called “task Template”. Or change the highlighted value to a task template id that exists.

 

<perform_batch>
  <sequential_dependent>
    <perform_evaluate_expression>
      <parameters>
        <table_name>task_template</table_name>
        <keys>
          <key_item>
            <column_name>task_template_id</column_name>
            <column_value>task Template</column_value>
          </key_item>
        </keys>
        <expression>Today()+Days(90)</expression>
      </parameters>
    </perform_evaluate_expression>

    <perform_contract_pm_request_generation>
      <parameters>
        <posting_group>AMERICAS</posting_group>
        <contract_id>
        </contract_id>
        <contract_version>
        </contract_version>
        <contract_type>
        </contract_type>
        <place_id>
        </place_id>
        <model_id>
        </model_id>
        <request_template_id>REQ-TEMPLATE</request_template_id>
        <task_template_id>task Template</task_template_id>
        <schedule_end_date xpath_node="//perform_evaluate_expression_result/response"/>
        <purchase_order_id>
        </purchase_order_id>
        <consolidate_request>N</consolidate_request>
        <break_on_model_id>N</break_on_model_id>
        <break_on_contract>N</break_on_contract>
        <break_on_contract_type>N</break_on_contract_type>
        <break_on_planned_date>N</break_on_planned_date>
        <bundle_pms>N</bundle_pms>
        <variance_days>
        </variance_days>
        <consolidate_task>N</consolidate_task>
        <autocreate_task>Y</autocreate_task>
      </parameters>
    </perform_contract_pm_request_generation>
  </sequential_dependent>
</perform_batch>

 

/Sanjeewa

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

2 replies

SanjeewaJ
Superhero (Employee)
Forum|alt.badge.img+12
  • Superhero (Employee)
  • 89 replies
  • Answer
  • March 18, 2022

Hi @graeme86 

Please try something like below. Note that, your system should have a task template called “task Template”. Or change the highlighted value to a task template id that exists.

 

<perform_batch>
  <sequential_dependent>
    <perform_evaluate_expression>
      <parameters>
        <table_name>task_template</table_name>
        <keys>
          <key_item>
            <column_name>task_template_id</column_name>
            <column_value>task Template</column_value>
          </key_item>
        </keys>
        <expression>Today()+Days(90)</expression>
      </parameters>
    </perform_evaluate_expression>

    <perform_contract_pm_request_generation>
      <parameters>
        <posting_group>AMERICAS</posting_group>
        <contract_id>
        </contract_id>
        <contract_version>
        </contract_version>
        <contract_type>
        </contract_type>
        <place_id>
        </place_id>
        <model_id>
        </model_id>
        <request_template_id>REQ-TEMPLATE</request_template_id>
        <task_template_id>task Template</task_template_id>
        <schedule_end_date xpath_node="//perform_evaluate_expression_result/response"/>
        <purchase_order_id>
        </purchase_order_id>
        <consolidate_request>N</consolidate_request>
        <break_on_model_id>N</break_on_model_id>
        <break_on_contract>N</break_on_contract>
        <break_on_contract_type>N</break_on_contract_type>
        <break_on_planned_date>N</break_on_planned_date>
        <bundle_pms>N</bundle_pms>
        <variance_days>
        </variance_days>
        <consolidate_task>N</consolidate_task>
        <autocreate_task>Y</autocreate_task>
      </parameters>
    </perform_contract_pm_request_generation>
  </sequential_dependent>
</perform_batch>

 

/Sanjeewa


Forum|alt.badge.img+7
  • Author
  • Do Gooder (Customer)
  • 17 replies
  • March 18, 2022

Thank you very Much for the solution @SanjeewaJ 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings