wildcard symbol for SQL LIKE statement in TKL treated differently for "advanced search" by category

yaronlu

Hi,

I have a TKL SQL which works fine in Classic UI (listed below).

It lists value in one TKL, depending on another TKL value.

If the other TKL is empty, it returns all values.

When I try to use it in "advanced search" by category,

I try to open it, and it shows no values, instead of all the values.

After inquiry I found out that the wildcard symbol "%" is not recognized at the TKL when showed in "advanced search"

is this a bug of opentext?

is there a way to configure CS to recognize wildcard symbol in advanced search?

Is there any other symbol that will work also for the advanced search TKL?

 

Thanks

Yaron

 

 

 

This is the SQL:

----------------------

SELECT distinct gt.DocTypeName

From TblFolders gf inner join TblFolderDocTypeRel gfdr on gf.ID=gfdr.FolderCode inner join TblDocTypes gt on gt.ID=gfdr.DocTypeCode

where gf.FolderType=3 and gf.FolderName Like ISNULL(<Another_TKL_Val>,'%%%%')

 

 

yaronlu

Hi,

I created a livereport to replace this sql statement,

but I dont know how to call the livereport from the TKL sql statement.

tried these sql syntax (not working):

EXEC MyLiveReport param1,param2

MyLiveReport param1,param2

 

Please advive what is the right syntax ?

Thanks