General

Re: Compare SP table to form table (to determine changed fields)?

shniggens — Sun, 31 Jul 2011 00:33:29 GMT

But I need to report when the XML modified is greater than the SharePoint list item. IE - the latest changes in the form, not the list. From what I understand of the command from the qRules guide is that it does not work that way.

I'll try the rule in reverse as you suggested.

Re: Compare SP table to form table (to determine changed fields)?

Patrick Halstead — Sat, 30 Jul 2011 22:30:20 GMT

One idea you can try is to invert the rule. In other words, but the 2DS (secondary data source) on the left of the condition and the main data source on the right.

Re: Compare SP table to form table (to determine changed fields)?

Patrick Halstead — Sat, 30 Jul 2011 22:28:18 GMT

This is the scenario we had in mind when we added the Refresh SharePoint List Items command to qRules 2.3 last year. It has two options - Report and Update which allow you to list the differences between the XML and the list or update the XML with the changes from the list. Typically you use it on a form load rule. Easy to compare, show the differences, and then update based on a button click.

Let me know if you want a demo.

Re: Compare SP table to form table (to determine changed fields)?

shniggens — Sat, 30 Jul 2011 18:04:32 GMT

I tried this formula, with no success -

my:Total != xdXDocument:GetDOM("Saved Pulls")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Total[../d:ID = current()/my:PullID]

I run a query of the SharePoint list first, but it still doesn't apply the formatiting. Is there something else I need to do? Shouldn't this compare the fields?

Compare SP table to form table (to determine changed fields)?

shniggens — Fri, 29 Jul 2011 03:56:16 GMT

More questions, questions, questions . . .

I have a table that a user submits, and another user reviews and adjusts the form accordingly (in a different view). After the second user reviews it, the data is saved into a sharepoint list.

The first user now has the option of editing the form again. Is there an easy way to compare the table in the form to the table on SharePoint, so that the second user will easily be able to see what has changed since last time? I want to compare the table, and format the text red if it has changed.

It's a large table, and the reviewer is going to have to easily spot out what has changed.