+4I have a document library where i am uploading an xml file with ID's. I am triggering a workflow that will query xml and that will create an item with ID connected to a field in another list. Here is the issue, where i have few sql control's based on that ID will get the values from sql database.
But it's not pre-quering the values when the item is created, but it's working when the form is opened in edit mode after the item is created.
Please let me know what may be the issue.
+4Sorry for the late reply, i am getting the value on view mode but its not saving/storing into the list while creating the item through workflow that's my main issue.
I'm not sure I do understand what's your exact process then...
you have a xml, you parse it and picks some ID(s). then you store these ID(s) into new items.this sounds to work correctly, is it so?
further on you want to get some further data related to the ID(s) with SQL query. is this where you have problems?
if I understand it correctly, if you do the (same?) SQL query within the form it return data for a given ID correctly.
if that's the case then it looks like to be problem with SQL query within the workfow or withi processing SQL query result set and saving it to list items...
+4Further in the form that have created through workflow i am getting employee details based on those ID's using SQL query action which are also working fine.
But it's not pre-quering the values when the item is created, but it's working when the form is opened in edit mode after the item is created.
But, the issue here is the data from the SQL query action controls (connected to list columns) are not saving onto the list.
so what are you exactly expecting to happen?
from the workflow you save just the ID, with no details. so at this moment you can not see any related details in list view.
if you open the item in a form in VIEW mode (and you've SQL request configured to recalculate) you will likely see related details get populated => and you've written that's working.
but VIEW mode form doesn't save anything to the list, so in list view you still will not see any details.
if you open the item in EDIT mode (and you've SQL request configured to recalculate) you will again likely see related details get populated. if you leave the form without save/submit nothing gets written to the list again. if you save or submit, and you have correctly configured/connected the control, details should save => and you've written that's working either.
this is expected functionality.
so, I'm still not sure what's your exact problem.
+4if you create/update item from a workflow you directly write to a list item. no form is open nor involved in the action.
just like you populate an ID from workflow, do so for employee details.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
