SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a ticketlist which has ticket_id for 2 different locations,

tickd1,tickd2,tickd3,tickd4 for Dallas
ticka1,ticka2,ticka3,ticka4 for Atlanta

Now I am trying to create 2 views, one for Dallas and 2nd for Atlanta. The view in Dallas should have 2 conditions, one is the tick_ID contains "tickd" (which I was able to do oob) but the 2nd condition is to have only the latest created ticket. So this view will have only the latest created ticket for the location Dallas.

share|improve this question
up vote 3 down vote accepted

Simply order the view as you have it by Created, descending order, and limit the number of items returned to 1 and you should have the desired affect.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.