Thanks so much for writing. Sorry for the delay. I signed up to follow this thread but never got an email notification.
I read the article you provided and watched the video but I wasn't able to make it work.
I used Query Designer so my query looks like:
'<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
'<ListName>SPTableProjects</ListName>
'<ViewFields>
' <FieldRef Name="Title" />
' <FieldRef Name="Status" />
' <FieldRef Name="ID" />
' </ViewFields>
'</RSSharePointList>
I tried to remove that and overwrite it with the Select statement below but I got the error: "Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct."
Select
[Title]
,[ID]
,[Status]
from SPTableProjects
Thanks