Answers.Body: <p>Lars and Coleman suggested the solution to this comment. Removing distinct from just the date on the activity session has solved the issue.</p>
  <p><a href="https://i.sstatic.net/FhIzJ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/FhIzJ.png" alt="Search Query" /></a></p>
  <p>See my comment above - I do not actually understand why this has solved the issue. Problem solved nevertheless! Thanks for your input.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-07-21T09:27:27.613Z
Answers.LastActivityDate: 2023-07-21T09:27:27.613Z
Answers.UserDisplayName: henrypearce
Body: <p>Currently we have a SearchKit display to show activities on a case that are use to link to a form. Some activities are not showing as we expect on the final display.</p>
  <p>As an example, there are currently a total of 13 activites on the SearchKit display that are appearing. However, on the case there are 16 activities. The three activities that are missing from the SearchKit display need to be visible to users.</p>
  <p>On the preview of the search results, all 16 activities appear like we expect.. (see screenshot below) therefore the search is working however the display is not functioning as we expect.</p>
  <p>Why aren't all 16 activities visible? Is there a limiter that I am not aware of, or is this potentially a bug?</p>
  <p><strong>Preview of search results:</strong></p>
  <p><a href="https://i.sstatic.net/3rjX1.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/3rjX1.png" alt="enter image description here" /></a></p>
  <p><strong>SearchKit display:</strong></p>
  <p><a href="https://i.sstatic.net/19dEj.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/19dEj.png" alt="enter image description here" /></a></p>
  <p><a href="https://gist.github.com/chumkui/fa72aa1fa7620d2386f32e1bc8e5dfb0" rel="nofollow noreferrer"><strong>Here is a Gist link to what the API call looks like</strong></a></p>
  <p><a href="https://gist.github.com/chumkui/b01b9baeab077692cff1fccc89f35bbf" rel="nofollow noreferrer"><strong>Here is a Gist link to the SQL</strong></a></p>
  <p><strong>The search being carried out:</strong></p>
  <p><a href="https://i.sstatic.net/yfzTB.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/yfzTB.png" alt="enter image description here" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-20T13:45:19.447Z
Comments.Text: Suspicious that you have 13 dates in the search results. Is that correct (i.e. there are only 13 distinct dates)? Can you try without Distinct for the dates? Can you try changing one of the duplicate dates?
Comments.UserDisplayName: Lars SG
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-20T13:45:48.623Z
Comments.Text: It could also help to post a screenshot of the search itself and the SearchDisplay settings.
Comments.UserDisplayName: Lars SG
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-21T02:14:29.370Z
Comments.Text: I was going to suggest the same thing. Try removing DISTINCT from all of your field transformations.
Comments.UserDisplayName: Coleman
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-21T09:14:26.143Z
Comments.Text: Thanks Lars and Coleman. I removed Distinct from the Session date field transformation and this now makes all activities visible. However, I do not understand why! The original search works and returns all activities, including clickable links. It is the display that was the issue. I noticed that if I remove the link from the activity list then they all display as expected. Why would expressing the output as a link cause an issue? In my example, the dates happen to be the same but in production they are not. I would really like to understand this!
Comments.UserDisplayName: henrypearce
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-07-21T14:11:53.657Z
Comments.Text: I think it might help to figure out what's going on if you share a screenshot of the setup of the SearchDisplay (not the result of the SearchDisplay, but the screen that lists the columns and all the options).
Comments.UserDisplayName: Lars SG
Tags: <searchkit>
Title: Limited Activities Showing On SearchKit Display
ThreadText: # Limited Activities Showing On SearchKit Display
  
  (Asked by: username_0 on 2023-07-20)
  
  Currently we have a SearchKit display to show activities on a case that are use to link to a form. Some activities are not showing as we expect on the final display.
  
  As an example, there are currently a total of 13 activites on the SearchKit display that are appearing. However, on the case there are 16 activities. The three activities that are missing from the SearchKit display need to be visible to users.
  
  On the preview of the search results, all 16 activities appear like we expect.. (see screenshot below) therefore the search is working however the display is not functioning as we expect.
  
  Why aren't all 16 activities visible? Is there a limiter that I am not aware of, or is this potentially a bug?
  
  **Preview of search results:**
  
  [![enter image description here](https://i.sstatic.net/3rjX1.png)](https://i.sstatic.net/3rjX1.png)
  
  **SearchKit display:**
  
  [![enter image description here](https://i.sstatic.net/19dEj.png)](https://i.sstatic.net/19dEj.png)
  
  [**Here is a Gist link to what the API call looks like**](https://gist.github.com/chumkui/fa72aa1fa7620d2386f32e1bc8e5dfb0)
  
  [**Here is a Gist link to the SQL**](https://gist.github.com/chumkui/b01b9baeab077692cff1fccc89f35bbf)
  
  **The search being carried out:**
  
  [![enter image description here](https://i.sstatic.net/yfzTB.png)](https://i.sstatic.net/yfzTB.png)
  
  **Tags:** searchkit
  
  > **Comments:**
  > **username_1**: Suspicious that you have 13 dates in the search results. Is that correct (i.e. there are only 13 distinct dates)? Can you try without Distinct for the dates? Can you try changing one of the duplicate dates?  
  > **username_1**: It could also help to post a screenshot of the search itself and the SearchDisplay settings.  
  > **username_2**: I was going to suggest the same thing. Try removing DISTINCT from all of your field transformations.  
  > **username_0**: Thanks Lars and username_2. I removed Distinct from the Session date field transformation and this now makes all activities visible. However, I do not understand why! The original search works and returns all activities, including clickable links. It is the display that was the issue. I noticed that if I remove the link from the activity list then they all display as expected. Why would expressing the output as a link cause an issue? In my example, the dates happen to be the same but in production they are not. I would really like to understand this!  
  > **username_1**: I think it might help to figure out what's going on if you share a screenshot of the setup of the SearchDisplay (not the result of the SearchDisplay, but the screen that lists the columns and all the options).  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2023-07-21. Score: 2
  
  Lars and username_2 suggested the solution to this comment. Removing distinct from just the date on the activity session has solved the issue.
  
  [![Search Query](https://i.sstatic.net/FhIzJ.png)](https://i.sstatic.net/FhIzJ.png)
  
  See my comment above - I do not actually understand why this has solved the issue. Problem solved nevertheless! Thanks for your input.
  
  
  ---
  
  