jdtrent
November 13, 2024, 8:13pm
1
Hey,
I have a combobox connected to ResourceGroup displaying correctly, except I want to filter out inactive groups.
The reusable resource group combo wouldn’t let me change the Filters contents, so I added another combobox and manually entered the service, etc. Works fine, except for the filter.
When I try to add the filter like this:
Or this:
Or any other permutation, I get this when I click on the dropdown:
What’s the syntax on this bit of code? I’ve also tried these filters with resulting errors or lack of actual filtering.
Thanks,
Joe
1 Like
jdtrent
November 13, 2024, 8:58pm
2
Well, this worked. Close enough.
3 Likes
I am trying to do something similar - my reusable combo is using the Erp.BO.UserFileSvc - GetRows table UserFile.
I am trying to filter by UserFile.UserDisabled = false and I cannot get the filter to work.
Any suggestions welcome:
1 Like
hmwillett
March 28, 2025, 8:24pm
4
Put it in the Filters Append section.
Ms. Hannah: Thank you for the suggestion.
I thought i saw a thread somewhere that said we are unable to reference a field to filter on that is not part of a View?
Does that sound correct?
jdtrent
March 28, 2025, 10:25pm
6
Did you try UserDisabled = ‘0’ ?
Mr. Joe: Thank you for the suggestion. I was not able to get that to work.
hmwillett
March 31, 2025, 2:47pm
8
DaveOlender:
GetRows table UserFile.
Do you need the GetRows method?
Ms. Hannah: Thank you for the suggestion.
It is working now but i am not sure why.
I then noticed that the “Is Delimited” checkbox was checked. I then just left the Filters Append as “UserDisabled=False” and it now works.
1 Like
hmwillett
March 31, 2025, 3:30pm
10
That’s because when you use the Type and SubType it defaults to GetList.
2 Likes
Ms. Hannah: Thank you again - you are a ROCK STAR!
1 Like
