This is driving me crazy!
All I’m trying to create a condition on a model where the condition checks whether the selected field is less than another field on the same row. I’m using Row Merge Syntax
Here’s a screenshot of the condition
Here’s the error i receive when I try to preview the page
SELECT BOM_Qty_Req__c,BOMLineItem__r.BOM_Part__r.In_Stock__c,SalesOrderLineItem__r.Sales_Order__c,SalesOrderLineItem__r.Sales_Order__r.Name,SalesOrderLineItem__r.Sales_Order__r.Customer_PO_No__c,BOMLineItem__r.BOM_Part__c,BOMLineItem__r.BOM_Part__r.Name,BOMLineItem__c,BOMLineItem__r.Name,Id FROM Sales_Order_Line_Item_BOM__c WHERE (SalesOrderLineItem__r.In_Stock__c < )AND(BOMLineItem__r.BOM_Part__r.Part_Type__c in (‘Aluminum Raw Material’,‘Metalphoto Raw Material’,‘Stainless Steel Raw Material’)) ORDER BY Id LIMIT 501
Error:unexpected token: ‘{’
Why can’t I use row merge syntax on this condition?
I would really appreciate the help!
P.S. I received 3 errors trying to post this question… first a 422 error, then it refused to let me create a hyperlink to Skuid documentation saying links to that domain are not allowed?!? and finally, I guess I can only post 1 image since I have a new account…