Solved: Expression Problem - Page 2

Jonathan_S · 05-07-2020 09:44 AM

Hello Everyone,

Just trying to make something a little more user friendly.

So I have a maintenance program, and in this program users can connect parts to certain machines so that when they perform maintenance they have a limited number of parts to select from (Only parts that have been connected to the machine) as opposed to a massive list of all parts. Problem is somtimes they are connecting the same part to the machine more than once.

My expression for selecting a part. More Like @Steve expression when I was just beggining to make apps.

ORDERBY(
SELECT(
   Parts[ID], 
   
    OR(
      ISBLANK([_THISROW].[Part Catagory]),
      ([_THISROW].[Part Catagory] = [Part Catagory])
    )
)
, [Part Name], false)

Now, what im looking to do is to only show parts that have not been conented to the machine already. The machine name column is already filled in before they can select a part, so we know what machine the user is dealing with. Just how would I sort the list so that only parts that have not already been connected to the [_THISROW].[Machine Name] are shown?

Bahbus

List addition and subtraction I doubt would be going anywhere.

ORDERBY(
SELECT(
   Parts[ID], 
    OR(
      ISBLANK([_THISROW].[Part Catagory]),
      ([_THISROW].[Part Catagory] = [Part Catagory])
    )
) - SELECT(Parts[ID],[_THISROW].[Machine name]=[machine name])
, [Part Name], false)

View solution in original post