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

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

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
 

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.

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.