Share
ReportIs there a way to order by with smartlist builder. I wont to order by two colums.
Ex. if I was writing it in sql
order by empid_i, min(effectivedate_i)
*This post is locked for comments
You’re offline. This is a read only version of the page.
Is there a way to order by with smartlist builder. I wont to order by two colums.
Ex. if I was writing it in sql
order by empid_i, min(effectivedate_i)
*This post is locked for comments
I'm not sure exactly what the expected outcome of your smartlist is but if GOTO navigation is not required and all you need is a list of data for reporting purposes then I'd recommend building a view in SQL and hooking it up to a spreadsheet so users can refresh it.
We very rarely build smartlists or use them for that matter. Our users are more accustomed to working in Excel so we build views almost 99% of the time and sometimes we tie EONE's SmartConnect to it for seamless integration direct from the view.
In smartlistbuilder under options there is a option called display sql. Is there a way to modify that? If so I could add my order by at the end of the sql code.
I think Smartlist Builder doesn't allow for pre-designated ORDER BY in the SQL statements.
#1
André Arnaud de Cal...
292,492
Super User 2025 Season 1
#2
Martin Dráb
231,305
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
