I am creating a dashboard where i want to highlight customers with sofware support. (Or without. We shall see…).
Looks like if I apply a view-rule mydatefield < constant Tomorrow it works in classic:
But when I try to deploy to a Kinetic App:
From this thread Publish Dashboard Rules - Publish its a known issue and the workaround is to add a calculated field at the BAQ level.
Here’s my attempt:
Syntax error…incorrect syntax near ‘as’
The query phrase looks ok:
select [Customer].[Company] as [Customer_Company], [Customer].[CustID] as [Customer_CustID], [Customer].[CustNum] as [Customer_CustNum], [Customer].[Name] as [Customer_Name], [Customer].[City] as [Customer_City], [Customer].[State] as [Customer_State], [Customer].[Country] as [Customer_Country], [Customer].[PhoneNum] as [Customer_PhoneNum], [Customer].[EMailAddress] as [Customer_EMailAddress], [Customer].[PrimecutNE_Owned_Count_c] as [Customer_PrimecutNE_Owned_Count_c], [Customer].[PrimecutNE_Parked_Count_c] as [Customer_PrimecutNE_Parked_Count_c], [Customer].[Software_Maintenance_Expires_c] as [Customer_Software_Maintenance_Expires_c], [Customer].[ERP_System_c] as [Customer_ERP_System_c], [Customer].[Primecut_Test_Account_c] as [Customer_Primecut_Test_Account_c], (Customer.Software_Maintenance_Expires_c < Constants.Tomorrow) as [Calculated_primecutsupport] from Erp.Customer as [Customer] order by Customer.Name
I tried adding square brackets also to my calculation: [Customer].[Software_Maintenance_Expires_c] < Constants.Tomorrow