Reading Realtime Connected Tables

Nextworld Platform
1

I created a Realtime Table view of JDE F4201. I created a standard list application that can view the data, and filter on fields.

I want to be able to from a logic block select data from this table, e.g. for a specific AN8 (customer)

When I set this up in a Logic block I get this error during execution

Error - Cannot invoke real-time callout over F4201. Caused by: Expected exactly one key for filter, but list of keys was: [type, value]

Ed: This error indicates that the real-time callout over the F4201 table encountered a problem where the filter provided had multiple keys (type and value), but it expected exactly one key.

To resolve this issue, you need to ensure the filter used in the real-time callout is correctly configured with only one key. You may need to review the logic block, workflow, or integration that is responsible for this callout and adjust the filter parameters accordingly.

The resulting LB that it builds does exactly the same fetch and expressions I coded..

Is there a specific way in which you have to setup the indexes or make the fetch, or do you have to bring the complete table, and then filter by processing/looping through them?

2

Good morning @brandt.koos. Can you confirm that the only filter criteria in your fetch in your Logic Block definition is where AN8 = <someCustomer>?

3

Good Morning Cheyanne. Yes I do a fetch and expression is Field.SalesOrdersCustomer(nsStxJDESalesOrderHeaderF4201RT).nsStxAN8 = Var.CustomerNumber

I have also tried with additional fields like nsStxKCOO, nsStxDOCO, nsStrxDCTO and nsStxVR01 (I looked at the typical F4201 indexes…)

You can look at the LB at nsStxLoadJDeSalesOrderSummaryRT line 20.

4

Good morning @brandt.koos , I took a look at your use case and I have tracked down the issue. Can you please work with your Platform admin to file a bug so we can officially track this? I’ll get working on a fix. Thanks!