Can you filter fields on an extension table by fields on the base table?
For example…
@joeyates23 may you please help look at my ticket https://sdsupport.nextworld.net/support/tickets/434991 about these data mappings?
No, the extension table itself isn’t something that you should be really going after. You would want to filter on the base table and from that level you should be able to use your extension fields in that filter.
Sorry @keiko.kasho I don’t have access to see that ticket there, but hopefully my answer above helps and if not happy to have it go through the channels for a bug.
@joeyates23 When you say filter on the base table, what does that look like?
Where are you trying to filter? Is this just in an application on a data mapping? Is that what we are talking about here?
In this scenario, the base table and app have been extended. A new TL was added on the extended table and app. We want to be able to filter that new TL based on a field that exists on the base table. Initially, we tried filtering this TL on the extended table and then on the search app that was added for this TL on the extended app but got errors about the field (i.e. company which we were trying to use to filter) didn’t exist on the table.
So what you are saying I do believe should work in terms of setting it up. So it’s probably at least worth looking more into. Or at least coming back with other options if this isn’t the correct one
