Has anyone successfully written code allowing the filtering of a view say a table or list by the contents of a field from a connected object and the logged in user?
For example:
Filter by the logged in user and the following:
object_55, field_1260 = object_6, field_1256
Knack doesn't appear to have this as part of its builder functionality and its a core need for my application. I dabble with code but that is all, so anyone who has tried this successfully or thinks they know how to do it I'd be very grateful for any input.
Thanks Brad unfortunately that isn't a solution for us. We couldn't find a solution that would allow us to filter views on unstipulated content, i.e. filter Table A on Field_1260 where it equals field_1256 from Table B for logged in user X. The helpdesk suggested rendering the views outside of knack but for us where we need this for so many views, it became impractical, sadly we are now in the process of moving over to another software provider.
Jason,
I would be thinking of the database & view structure:
1. Create a view that displays the top level records connected to the logged in user - say field_1256 in a table. http://helpdesk.knackhq.com/support/solutions/articles/5000443970-showing-records-connected-to-the-logged-in-user
2. Then show that record on a single view and add a table displaying the child records for what you need.
I have a feeling it isn't as simple as that for what you're trying to achieve?
I'm trying to work on this myself - If someone has a way to do it, I'd love to hear it.