[megan_mcp]

Hi  !

Can you try naming the function classifyTrades instead of classifyTrade.

I’ve tested it and it should work fine with this adjustment.

Many thanks,

Megan

[megan_mcp]

Hi  !

From what I can see your .z.pg code works fine. The issue, as you mentioned, is your code for loading in the database.

Can you try replacing your lower two hdbH statements with:

hdbH"\l f1"

hdbH"tables[]"

Line 1 is what the user described in the post you tagged – ‘l’ meaning load and ‘f1’ being the directory.

Let me know if this works!

Thanks,

Megan

[megan_mcp]

Hi  !

From what I can see the problem is in line 3. If you replace:

.Q.trp[{`$(mysensor),

With:

'string[mysensor],

Your function should work fine.

If you have any other issues please feel free to let me know,

Megan

[megan_mcp]

Hi  !

I’ve tested your code and the only issue I can see is that you need to change the spelling of the symbol from:

`notAuthorised

To:

`notAuthorized

As stated in the question (screenshot provided below).

Let me know if this works!

Megan

[megan_mcp]

Hi  !

If you try putting a forward slash between the edit and the hashtag, it should go into editor mode.

Let me know if this works!

Megan

[megan_mcp]

Hi ,

That screenshot shows you are still in JupyterLab. Once you’ve ran the script in the terminal, click the Launcher tab (blue button in the top left hand corner), then click KX Developer (screenshot provided).

Once KX Developer has launched, you’ll be greeted with your workspaces where you should see your kxsql-demo workspace.

Hope this helps,

Megan

[megan_mcp]

 

I notice for your uniqueOpts variable you’ve declared it as:

uniqueOpts: enlist (select distinct option_id from trade)

Tables are created out of lists, so by enlisting the option_id column you are creating a list of a list.

Since we already have our list, we just want to convert this into a list format. To do this you can use the exec  keyword.

Once you’ve edited this, it should work fine.

Thanks,

Megan

[megan_mcp]

Hi ,

Sorry for the delay in response, it’s because you didn’t define your function as ‘classifyTrades’.

I defined the function and the tests passed.

Thanks,

Megan

[megan_mcp]

Glad to hear! Goodluck with the rest of the Capstone. Megan

[megan_mcp]

 

It looks like you are trying to send an IPC query from the database to the database which is not supported. It is unclear where you are running it.

If that is a data source in a dashboard, that code is getting shipped to a DAP and then it is trying to query itself, which is not supported.

Megan

[megan_mcp]

Hi  !

Unfortunately, at the moment there’s no way to achieve this, the reason being that it would overcomplicate the already complicated datagrid configuration.

However I do recommend using dataform to edit the values for single selected row.

Thanks,

Megan

[megan_mcp]

Hi ,

What version of KX Dashboards are you using ?

Thanks,

Megan

[megan_mcp]

Hi  !

Can you try these steps?

Please save and download your files before doing the below or you will lose your changes.

1. Shut down Developer browser windows
2. File -> Hub Control Panel -> Stop My Server
3. Start My Server
4. Retrying the steps in the README

Let me know if this works.

Thanks,

Megan

 

[megan_mcp]

Hi  !

This all seems correct, if you have any more questions please feel free to ask

Thanks,

Megan

[megan_mcp]

Hi  !

This isn’t a valid query for the qsql endpoint. The difference between Query and View is that a view would be calling '/servicegateway/qe/qsql' whereas the query goes via Scratchpad.

If you have any more questions feel free to reach out.

Thanks,

Megan