Syntax of expected arguments for WAPI.WorkList() function

HFCDev

Hi, 

  Can anyone tell me what the WAPI.WorkList() function is expecting as arguments for the view and where arguments (argument 2 and 3 after the session object)?

Assuming you pass in a legitimate view name, albeit custom, say MyLingualView_fr, which has a LangCode argument, and you pass in  for the where argument something like "LangCode='fr'"  I would expect that the results returned would only be those that match the above, but it appears that the where argument is being ignored. This seems to be new in CS 16.2.

Any suggestions would be helpful.

-Hugh Ferguson, doing a bit of development finally

Joerg_Wuerzer

Hu Hugh,

As you said, the second parameter contains the name of the view to execute and the third parameter the where clause. I had a look into the function and at a first look it seems the where clause is still used. But the rendered SQL statements differs depending on the flags parameter. So it could also be interesting what your flag settings are.

You can verify the executed SQL statement by yourself by increasing the log level of the connect logs and searching for entries containing 'WStatus::WorkList2'.

Executing ...

WAPI.WorkList( wSession, 'WWorkCustom', 'Work_WorkID < 20000', 0 )

... returns the expected list of items and results in the following log entries

KSqlCursor::Open(201f,'select v.* from WWorkCustom v  where (Work_WorkID < 20000)') -->'SUCCESS'
KSqlCursor::Prepare() --> 'SUCCESS'
KSqlCursor::Bind(0,{}) --> 'SUCCESS'
KSqlCursor::Execute({'Work_WorkID'}) --> 'SUCCESS'
KSqlCursor::Fetch({18475}) --> 'SUCCESS'
KSqlCursor::Fetch({19796}) --> 'SUCCESS'
KSqlCursor::Close() --> 'SUCCESS'
KSql::Execute(...) --> 'SUCCESS',2 records,[sec: 0 msec: 61]
WStatus::WorkList2(WWorkCustom) --> V{<'Work_WorkID'><18475><19796>},'SUCCESS'
KSql::EndTransaction('SUCCESS',FALSE) --> 0

Regards Jörg