function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
BrianbhcBrianbhc 

SOQL syntax using custom setting

I'm looking for the correct SOQL syntax to use in query filter utiziling a custom setting record value. I see plent of info using the value in a formula field or apex, but I need it in SOQL.
BHinnersBHinners
Why do you need it in SOQL?  The docs discourage that because it doesn't make good use of cache and so you might as well just use a custom object rather than a custom setting.  To make use of the cache, try using the methods described here instead: https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_custom_settings.htm
BrianbhcBrianbhc
The third party app I'm using to query only supports SOQL. I'm only running this query once day. I'm limited on tabs and I only need it to hold a date/time field for syncing of data. Brian