SQL - Collection

Dear Experts,

i have created the collection with SQL query like


[COLLECTION : CurrentLedgerCollection]
SQL : "select $name from ledger where $name in (cash,ABC company)"

;;;SQL : "select $name from ledger where $name in (##LedgerList)"

this collection's count is 2, but i couldn't able to view the ledger name, i gave like


031 : WALK COLLECTION : CurrentLedgerCollection
041 : msgbox : "" : $Name
061 : END WALK

but it shows empty message box , and i also tried with Type object


[COLLECTION : LedgerCollection1]
Type : Ledger
Filter : LedgerFilterCondition1

[SYSTEM : FORMULA]
LedgerFilterCondition1 : $Name in (##LedgerList)

[FUNCTION : FnSearchEngine]
Variable : LedgerList : String
00 : Set : LedgerList : $$string:"cash,Excel traders";
01 : WALK COLLECTION : LedgerCollection1
02 : msgbox : "" : $Name
03 : END WALK


this code also not working, but we change the condition like
LedgerFilterCondition1 : $Name in (cash,Excel traders)
this code is working..

if anyone can fix this issue please let me know.. because i pass the ledger values at run time.
please give high priority to this issue.

thanks in advance..

Regards,
Dhanapal Amulraj.

 

Did you find any solution for this?
I am also facing similar issue.

 

[COLLECTION : CurrentLedgerCollection]
Type : Ledger
Childof : $$GroupCash

 

I found One solution for this.

[SYSTEM : FORMULA]
LedgerFilterCondition1 : $Name contains ##LedgerList
OR
LedgerFilterCondition1 : ##LedgerList contains $Name

If you want you can add
LedgerFilterCondition1 : ##LedgerList contains $Name+","

##LedgerList = (cash, Excel traders) (LedgerList Variable is String)