Complex lookup filter

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 0

Like

1 comments

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