MAM 7.6.1.2:

In the Database Configuration application:

There is a Type of Complex Expression field that has Sql Query Pattern as a lookup value:


Question:

What is Type of Complex Expression --> Sql Query Pattern used for?

Thanks.
#AssetandFacilitiesManagement
#Maximo

That field is used for display in a BiDi implementation.  Take a look here for more info: https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=&ved=2ahUKEwiz7vbkuNbxAhUHMVkFHQwbAVMQFnoECAUQAw&url=https%3A%2F%2Frender-prd-trops.events.ibm.com%2Fsupport%2Fpages%2Fsystem%2Ffiles%2Fsupport%2Fswg%2Ftivtech.nsf%2F0%2Fce33908751277b8a852575d00051c819%2F%24FILE%2Fmbs7115_multiculturalsupport.doc&usg=AOvVaw1JiiVFlDWfvfAMYfChyI9n

------------------------------
Steve Hauptman
------------------------------

Original Message:
Sent: Thu July 08, 2021 05:26 PM
From: User1971
Subject: Type of Complex Expression --> Sql Query Pattern

MAM 7.6.1.2:

In the Database Configuration application:

There is a Type of Complex Expression field that has Sql Query Pattern as a lookup value:


Question:

What is Type of Complex Expression --> Sql Query Pattern used for?

Can it be used to generate the non-persistent field value via SQL syntax (without needing to fuss around with a DB view)?
I'm pretty sure the answer is no, but I thought I'd ask.

Thanks.
#AssetandFacilitiesManagement
#Maximo