# Funds\_capstone 1.5 issue with optRef table returning empty

**URL:** <https://forum.kx.com/t/funds-capstone-1-5-issue-with-optref-table-returning-empty/15282>\
**Category:** Academy Support\
**Created:** [October 5, 2025, 5:58pm UTC](https://forum.kx.com/t/funds-capstone-1-5-issue-with-optref-table-returning-empty/15282 "2025-10-05T17:58:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![diwan.work1902](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/diwan.work1902/32/128_2.png) [@diwan.work1902](https://forum.kx.com/u/diwan.work1902)\
**Post date:** [October 5, 2025, 5:58pm UTC](https://forum.kx.com/t/funds-capstone-1-5-issue-with-optref-table-returning-empty/15282/1 "2025-10-05T17:58:02Z")

</div>

Hi , trying to complete exercise 1.5 , executing below queries but optRef table is returning zero count -

uniqueOpts: select distinct option\_id from trade

count uniqueOpts (returning count 100)

refServiceHandle:hopen `::5457

//please refer to screenshot for output of these two commands below-  
optRef:refServiceHandle(`getOptionRef;`uniqueOpts)  
count optRef (returning count 0)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/kx/original/1X/c3f98e5c63aee34836ca16a3c696019f7e051f84.png)

Kindly help with same.

---

<div class="post-metadata">

**Author:** ![mmcparland](https://sea2.discourse-cdn.com/flex002/user_avatar/forum.kx.com/mmcparland/32/54_2.png) [@mmcparland](https://forum.kx.com/u/mmcparland)\
**Post date:** [October 6, 2025, 12:31pm UTC](https://forum.kx.com/t/funds-capstone-1-5-issue-with-optref-table-returning-empty/15282/2 "2025-10-06T12:31:23Z")

</div>

Hi @diwan.work1902

Make sure that your uniqueOpts variable is in **list** form. At the minute it’s in the form of a table.

![Screenshot 2025-10-06 132851](https://us1.discourse-cdn.com/flex002/uploads/kx/original/1X/7dd6e4fa537537ef4c2840a91afa566dd5b21b9b.png)