Expand my Community achievements bar.

Announcing the launch of new sub-community for Campaign Web UI to cater specifically to the needs of Campaign Web UI users!

Error Filtering Recipients With External Database Table [FDA]

Avatar

Level 2

Hi,

I am trying to query recipients based on some criteria stored in external database. I have joined external table as shown below and selected columns which will be imported, but when I test the query I am getting error below. Is there something am I missing?

XTK-170036 Unable to parse expression '[temp:[camp].[Loan]:@CIF]'.

1760756_pastedImage_0.png

1760757_pastedImage_1.png

1760758_pastedImage_4.png

1760764_pastedImage_8.png

2 Replies

Avatar

Level 5

Hi,

your table name is weird. just keep it simple and use alphanumerical characters and if you want to separate words just use camelcase or underscores.

Kind regards,

Pierre

Avatar

Level 2

Hi pierrec70731455

My table name is 'Loan', schema name is 'camp' (like dbo). This table exists on remote mssql server.