Updatable BAQ on Kinetic Form - Unable to get Order Number to link to Key 1

Kinetic ERP
1

I am trying to update a kinetic form to match our classic form. I have attached an updatable baq to the sales order entry form. I cannot get the baq to only show the information from the selected order. I tried casting the sales order number as navchar but I get all of the sales orders.

Where:
UD16_Key1=?{CAST(OrderHed.OrderNum as nvarchar(50))}

When I use UD_Key1=?{OrderHed.OrderNum}

I get no results.

I am on Kinetic 2024.2.12

Any ideas on how to get Key 1 to equal the sales order number?

The where clause with cast is what I use in Classic to link the two together.

2 
UD16_Key1 = '?{OrderHed.OrderNum}'
3

I tried that and I am getting all of the sales orders instead of no results

4

What do you see in the Network tab of Developer Tools when you make a call with that where clause?

5

I am not sure what that is

6

Actually, it started working once I got out of the menu and back in. Thank you for your help

7

It didn’t start working. I was looking at the wrong panel. where do I find the network tab on developer tools?

8

You can access the Developer Tools by pressing F12 on your web browser. The Network tab is visible there.