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:

Formulas:
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.
on

2 comments:

  1. ThinkcommerceJune 20, 2020 at 2:28 AM

    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

    ReplyDelete
  2. ThinkcommerceJuly 22, 2020 at 1:19 PM

    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

    ReplyDelete

Subscribe to: Post Comments (Atom)