In a logic block, can I fetch records from a table that is connected to JDE via a Real-Time Data Registration?

Someone I’m working with is trying to do this and keep hitting the error Error - Logic block execution failed for logic block: xxxxxxx. Caused by: Cannot fetch and lock on an external system.

Is this even possible? I asked Ed this exact question and he indicated the answer is yes, but, from what I read in help, I didn’t notice anything saying this is supported. What I saw was Help mention support for applications built over these tables, but no mention of logic blocks directly fetching from such tables.

Just to add onto this, when building an application over the internal table one can see that there are records in the application but you cannot view or see the data. In the example below one can filter on an external address number but cannot see any values.

@chris.walsh should a logic block be able to fetch from JDE? Per @jaco.theron’s note, it looks like certain filtering in the UI isn’t working, which leads me to believe that queries might not be supported.

Ross, Jaco is actually creating nwID’s, but no data is being brought back.

@ian.p yes, you should be able to fetch from a real-time table in a logic block, but you cannot fetch and lock. What flavor of fetch action are you using in your logic block?

1 Like

@tracy.l and @jaco.theron this speaks to me that the data isn’t getting mapped correctly when coming back from the external system. I’m anticipating by the name of your app in this screenshot that it is built over a Data Service, not an Orchestration?

The table is built over a Data Source Type = Data Service yes.

The action in the logic block is a regular Fetch Records, it does not involve any locking.

From what I’m hearing, fetching from such a table is supported and it not working might be a bug or misconfiguration.

1 Like

Hi Cheyanne, its a data service