SuiteQL Query Library

Employees: With Edit, View, Email URLs

Returns all employees, with edit, view, and email URLs in the results.

-- Contributor: Tim Dietrich (timdietrich@me.com)
SELECT
	'<a href="/app/common/entity/employee.nl?id=' || Employee.ID || '&e=T" target="_new">Edit</a>' 
	|| ' | ' ||
	'<a href="/app/common/entity/employee.nl?id=' || Employee.ID || '" target="_new">View</a>' 
	AS Options,	
	LastName,
	FirstName,
	Title,
	'<a href="mailto:' || Email ||'">' || Email || '</a>' AS Email
FROM
	Employee
ORDER BY
	LastName,
	FirstName

← Back to Query Library