typically, I use equal to ANY() in the expression for "in list"

and not equal to ALL() for "not in list"

Robert,

I had no idea that these two functions existed; thank you for sharing them! I have also been using the same technique as Michelle, but ANY() and ALL() will go a long way to make our queries/SQL easier to read.

This group is awesome! I am very excited to see all of the cool things that come out of it.

Jeffrie

Robert,

I had no idea that these two functions existed; thank you for sharing them! I have also been using the same technique as Michelle, but ANY() and ALL() will go a long way to make our queries/SQL easier to read.

This group is awesome! I am very excited to see all of the cool things that come out of it.

Jeffrie

typically, I use equal to ANY() in the expression for "in list"

and not equal to ALL() for "not in list"

I haven't either!  I will have to give this one a try!  Thanks for sharing Paul's presentation too Dana!  These are great resources!

Robert,

I had no idea that these two functions existed; thank you for sharing them! I have also been using the same technique as Michelle, but ANY() and ALL() will go a long way to make our queries/SQL easier to read.

This group is awesome! I am very excited to see all of the cool things that come out of it.

Jeffrie

I haven't either!  I will have to give this one a try!  Thanks for sharing Paul's presentation too Dana!  These are great resources!

Robert,

I had no idea that these two functions existed; thank you for sharing them! I have also been using the same technique as Michelle, but ANY() and ALL() will go a long way to make our queries/SQL easier to read.

This group is awesome! I am very excited to see all of the cool things that come out of it.

Jeffrie

typically, I use equal to ANY() in the expression for "in list"

and not equal to ALL() for "not in list"

typically, I use equal to ANY() in the expression for "in list"

and not equal to ALL() for "not in list"

Robert,

I've never used the expressions ANY / ALL. Thanks for sharing these expressions. I've tried both the expressions for more than 1000 values for in list with ORs and criteria grouping. This is so cool and awesome!

typically, I use equal to ANY() in the expression for "in list"

and not equal to ALL() for "not in list"

We do something similar to focus on a certain student population, but we use an Expression.

------------------------------
Tiffany Yuen MS
Information Technology Business/Technical Analyst
Los Rios Community College District
------------------------------

Hi all, 

We also use something similar to this, as well:

This allows us to drop an SID string into the expression (max 285 students). Thanks for sharing other alternatives!

Elizabeth O'Connor

We do something similar to focus on a certain student population, but we use an Expression.

Hi all, 

We also use something similar to this, as well:

This allows us to copy/paste an SID string straight from excel into the expression (max 285 students). Thanks for sharing other alternatives!

Elizabeth O'Connor

------------------------------
Elizabeth O'Connor
System Operations Manager
University of Colorado
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Hi all, 

We also use something similar to this, as well:

This allows us to copy/paste an SID string straight from excel into the expression (max 285 students). Thanks for sharing other alternatives!

Elizabeth O'Connor

------------------------------
Elizabeth O'Connor
System Operations Manager
University of Colorado
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------


Original Message:
Sent: 01-21-2025 05:12 PM
From: Tiffany Yuen
Subject: In List -

We do something similar to focus on a certain student population, but we use an Expression.

------------------------------
Tiffany Yuen MS
Information Technology Business/Technical Analyst
Los Rios Community College District

This is so smart! Nice to meet you Lea. My name is Shad I work for CSN in Admissions. I never thought about doing this, but this is such a good idea. I will need to remember this if I ever need to do large groups of queries at a time.

Hi all, 

We also use something similar to this, as well:

This allows us to copy/paste an SID string straight from excel into the expression (max 285 students). Thanks for sharing other alternatives!

Elizabeth O'Connor

------------------------------
Elizabeth O'Connor
System Operations Manager
University of Colorado
------------------------------

Message from the HEUG Marketplace:
------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
------------------------------

Michelle,

That is a great suggestion, thanks for sharing it with the community!

I have actually employed this same strategy recently, and it's so much easier, especially when you have a long list.

Here's a tip: if you have a lengthy list and your formatting is incorrect-like missing single quotes around individual items or delimiting commas-you can use a bit of code in Notepad++ or other programs like Excel or Python to quickly correct the formatting. This way, you can easily copy and paste it into the expression without having to edit each item manually. My list of 100 or so emplids required this and this trick made life a whole lot easier!

Thank you all for the additional great tips!  Here is the formula I use in excel to assist in adding the quotes and commas to make it a lot easier:

To format the numbers in excel, if your IDs are in column B and there is a header row, you can enter the following formula in column A and copy down: 

="'"&B2&"',"

Thank you all for the additional great tips!  Here is the formula I use in excel to assist in adding the quotes and commas to make it a lot easier:

To format the numbers in excel, if your IDs are in column B and there is a header row, you can enter the following formula in column A and copy down: 

="'"&B2&"',"

Michelle,

That is a great suggestion, thanks for sharing it with the community!

I have actually employed this same strategy recently, and it's so much easier, especially when you have a long list.

Here's a tip: if you have a lengthy list and your formatting is incorrect-like missing single quotes around individual items or delimiting commas-you can use a bit of code in Notepad++ or other programs like Excel or Python to quickly correct the formatting. This way, you can easily copy and paste it into the expression without having to edit each item manually. My list of 100 or so emplids required this and this trick made life a whole lot easier!

Thank you all for the additional great tips!  Here is the formula I use in excel to assist in adding the quotes and commas to make it a lot easier:

To format the numbers in excel, if your IDs are in column B and there is a header row, you can enter the following formula in column A and copy down: 

="'"&B2&"',"

Thank you all for the additional great tips!  Here is the formula I use in excel to assist in adding the quotes and commas to make it a lot easier:

To format the numbers in excel, if your IDs are in column B and there is a header row, you can enter the following formula in column A and copy down: 

="'"&B2&"',"

Michelle,

That is a great suggestion, thanks for sharing it with the community!

I have actually employed this same strategy recently, and it's so much easier, especially when you have a long list.

Here's a tip: if you have a lengthy list and your formatting is incorrect-like missing single quotes around individual items or delimiting commas-you can use a bit of code in Notepad++ or other programs like Excel or Python to quickly correct the formatting. This way, you can easily copy and paste it into the expression without having to edit each item manually. My list of 100 or so emplids required this and this trick made life a whole lot easier!

I've done the various apostrophe/quote hacks in the past in Excel with Student IDs too for lists; I used to think, 'I'm probably the only fool doing this and I'm missing something more efficient.' It's fun to see that it's the approach many others are using too!

Thank you all for the additional great tips!  Here is the formula I use in excel to assist in adding the quotes and commas to make it a lot easier:

To format the numbers in excel, if your IDs are in column B and there is a header row, you can enter the following formula in column A and copy down: 

="'"&B2&"',"

I've done the various apostrophe/quote hacks in the past in Excel with Student IDs too for lists; I used to think, 'I'm probably the only fool doing this and I'm missing something more efficient.' It's fun to see that it's the approach many others are using too!

Thank you all for the additional great tips!  Here is the formula I use in excel to assist in adding the quotes and commas to make it a lot easier:

To format the numbers in excel, if your IDs are in column B and there is a header row, you can enter the following formula in column A and copy down: 

="'"&B2&"',"

Michelle,

That is a great suggestion, thanks for sharing it with the community!

I have actually employed this same strategy recently, and it's so much easier, especially when you have a long list.

Here's a tip: if you have a lengthy list and your formatting is incorrect-like missing single quotes around individual items or delimiting commas-you can use a bit of code in Notepad++ or other programs like Excel or Python to quickly correct the formatting. This way, you can easily copy and paste it into the expression without having to edit each item manually. My list of 100 or so emplids required this and this trick made life a whole lot easier!

I've done the various apostrophe/quote hacks in the past in Excel with Student IDs too for lists; I used to think, 'I'm probably the only fool doing this and I'm missing something more efficient.' It's fun to see that it's the approach many others are using too!

Thank you all for the additional great tips!  Here is the formula I use in excel to assist in adding the quotes and commas to make it a lot easier:

To format the numbers in excel, if your IDs are in column B and there is a header row, you can enter the following formula in column A and copy down: 

="'"&B2&"',"

Michelle,

That is a great suggestion, thanks for sharing it with the community!

I have actually employed this same strategy recently, and it's so much easier, especially when you have a long list.

Here's a tip: if you have a lengthy list and your formatting is incorrect-like missing single quotes around individual items or delimiting commas-you can use a bit of code in Notepad++ or other programs like Excel or Python to quickly correct the formatting. This way, you can easily copy and paste it into the expression without having to edit each item manually. My list of 100 or so emplids required this and this trick made life a whole lot easier!

Thank you all for the additional great tips!  Here is the formula I use in excel to assist in adding the quotes and commas to make it a lot easier:

To format the numbers in excel, if your IDs are in column B and there is a header row, you can enter the following formula in column A and copy down: 

="'"&B2&"',"

Michelle,

That is a great suggestion, thanks for sharing it with the community!

I have actually employed this same strategy recently, and it's so much easier, especially when you have a long list.

Here's a tip: if you have a lengthy list and your formatting is incorrect-like missing single quotes around individual items or delimiting commas-you can use a bit of code in Notepad++ or other programs like Excel or Python to quickly correct the formatting. This way, you can easily copy and paste it into the expression without having to edit each item manually. My list of 100 or so emplids required this and this trick made life a whole lot easier!