Label Assignment: Pulling item from list with a specified condition

Question

question

Anggoro P asked Nov 16 2017 at 2:30 PM tannerp commented Jul 05 2018 at 5:13 PM

Label Assignment: Pulling item from list with a specified condition

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?

Software Version:

Choose One

event-triggered source

c.jpg (37.3 KiB)

______

Cookie preferences

Your privacy is important to us and so is an optimal experience. To help us customize information and build applications, we collect data about your use of this site.

May we collect and use your data?

Learn more about the Third Party Services we use and our Privacy Statement.

Strictly necessary – required for our site to work and to provide services to you

These cookies allow us to record your preferences or login information, respond to your requests or fulfill items in your shopping cart.

YES

Improve your experience – allows us to show you what is relevant to you

These cookies enable us to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we use to deliver information and experiences tailored to you. If you do not allow these cookies, some or all of these services may not be available for you.

YES

NO

Customize your advertising – permits us to offer targeted advertising to you

These cookies collect data about you based on your activities and interests in order to show you relevant ads and to track effectiveness. By collecting this data, the ads you see will be more tailored to your interests. If you do not allow these cookies, you will experience less targeted advertising.

YES

NO

Are you sure you want a less customized experience?

We can access your data only if you select "yes" for the categories on the previous screen. This lets us tailor our marketing so that it's more relevant for you. You can change your settings at any time by visiting our privacy statement

Your experience. Your choice.

We care about your privacy. The data we collect helps us understand how you use our products, what information you might be interested in, and what we can improve to make your engagement with Autodesk more rewarding.

May we collect and use your data to tailor your experience?

Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.

Answer 1 · 2017-11-16T14:46:47Z

Steven Hamoen answered Nov 16 2017 at 2:46 PM Joerg Vogel commented Nov 16 2017 at 5:32 PM

@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.

· 4

Anggoro P commented · Nov 16 2017 at 2:56 PM

@steven.hamoen

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

0 ·

Steven Hamoen Anggoro P commented · Nov 16 2017 at 4:38 PM

@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.

0 ·

Anggoro P Anggoro P commented · Nov 16 2017 at 5:21 PM

@steven.hamoen

I also have thought about using stay time, but the problem is we have made different parameter, which is total age (age+source age) and realized that it is not a label (but a field in the list). So I don't know how to track this parameter on query

0 ·

Joerg Vogel Anggoro P commented · Nov 16 2017 at 5:32 PM

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.

0 ·

Answer 2 · 2017-11-16T17:16:39Z

Joerg Vogel answered Nov 16 2017 at 5:16 PM Anggoro P commented Nov 17 2017 at 7:28 AM

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"));

· 2

Joerg Vogel commented · Nov 16 2017 at 5:20 PM

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.

0 ·

Anggoro P Joerg Vogel commented · Nov 17 2017 at 7:28 AM

@Jörg Vogel

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

perishable-scm.fsm

0 ·

perishable-scm.fsm (23.5 KiB)

a.jpg (97.0 KiB)

Answer 3 · 2017-11-16T17:01:40Z

Joerg Vogel answered Nov 16 2017 at 5:01 PM

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

pull-more-items-matching-list-attribut.jpg (149.4 KiB)

pull-more-items-matching-list-attribut.fsm (19.9 KiB)

question