Column 'union' does not belong to table - Support - RS Data Extension

Search Forum Home

Forum

Enesys RS Data ...

Support - RS Da...

Column 'union' does not belong to table

9/25/2007 2:17 AM

dkumar

www.bechtel.com
Joined: 9/25/2007

Posts: 1

Column 'union' does not belong to table

Modified By dkumar on 9/25/2007 1:18:51 AM

Hi,

I wrote this query:
====
<?xml version="1.0" encoding="utf-8" ?>
<root>
<multiList title="Projects" relativeSiteUrl="/" tableName="Projects" useDisplayName="true" >
       <fields> Job No, Project Name</fields>
      <query>
      </query>
   </multiList>
</root>
====
I am getting error message "Column 'union' does not belong to table".

I am running version 1.4.2.30133 (copied the new version of DLL today).

Regards,
DK

9/25/2007 11:18 AM

Frédéric LATOUR

Joined: 5/31/2006

Posts: 629

Re: Column 'union' does not belong to table

Hi,
When you run a multilist query, the "tableName" that is referenced by your query is a SharePoint list (a merging list) that contains the name of all the lists which data should be merged.
This "merging list" has mandatory columns.
"union" is such a mandatory (Yes/No) column that will indicate if a list should be merged.
You can find more information in the documentation page 39.
Does it clarify?
Please let me know if you need further assistance.
Regards,

Frederic LATOUR
ENESYS

Page 1 of 1

Forum

Enesys RS Data ...

Support - RS Da...

Column 'union' does not belong to table