How to create a custom contextual message for using a data service based on a functional search ?

Hello,

I've created a data service based on the M3 FACETMI/LstFacets API.

One of the parameters of this API is SQRY an search query (e.g. CUNO:Y00001 to keep it simple).

I'm using this data service to display information in a Chart widget.
So far, no problems.

Where I run into difficulties is when I try to contextualize communication between a list widget and my Chart widget, for example.

I know that I need to create a custom contextual message and use it on the send side for my List widget and on the receive side for my Chart widget.

But how do I design this message so that, in the end, my widget in SQRY is a string made up dynamically of the concatenation of CUNO: (Fixed part) followed by the value of my customer number CUNO.

Is this possible?

If it isn't, I conclude that it wouldn't be possible to create contextual relations when a data service is based on the use of a functional search.

Denis

Find more posts tagged with

Accepted answers

All comments

Caitlin Porter

I might have an answer, but I need to test it first. Do you know how I can find the value that is required for FNAM (table name)?

Denis MARETTE

Hi Caitlin,

No - I opened a support call because I asked myself exactly the same question.

But I was able to deduce the answer myself by experimenting.
All you have to do is use the FACETMI api without specifying a FLNA value, and with the answers, you can deduce the possible values by examining the contents of the FLNA field

Denis MARETTE

In fact, I illustrated my question using FACETMI as an example.

But, in my opinion, the question can be generalized to any API which is based on a search and which will require the construction of a character string to build the content of a field of type SQRY.

And the problem is that, for the moment, I've concluded that this isn't currently possible, even after examining the October release.

Or am I completely wrong?

Denis MARETTE

I share the answer coming form the Infor support team about FACETMI:

Table FSLEDG (Accounts receivable) doesn't have any facets defined except CONO, so that's why PYNO cannot be used in FACETMI (List facets) for this table. We currently don't support this functionality. In M3 CE 16.0.0 facets are defined in the backend, not accessible to customers. Therefore, customers will have to create an enhancement request using KB KB1872520 if they need specific tables and fields to be used with FACETMI.

To check if facets exist for a table and which fields, you can run FACETMI for the table and enter a star (*) in the SQRY (Search query) field. Then you will get all facets (if any) in the company, provided you have data in the table. If many facets exist for the table, you may not get all facets in the result due to the limitation of max records. Then you can specify the fields of interest in the FLNA (Filtering of field names) field or by limiting the search query, to check if there is any result.

You can test FACETMI via the OS->API Gateway or via M3->Administration Tools ->M3 Metadata Publisher (MDP). In MDP you select M3 API Repository->Test API.

Denis MARETTE

Hi @caitlin-porter

Can you tell me more about the idea you have to solve this problem?
I'd be happy to try on my own if you don't have the time.

Denis

Caitlin Porter

Hey Denis - I don't know what values to put into this API to get it to run in the gateway, I need to be able to test this in the gateway before suggesting a possible solution in OAD. What values would I need for these two required fields?

Denis MARETTE

Ok Too happy to learn something too

For example, if you wanted to know for customer Y00001, how many occurrences of OOHEAD orders there are per RESP customer manager, you'd use the API like this.

And in return, you'd get the number of orders per customer manager in the FFN1 field.

Copyright © 2025 Infor. All rights reserved.