Does mixing delegable functions and non-delegatable functions work? I figured I could filter down the results for delegatable functions to around less than 500, then use that as a source for a non-delegable function and filter it even further, kind of this this
The inside filter is delegatable since it just compares 2 text fields (mainexecid and executiveid), however, the outside filter takes it as a source and compares lookup values, which makes it delegatable.
My question is less about effeciency because I have specific requirements for doing this, but more so questioning if this works... or does everything automatically become non-delegatable?
Yes, it works. If the "inner" filter can be completely delegated to the server, then it will be. In your scenario, the server will filter the data based on the value of the 'mainexecid' column, and the result will be filtered locally based on the value of the other columns in the client.