What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hi all, can anyone tell me when the table spy_oms_order_item_state table is filled? Problem: I want

USPATDHK5
USPATDHK5 Posts: 60 🧑🏻‍🚀 - Cadet

Hi all,
can anyone tell me when the table spy_oms_order_item_state table is filled?
Problem: I want to set the state of an item (spy_sales_order_item), in order to do that I need the foreign key (spy_oms_order_item_state), but I only have the string (the name) and not the id. I created a Repository/Reader in order to read the spy_oms_order_item_state, but the state I am looking for is (not yet) in the table.
🙉
Thanks

Comments

  • Hey Sarah! What kind of problem are you trying to solve? I mean why do you need to set the state manually by yourself?

  • jochen.gartner
    jochen.gartner Posts: 42 🧑🏻‍🚀 - Cadet

    the state gets written to the table once the first item transitioned into it, you're not supposed to do this manually.

  • USPATDHK5
    USPATDHK5 Posts: 60 🧑🏻‍🚀 - Cadet

    I feared that I was doing it all wrong 😄 😢

  • you’re not supposed to do this manually.

    Yeah totally agree 👍