LINQ Query in Set Variable widget in Function

Kinetic ERP
,
1

I’m trying to write a LINQ query to set a variable in a widget in a function. I can’t use Db.TableName. Is there a way I can do this or do I need to change to a custom code function and create a context, etc.?

image
image558×452 13.7 KB

2

Add RcvDtl to Tables

image

3

I wish it were that simple. I’ve got the table in there.

image
image383×159 2.63 KB

4

Did you set db access on the library page?

5

This is how I have it setup.

image
image857×265 6.91 KB

6

Add your function here.. Obviously blank out any intellectual property.

7

CustomizationHelpers.efxb (15.2 KB)

There’s not much to it. It’s the only function in the library and I only added one widget (which is the Set Variable widget I took a screenshot of).

Maybe I have something setup incorrectly. I knew of the two things you guys have suggested. But I am unaware of anything else.

Thanks!

8

Looks like Db is only allowed for widgets with code function type, not just for widgets.
If i create Widgets with Code function, i can verify that expression

image
image601×263 10.8 KB

9

OK - I can run with that. Thank you very much!! Didn’t even think of that.