I'm trying to query data in order so if it finds data in NodeMACAddresses post that, if not then check ${N=SwisEntity;M=CustomProperties.MAC_Address}, if there is no data there either then type No Mac Address.
${SQL: select coalesce((select (MAC) from NodeMACAddresses where NodeID=$@nodeid@), ${N=SwisEntity;M=CustomProperties.MAC_Address}, 'No Mac Address')}
This query works if it finds data in NodeMACAddresses or no data at all but if there is data in ${N=SwisEntity;M=CustomProperties.MAC_Address} it gives me the error MACRO SQL ERROR - Incorrect syntax near ':'.
What am I doing wrong?
