Question

Team Filter stopped working

Forms Version 11

Updated February 6, 2023

asked on February 2, 2023

This Team Filter has been working for years on a number of forms and, just today, I have discovered it is not working. I have rebuilt the filter and cannot see why it is not working. Filter is set to find the person on the Team via the County Rep name field that was filled out on the form via a drop-down (so that names are not misspelled).

Did something change in the latest Forms update to make it stop working? We just had forms updated on Wednesday to Version 11.0.2212.30907.

0 0

Answer

SELECTED ANSWER

replied on February 3, 2023

Hi all,

I was able to find an answer for Connie. It looks like there was a change to prehaps make the selectors more literal. When I looked at the data being passed into the filter it was actually the DisplayName of the user that the process was trying to match and not the UserName. Looking in the documentation I noticed there is a method for finding by Display name as well as User name. Changing the filter to the following allowed it to be successful:

$result=team.findTeamMemberByDisplayName($util.getValue('County_Representative_Project_Manager')

The filter was definately set to findTeamMemberByUserName before and working with the same data being passed to it.

1 0

View 3 previous replies

replied on February 3, 2023

Thanks, Jim! I have changed all the forms to that configuration now and they all tested fine!

1 0

replied on February 4, 2023

I’m so happy to hear you guys got this working.

0 0

replied on February 6, 2023 • Show version history

It is strange that change the function from "findTeamMemberByUserName" to "findTeamMemberByDisplayName" fixed the issue as the original error "Filter contains invalid variable" is related to the process variables. Can you check whether it works as well if you change the function back to "findTeamMemberByUserName"(no more "Filter contains invalid variable" error when test the filter)? Also you can add "$test=$util.getValue('County_Representative_Project_Manager')" in the team filter and check whether there is any error when test.

0 0

replied on February 6, 2023

0 0

replied on February 6, 2023

Interesting... so, when Jim helped me get this Team working again, I only changed it in the three forms where the variable was "Supervisor" and those are all working now. The contractor form is used far less and I had left it with the configuration without using the Team.

But now that Xiuhong-Xiang has asked me to do more testing, I have changed it back to the Team and I see that even with the DisplayName config, this Team is still not working. But the fix DID work for the other three forms.

Last test, which did Suspend:

Version of the Filter used:

$result=team.findTeamMembersByDisplayName($util.getValue('County_Representative_Project_Manager'))

Variable Result:

0 0

replied on February 6, 2023

I just switched the Contractor form back to the alternative configuration that does not require this Team. I think I'll work towards eliminating this Team in the future. When this Team was created, we did not have the ability to use a hidden db for Employee Names and Job Descriptions that allowed Laserfiche Forms to assign tasks based on a name picked out of a drop down list. We do now and that is my preferred configuration now.

1 0

Replies

replied on February 3, 2023

Sometimes Forms just stops evaluating filters. Restarting Forms Routing Service usually fixes it.

2 0

replied on February 3, 2023

Good to know!

0 0

replied on February 3, 2023

I've never had it do that myself. I hope that solution works for you Connie.

0 0

replied on February 2, 2023 • Show version history

That error message in the Script Output makes it sounds like doesn't like the variable name. Have you double-checked that the variable is on this process and hasn't accidentally been modified?

EDIT: I just tested on my end and got the exact same error when I edited the variable so that it no longer matched the variable name on the process.

0 0

View 4 previous replies

replied on February 2, 2023 • Show version history

Yes, the variable is still the same. This is off the form that suspended today:

I did check that. And then I went to another form that I knew was programmed in the exact same way and checked it, and it is also not working and no changes have been made to the second form in years. Either, really, but I'm more sure about the second form.

1 0

replied on February 2, 2023

Yeah, it definitely looks the same.

Have you tried editing the filter and re-adding the variable from the picker?

I have no idea why it's struggling, but just that step of editing and re-adding it may resolve whatever the issue is.

0 0

replied on February 2, 2023

Yes, I have tried that too. aand... now its suspending on a third form that uses that same Team configuration! I think I should report this to the people that did the upgrade for us.

0 0

replied on February 2, 2023

Yeah, that's not a bad idea to ask your Solution Provider to take a look.

0 0

replied on February 2, 2023 • Show version history

And now a fourth form is doing it, but only on that one Team. This form uses a couple different teams on different categories and the other settings are still working. Although that other Team is filtering per Role and the Team that is not working was set to filter by a name in a field.

0 0

replied on February 2, 2023

Are they all using that same filter that is giving you trouble - or are there multiple different filters?

0 0

replied on February 3, 2023

The other three are set to find the name in a field for a supervisor name, variable is "Supervisor".

0 0

replied on February 2, 2023

We can not reproduce it internally. I created a similar team filter with Forms 11.0.2201.20436 as below, then upgrade to Forms 11.0.2212.30907.

Please open a support case with your Solution Provider and provide the Forms database backup for us to investigate.

0 0

replied on February 3, 2023 • Show version history

This 0 team member(s) result is what I am also getting now on the other three forms that are now suspending suddenly. I can't see why, nothing has changed.

I have reported it to our Solution Provider.

I have reconfigured the Contractor Safety Agreement form to find the Project Manager name another way for now, however, I have left the other three forms using the variable of "Supervisor" the same so that the investigation will still be able to see the issues.

0 0

You are not allowed to follow up in this post.

Question

Question

Team Filter stopped working

Answer

Replies

Sign in to reply to this post.