Skip to main content
Solved

Stop codes

  • November 13, 2024
  • 5 replies
  • 59 views
N
Sidekick (Customer)
Forum|alt.badge.img+7
  • NazishS
  • Sidekick (Customer)
  • 26 replies

Hi any idea what would be the api we need to write to pull data when the stop code is “resolved “

 

im able to pull data when the stop code is “waiting for parts”  with the below , but dont get any jobs with resolved stop codes.

 

Thanks in Advance.

 

<root xmlns:dt="urn:schemas-microsoft-com:datatypens">

<session email="" alias="">

<state bc_name="service_order">

<action name="execquerynolimit">

<attribute in_var="" out_var="QueryOutVar" entity_name="service_order" query_name="service_order_scrl"/>

<attribute dtype="string" in_var="" name="cust_company_id" value="test" operator="="/> 

<attribute dtype="string" in_var="" name="last_stop_code_id" value="PARTS" operator="="/>

 

</action>

</state>

</session>

</root>

Best answer by NazishS

Hi Reid  & Phil  . so getting the required data in the payload , but if im trying to filter for some values before executing the query for some reason the filter doesnt get applied , and i get all the data .

 

eg 

<root xmlns:dt="urn:schemas-microsoft-com:datatypens">

<session email="" alias="">

<state bc_name="service_order">

<action name="execquerynolimit">

<attribute in_var="" out_var="QueryOutVar" entity_name="service_order" query_name="service_order_scrl"/>

<attribute dtype="string" in_var="" name="cust_company_id" value="test" operator="="/> 

<attribute dtype="string" in_var="" name="last_stop_code_id" value="PARTS" operator="="/>

 

</action>

</state>

</session>

</root>

 

here I have put cust_company_id with a value test , in theory it should give me only the company ID with test , but give me ALL the customers list.

 

Any other configs we need to mofify? 

 

Thanks in advance.

View original
    Did this topic help you find an answer to your question?

    5 replies

    Reid Gilbert
    Superhero (Employee)
    Forum|alt.badge.img+15
    • Reid Gilbert
    • Superhero (Employee)
    • 339 replies
    • November 13, 2024

    Hi Nazish,
    I tested the API and it is working for me, can you try running it WITHOUT the last_stop_code_id parameter highlighted below (leaving only the cust_company_id entry) and then check the results pane for the last_stop_code_id value on some of those orders?  Does it show as PARTS in the result pane?  (maybe the issue is there are other activities on your order and the activity that was set with this stop code is not the most recently fulfilled activity?)
     

    Thanks,
    Reid

    N
    Sidekick (Customer)
    Forum|alt.badge.img+7
    • NazishS
    • Author
    • Sidekick (Customer)
    • 26 replies
    • November 14, 2024

    Hi Reid , the resolved stop code doesnt come up when i run it with just the company id 🤔 do we need to use any other scrl’s ? to pull activitie details

    Reid Gilbert
    Superhero (Employee)
    Forum|alt.badge.img+15
    • Reid Gilbert
    • Superhero (Employee)
    • 339 replies
    • November 14, 2024

    Hi Nazish,
    So the last_stop_code_id field isn’t included in the result list when you execute the API?  Or the field exists but it just doesn’t contain any data?  If it’s blank in the result list then try completing another activity on the same order and run the API again…see if it shows data at that time...
    Thanks,
    Reid
     

    Phil Seifert
    Ultimate Hero (Employee)
    Forum|alt.badge.img+23
    • Phil Seifert
    • Ultimate Hero (Employee)
    • 1296 replies
    • November 14, 2024

    Hi Nazish,

    It is not clear to me what you are actually trying to do…. if you use that API and the last_stop_code_id happened to be PARTS, it would return results.  You want to see last_stop_code_id’s when it is RESOLVED.

    I don’t know if you could perhaps trigger on the order_line.order_stat_uniq_id being 500 (resolved) while all the activities are fulfilled or completed as a possibility.

    Personally, I think you would be better off discussing this as a service request with an IFS business consultant to help get this developed instead of asking Community. If someone already has a solution it would be great but this looks more like a development task at this point.

     

    N
    Sidekick (Customer)
    Forum|alt.badge.img+7
    • NazishS
    • Author
    • Sidekick (Customer)
    • 26 replies
    • Answer
    • November 21, 2024

    Hi Reid  & Phil  . so getting the required data in the payload , but if im trying to filter for some values before executing the query for some reason the filter doesnt get applied , and i get all the data .

     

    eg 

    <root xmlns:dt="urn:schemas-microsoft-com:datatypens">

    <session email="" alias="">

    <state bc_name="service_order">

    <action name="execquerynolimit">

    <attribute in_var="" out_var="QueryOutVar" entity_name="service_order" query_name="service_order_scrl"/>

    <attribute dtype="string" in_var="" name="cust_company_id" value="test" operator="="/> 

    <attribute dtype="string" in_var="" name="last_stop_code_id" value="PARTS" operator="="/>

     

    </action>

    </state>

    </session>

    </root>

     

    here I have put cust_company_id with a value test , in theory it should give me only the company ID with test , but give me ALL the customers list.

     

    Any other configs we need to mofify? 

     

    Thanks in advance.

    Reply


    Terms & ConditionsCookie settings

    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