Jump to content
Jeremy

Enhancement - Selecting Users in drop down

Recommended Posts

We want to able to utilise the option in the PCF to allow customer to choose another user as affected which we can do very nicely with a Dynamic Drop Down box linking this to users.

However, as this list has all users this is causing us issues, for example we have all students and staff in this list and need a way of restricting this list by department/organisation or a query.

To be able to define this list would help us as we have approaching 57,000 users and the vast majority of these are students and when completing these forms we are asking for other affected staff members, this would also make the list faster and easier to use and cut down on the potential risk of having duplicate names and choosing the wrong affected user.

  • Like 1

Share this post


Link to post
Share on other sites

@Jeremy

Would having the ability to specify a SQL where clause to populate the list work?

From our point of view we would find this useful, especially if you can inject variables into said clause.

Cheers

Martyn

Share this post


Link to post
Share on other sites
3 hours ago, Martyn Houghton said:

Would having the ability to specify a SQL where clause to populate the list work?

@Martyn Houghton This could work for us.

  • Like 1

Share this post


Link to post
Share on other sites

Hi @Jeremy, @Martyn Houghton,

We can add an option to the user's list to be able to filter based on Group ID. So it will only return users that are assigned to that specific group. Will that work in this case?

Daniel

Share this post


Link to post
Share on other sites

@Daniel Dekel as long as there is a way to identify the people who we want to search on, then a method of displaying just this subset then we are happy.

Share this post


Link to post
Share on other sites

Even if we entered in a custom field against a user a specific phrase/text which we can then use to extract the people that would be a step in the right direction.

Share this post


Link to post
Share on other sites

@Jeremy, that is fine. I've added this to our list. I'll let you know when is ready. It will be depending on the latest platform and Service Manager builds.

@Martyn Houghton, just the thought about opening up SQL to customers gives me headache ;-) . We'll add a "kind of" query that will allow you specify parameters in the query, but you won't have access to the actual SQL if it makes sense.

Cheers,

Daniel.

Share this post


Link to post
Share on other sites

@Martyn Houghton, I prefer not allowing anyone dealing with SQL or parts of SQL. If there is an alternative, I prefer using that. 

Daniel.

Share this post


Link to post
Share on other sites

@Daniel Dekel

As long as it provides the ability to make it dynamic with multiple conditions and variables.

From out point of view, we would then want to do a similar thing with contacts, so a customer can select a colleague utilising a filter.

Cheers

Martyn

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...