GlideRecord Limit by Field

ChezAndrewI0898
Tera Contributor

Use Case:

CategoryNameImpact
Category ATestName1High
Category ATestName2Medium
Category BTestName3Low
Category BTestName4Low
Category BTestName5Medium
Category CTestName6Medium
Category CTestName7Low
Category DTestName8High
Category DTestName9High

 

I want to get all records and limit to only 3 Categories order by Impact.

 

This would be the display after the query:

Category ATestName1High
Category ATestName2Medium
Category BTestName3Low
Category BTestName4Low
Category BTestName5Medium
Category DTestName8High
Category DTestName9High

 

How to query this?

 

Thanks!

4 REPLIES 4

Mark Manders
Tera Patron

Please elaborate: what is your use case? You are providing a table with data. That's not a use case. What are you trying to achieve? What is the requirement?

Assuming the 1st table is the data.

I want to query the records of at least 3 categories order by Impact.

From the data we have 4 Categories (Category A, Category B, Category C, Category D),

But I want to query the records and limit to 3 Categories only.

 

My question is how to query that one using GlideRecord?

 

Hope this helps you understand the Use Case.

 

Thanks!

No it doesn't. Just select 3 categories. How are you limiting them? What do you want to see? This really doesn't make sense.

How do you select just 3 categories?