Item Field Value not available in Transaction Saved Search

This is the scenario were the value of item field is sourced from a saved search. Any Field whose value is sourced from saved search cannot enable store value. Without store value checked you cannot avail the value in the Saved Search.

Solution:

Create a new field in the item record and transfer the value which is not available in saved search with a worflow to this newly created field.

Steps

  1. Create a new field in the item record.
  2. Create item saved search(choose type accordingly)
  3. Create worflow:
    1. Record Type: Item
    2. Subtype : Accordingly
    3. Relesed Status: Released
    4. Click execute as Admin
    5. Keep Instance and History: Always
    6. Click: Enable Logging
    7. In initiation click: Scheduled
    8. In saved search filter: Add Item serach you created(2 main step)
    9. Provide Execution date and execution time
    10. Click state 1 and SET FIELD VALUE:
      1. Actions:
        1. Type: set field Value
        2. Trigger On: Scheduled
        3. Field(To field: select the field were you want to transfer the value)
        4. From Field; Select the filed from were you want to transfer the value and record : current record
        5. save it
      2. Once scheduling is done and worflow is triggerd we get the historical datas in the saved search.
    11. Select the worflow edit it as follows:
      1. Initiation: Event based.
      2. Events: Oncreate,On view or update.
      3. Trigger Type: After record submit.

Thus the when we run the saved search we get the value of the Field in saved search once we apply the value of newly created custom filed in the result of Saves Search.

Leave a comment

Your email address will not be published. Required fields are marked *