SELECT DISTINCT COMPANY_USERID_DISPLAYNAME."DISPLAYNAME" AS COMPANY_USERID_DISPLAYNAME_DISPL, COMPANY_USERID_DISPLAYNAME."USERID" AS COMPANY_USERID_DISPLAYNAME_USERI, EVENTSSUMMARY."USERID" AS EVENTSSUMMARY_USERID, EVENTSSUMMARY."FILEPATH" AS EVENTSSUMMARY_FILEPATH FROM "TSREPORTING"."EVENTSSUMMARY" EVENTSSUMMARY INNER JOIN "TSREPORTING"."COMPANY_USERID_DISPLAYNAME" COMPANY_USERID_DISPLAYNAME ON EVENTSSUMMARY."USERID" = COMPANY_USERID_DISPLAYNAME."USERID" WHERE FILEPATH IS NOT NULL AND UPPER(EVENTSSUMMARY."FILEPATH") LIKE '%.PAGE' ORDER BY COMPANY_USERID_DISPLAYNAME_DISPL DESC,EVENTSSUMMARY_FILEPATH
We would like to improve it, so in case no results are available, we would like the command to return "There was no data found for this particular search."
Any suggestions, by any chance?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.