Hi, @Mischa Spelt @steven.hamoen
I want to use event-triggered source to pull items in list: distribution center that have ProductAge more or equal to 5
Any idea how to set the label assignment?
@Anggoro P I'm not sure but have you made the process flow tutorials? Please do that first.
To pull from a list you use the pull from list activity. I'm not sure what you want with a event triggered source listening to a list.
Yes, I have done that. I want to delete items that have age more than 5 days. Because the product has limited lifetime, after certain days, I want to collect how many products that should be scrapped or disposed due to expiration
If I use pull from list, seems like I need to create tokens first. I have tried using pull from list but nothing happened
@Anggoro P
yes all activities needs tokens to pass through. If you want to destroy a product when it is not collected within a certain amount of time, create a second token with the same properties (Create tokens activity) send that token through a delay with the max stay time and then try to pull it. Use the max wait timer to let it continue if it can't pull anything anymore because the product was actually collected in time.
the pull from list activity pulls the value of the list, it is typically the item you pushed onto the list. If you want to get the data of the fields in a query, you store the result of the query into a table. There is the method directly by a Table.query (you finds this in my answer) or the List.PullResult variant maybe holding an array of the pull query of all matching items.
If you want to store more data of the list matching a query, you use a custom code and aTable.query on the list, before you pull anything. Then you "cloneTo" the result to a global table or table at a label node or you clone the result table into an array at a token label.
Table result = Table.query("FROM Listname WHERE age > 0.3");
Array data = result.clone();
return data; // return in an assign label activity
Or a global table "ResultNew" or a table at a label node
Table result = Table.query("FROM Listname WHERE age > 0.3");
result.cloneTo(Table("ResultNew"));
If you want to see the structure of the array of the token.label, you can print the token.label into the output console. The structure consists of an array of the rows of the table and each row consists of an array of the columns of the table.
Sorry I am new here so I didn't get the idea. Let me explain it more detail.
I have a production plant, a DC, and customers. A pull from DC activity has already used for matching customer demands and items available in DC (using required age condition)
On another hand, I want to make sure that items available in DC have age not more than, let say 5 days. Thus, I have made another pull from list activity, referring to scrapping items that have expired.
On the list I have made a new field called ProductAge, which is the sum of SourceAge (the aging due to production) and ShelfAge (aging in DC, dynamic)
Because every pull activity needs a token, I have created tokens using event triggered (not sure about this) the idea is to create token every time there is an item that has ProductAge >= 5 and the pull query is also the same. I doubt about this because I don't know how to use ProductAge on query
If you want to pull more items, you build a loop and use the Max.Wait Timer. OnWaitTimerFired you release the token through another activity connection port.
pull-more-items-matching-list-attribut.fsm
8 People are following this question.
