WFA - Create Custom Cache Query

[sheelnidhig]

Hello Guys,

I am trying to create a custom Cache query to have Annotation view from OCUM 7.0 imported in WFA 4.0, so i started with a very simple Cache Query but its coming up with an error.

I hace created a Dictionary Item under CM_Storage Schema and selected OCUM 6.3/6.4 as datasource type.

Any Help would be great,

Thanks,

Sheel

[karale]

id is mandatory to return.

Change your query to add following

SELECT
NULL AS id,

It should work.

[shailaja]

To add to it:

In general, it is good to see the contents of the tab "Create table SQL". That shows the structure of the cache table WFA will create, into which your SQL query should populate the data.

Thanks,

Shailaja