Edit : Solved by using the following:
const filters = Ext.create("Terrasoft.FilterGroup"); if(this.get("UsrFonctionDansInstance")) { var functionId = this.get("UsrFonctionDansInstance").value; var subFilters = Terrasoft.createFilterGroup(); subFilters.addItem(Terrasoft.createColumnFilterWithParameter( Terrasoft.ComparisonType.EQUAL, "UsrFonctionsDansInstance", functionId) ); var adminRef = "[UsrAdminContactFonctionInstanceCompte:UsrAccountType:Type]"; filters.add( Terrasoft.createExistsFilter(adminRef + ".Id", subFilters) ); } return filters;
Hi,
I struggle in order to implement a filter matching this query:
DECLARE @P1 uniqueidentifier = 'D21F0468-F86B-4707-9FDB-C093CF0F6F87'; Select Account.Name, AccountType.Name from Account LEFT JOIN AccountType ON Account.TypeId = AccountType.Id where exists ( Select SubUsrAdminContactFonctionInstanceCompte.Id FROM UsrAdminContactFonctionInstanceCompte [SubUsrAdminContactFonctionInstanceCompte] WITH(NOLOCK) Where Account.TypeId = [SubUsrAdminContactFonctionInstanceCompte].UsrAccountTypeId AND [SubUsrAdminContactFonctionInstanceCompte].UsrFonctionsDansInstanceId = @P1 )
Anyone see matching filter path ?
Like
1 comments
01:13 Jul 15, 2020
Hello Jerome,
Thank you for sharing your solution here.
Hope it will help other community users if they have the similar question.
Kind regards,
Roman
Show all comments