Process Variable not getting assigned with DSE

I have a rule to fetch DSE from database. Debugged and works fine.

In my process model, I'm using pkId to lookup data using my rule and then assigning it to a process variable. Unfortunately my process variable is not getting assigned. When I debug the process, I don't see any errors and I've double checked my rule for fetching data and that I'm passing id correctly.

On the Data Output tab of my script task I'm calling the rule - rule!GetDataById(pv!myId) with a Custom Output. myId is populated with value e.g. 4, and I see it when I debug

I'm storing the results in process variable for my entity. However, after I let the script task finish and check my process variables, my entity object is empty.

This should just work :-( 

What obvious thing could I be missing?

  Discussion posts and replies are publicly visible

Parents Reply
  • Is it possible for the Query Editor to generate the code I now see I'm missing?

    I don't have much experience using the (relatively new) Query Editor as I'm used to just writing any necessary query entities by hand.  In general my suggested approach for using it would pretty much always be to use it only to quickly establish a basic query that works, and then tweak it per your needs in the Expression Rule editor (and also test it there, etc).