S-Query for monitor

I want to build a monitor to display purchase order lines that were not received in time.

When I run this search: FACI: <FACI> AND PUSL:[20 TO 49] AND VDDT:[DATE(-365) TO DATE(-0)]

This is shown:

Statement is correct, however, when I go through the records selected I see that at least one record is not correct => date ahead of my selection.

This is how I set up my monitor:

Would appreciate input on the fact that my query seems to work but retrieves wrong records.

Find more posts tagged with

Accepted answers

All comments

Andreas Aubele

Hi,

i would at first recrawl the table MPLINE (PPS220) in LifeCycleManager->IES Admin Tool to make sure that the data basis for the Enterprise Search is correct. Then try your query again.

Catharine Linsbauer

Hi Andreas

Thanks, crawling was the answer. Now it works.

com_proactive_201104.pdf

Andreas Aubele

Great it worked!

When using Enterprise Search you have to understand that you search the data according to the last crawl of the table. But the data displayed in your search results is always the real data of your M3 database (not of the crawl). The search on table MPLINE just passes the key values like facility and purchase order number back to M3, then M3 lists all records matching the key fields. If your crawl is not up to date you then will maybe find wrong data, have missing data, have to much data.

If you have not done it already... also set MPLINE as Online Indexed in Local Management Pages of your Enterprise Search installation.

Copyright © 2025 Infor. All rights reserved.