MxLoader

 View Only

Related Content

  • 1.  Rest Query with comparison of 2 column in a table.

    Posted 11-12-2021 04:18
    Edited by Manuel Guyot 04-30-2026 08:46

    Hi,

    Has anyone find a way to have a Rest Query with a comparison between 2 column in a table?

    I would like to have a Query where I will find in INVENTORY all the Parts where CURBALTOTAL <= MINLEVEL.

    Thanks for any hints or help!

    ------------------------------
    MG
    ------------------------------



  • 2.  RE: Rest Query with comparison of 2 column in a table.

    Posted 11-15-2021 09:19
    Hi Manuel,

    I don't know that you'll be able to only query the INVENTORY table because CURBALTOTAL is non-persistent. You may need to look at querying across the INVBALANCES table and the INVENTORY table

    Below is a helpful document for the different types of REST queries.

    https://restdb.io/docs/querying-with-the-api

    Thanks,

    ------------------------------
    Matt McGuire
    Aquitas Solutions
    ------------------------------



Newest Episode
Ep. 2 | Adding a QR Code to a BIRT Report

Watch Steven Shull walk through how to add a QR code to a BIRT report and make Maximo reporting more scannable, connected, and useful in the field.

Watch on YouTube Listen on Spotify
MORE by Naviam Episode 2 cover
Watch Episode 2
Also available: Ep. 1 | IBM Maximo Application Suite 9.2
Ep. 1 YouTube Ep. 1 Spotify Browse all episodes →