[megan_mcp]

Hi ,

Assuming you’re getting the error ‘trips’ is because you haven’t imported the trips.csv file in yet which is mentioned in the “Importing Data using KX Developer” section of the demo (screenshot provided).

Once you’ve imported this csv file, it should be able to run as expected.

Let me know if this works,

Megan

[megan_mcp]

Hi  !

Can I ask you to send over the code you’re trying to run?

Thanks,

Megan

[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  !

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  !

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 ,

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  !

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]

 

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]

Glad to hear! Goodluck with the rest of the Capstone. 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]

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