enhancement request Enhancement - Selecting Users in drop down

[Jeremy]

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.

[Martyn Houghton]

@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

[Jeremy]

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.

[Daniel Dekel]

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

[Jeremy]

@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.

[Jeremy]

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.

[Daniel Dekel]

@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.

[Martyn Houghton]

@Daniel Dekel

I was thinking along the same lines as we do in the measures where we can specify the where clause.

Cheers

Martyn

[Daniel Dekel]

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

Daniel.

[Martyn Houghton]

@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