MxLoader

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!

------------------------------
Manuel Guyot
Husqvarna AB
------------------------------

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
------------------------------

Original Message:
Sent: 11-12-2021 04:18
From: Manuel Guyot
Subject: Rest Query with comparison of 2 column in a table.

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!

------------------------------
Manuel Guyot
Husqvarna AB
------------------------------