Tuesday, June 11, 2019

Case Search > Created By and Last Modified By

To pull up the Created By and Last Modified By on a Case Search Results, SQL is required. Please see steps below:

1. Lists > Search > Saved Searches > New.
2. Click on Case.
3. Set Criteria to narrow down results (optional).
4. See Results set up below:

max(to_char(substr({systemnotes.name},1,4000)))keep(dense_rank first order by{systemnotes.date})

min(to_char(substr({systemnotes.name},1,4000)))keep(dense_rank first order by{systemnotes.date})
5. Enter a Search Title. 
6. Click on Save & Run.


  1. I totally agree with this article and I just want to say that this article is a very nice and very informative article.I will make sure to be reading your blog more. NetSuite development

  2. This information is meaningful and magnificent which you have shared here about the netsuite. I am impressed by the details that you have shared in this post and It reveals how nicely you understand this subject. I would like to thanks for sharing this article here NetSuite suite commerce