Save query data result in the form for later use

R

Ramadan

I am quering a database through a web service, the resturn type is complex
and has many repeating sections.

The first time a user creates the form, he enters the query filters and
clicks a button to invoke the web service and get the result. Then the user
saves the form (to a sharepoint library).

Now, when the user or another one opens the form again, i want him to see
the previously returned results, but i want him to see the exact previous
result (snapshot created before) and not to simply re-query the web service
again. i.e. save the query result in the form.

i know i can set a rule to cope the result fields from the datafields to my
custom fields... but i have many data types and that can be really hard to
implement.

is there a way to save the query result in the form to create a snapshot of
that data, offline mode does not seem to be the right thing to do since this
form will be opened by many users.
 
Top