Primary table is Accounts on a list view page. Added Drawer to show related Contacts for each Account record in table. Followed the directions on this page: https://docs.skuid.com/latest/en/skuid/components/drawers/
Keep getting SOQL error when opening Drawer. I have the
Accounts as Primary object
Contacts model has condition where Account.Id = blank, filterable off
The Before Load Actions on the Drawer Activate Condition and Set Value,
query Contacts Model, value = {{Id}}.
Tried several different tweaks and still coming up with this error below. It has to be something simple I am missing:
SOQL query: SELECT Name,Title,Account.Name,AccountId,Id FROM Contact WHERE (AccountId = 001G000001yaZc7IAE) LIMIT 21 Error:unexpected token: ‘G000001yaZc7IAE’
Tried using Account.Id and it did not make a difference
Thanks
Question
SOQL Query error on Drawer Open Accounts-Contacts
+7+7I was able to resolve this by pasting the sample xml from the tutorial page. Not sure where the error was, as all of the Action Framework settings look the same. Nice to have the xml example!
+10Ann,
I think your condition on the Contact model for the drawer was the problem. The tutorial says to use ‘AccountId’ as the model field for the condition. In your posting you have ‘Account.Id’ (account dot id) as the condition. Using ‘Account.Id’ will cause problems.
Thanks,
Bill
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.