Hey Adam,

You’ll want to use a manual picklist. Here’s a checklist of what you need:

1. Add a ContractsForFilter model with all requisite fields whose values you’ll be merging into the picklist display. Make sure you’re querying it somehow (either on page load, or whenever your model-to-be-filtered is updated)


2. Add a condition to your Asset model, WHERE Contracts Id = single specified value (but left blank). Leave that as default off.


3. Click your filter component. Click the stack icon (Add Option Source).


4. Click Source Type and choose Rows in a Model


5. In Option Label Template, use mustache syntax to add what you need.


6. In the Value to Inject, make sure that you’re using the right Id (or equivalent) field to add to your Assets condition above.


7. Save

It’ll look like this.

I think that should do it. Just make sure that you query that model so you have picklist values.

If I mis-characterized what you need, let me know!

Best,

Aaron

Hey Aaron,

Thank you for the reply. I do have a filter setup this way as a work around, however it is limited in that in order to search all Contracts like the auto filter would I need to open the model up to all Contracts. I get a heap size error when doing so (we are over 100k records).

Was hoping I could use the auto-filter but add additional fields to the search template.

Am I missing something on the ContractsforFilter model that would allow for them to search all without running into the heap size error short of filtering that model to just certain Contracts? 

Thank you!
Adam