Subscribe

WFA - Create Custom Cache Query

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.

 

 

Cache Query Error.jpg

 

Any Help would be great,

 

Thanks,

Sheel

Re: WFA - Create Custom Cache Query

id is mandatory to return.

 

Change your query to add following

 

SELECT
NULL AS id,

 

It should work.

 

Re: WFA - Create Custom Cache Query

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