Kinetic rest-erp where clause syntax question

[datadaddy (Scott Janisch)]

I have an event for checking if an XPartNum (Customer part number in Order Detail) exists.

The event is using rest-erp component calling CustXPrtSvc.GetRows like this:

I’ve tried every variation I can think of on the where clause syntax but it’s either return me records because the payload is showing an empty where clause or I get a correlation id error because the where clause syntax is invalid.

With the rest helper api, it executes just fine with:

I have not been able to find any syntax examples for the where clause here in the forum or the application studio documentation

Anyone done something similiar ? thanks

[klincecum (Kevin Lincecum)]

Yes.

It doesn’t like replacing between the single quotes.

You’ll need an intermediary of some sort.

In a row-update:
I assigned CallContextBpmData.ShortChar01 to "'DP169X08CLCF'"

and in the erp-rest set it to XPartNum={CallContextBpmData.ShortChar01} and that worked.

Just got to figure out how to build the string with the single quotes and the field correctly

[klincecum (Kevin Lincecum)]

Ok, you should be able to build a field with row-update and stick it in transview or call context

Expression for row update on CallContextBpmData.Shortchar01
"'" + "{OrderDtl.XPartNum}" + "'"

erp-rest set it to XPartNum={CallContextBpmData.ShortChar01}

[datadaddy (Scott Janisch)]

@klincecum
Thanks Kevin…I would have taken a very long time to try that out, gotta love that Application Studio tool

I did end up just using a TransView field and that worked just fine

THANK YOU !!!

Easy follow-up (for someone like you)

This is what my response looks like:

How do I check if my response has at least one CustXPrt row in my rest-erp response parameters, this stuff

I don’t have a CustXPart dataview or dataset,
can I use “Parse from Response Path” to look for say “returnObj.CustXPrt.XPartNum” for example ?

thanks again

[klincecum (Kevin Lincecum)]

@datadaddy

Easy follow-up (for someone like you)

You’d think , but I have no idea.

[datadaddy (Scott Janisch)]

@klincecum

You’d think , but I have no idea.

maybe @hmwillett can come to the rescue (again)

[aarong (Aaron Gulley)]

Add your own dataview and assign it to that.

You can use MyDv.MyColumn wherever you want.

[hmwillett (Hannah Willett)]

@datadaddy

I don’t have a CustXPart dataview or dataset,

Why not? Make one.

[hmwillett (Hannah Willett)]

This is probably better than checking a field:

%cdv_CustXPrt.hasRow%

[hmwillett (Hannah Willett)]

@datadaddy

I have not been able to find any syntax examples for the where clause here in the forum or the application studio documentation

You had it correct. You must have some other issue going on.

[klincecum (Kevin Lincecum)]

@hmwillett

You must have some other issue going on.

I replicated his problem on my end. Not sure what’s going on.

[hmwillett (Hannah Willett)]

Is it isolated to that specific scenario? It worked okay by binding a textbox to TransView.PartNum.

[klincecum (Kevin Lincecum)]

I will test when I can.

[datadaddy (Scott Janisch)]

@hmwillett

You had it correct. You must have some other issue going on

The where clause thing is very strange

This did not work (where clause showed up empty in payload)

but this did (@klincecum 's trick)
(I put the quotes directly in the TransView field in the database)

Thanks for the help on the latter part !

[hmwillett (Hannah Willett)]

Seeeeeems fine to me. ¯\_(ツ)_/¯

[datadaddy (Scott Janisch)]

@hmwillett

This is probably better than checking a field:

How do you find things like this syntax: %AA_OFB_CustXPrt.hasRow% ?

Is there a list of these type of things ?
There was no intellisense for after the period…

Or are you using, “Try and see how epicor does it” (like by looking at the predefined events) that you mentioned in you session at Insights ?

btw…

I did get everything working with %AA_OFB_CustXPrt.hasRow% for the condition

but for some reason {AA_OFB_CustXPrt} != undefined gives me an error saying the AA_OFB_CustXPart IS undefined (even though a valid record was returned)

no worries, just testing/learning as I go thru this ‘adventure’

[datadaddy (Scott Janisch)]

@hmwillett

Seeeeeems fine to me. ¯_(ツ)_/¯

[hmwillett (Hannah Willett)]

@datadaddy

Or are you using, “Try and see how epicor does it” (like by looking at the predefined events) that you mentioned in you session at Insights ?

Yup–this. You can also do .count instead of .hasRows. %cdv_CustXPrt.count% > 0

@datadaddy

{AA_OFB_CustXPrt} != undefined gives me an error saying the AA_OFB_CustXPart IS undefined

You need to check against a column, not the dataView. So '{AA_OFB_CustXPrt.XPartNum}' !== 'undefined'

[fama_0 (Francisco Amador)]

Also note that there has been a lot of fixes and improvements to Application Studio between your version and the more current 2023 versions. It’s very likely that this is one of the things fixed to get it working as expected.

[klincecum (Kevin Lincecum)]

@fama_0

It’s very likely that this is one of the things fixed

I’m in 2023.1.5 and replicated it, will move to 2023.1.6 and test.