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