Hey everyone, I need to get all time-entries belo...
# suitescript
z
Hey everyone, I need to get all time-entries belonging to a selected employee, so far I was able to retrieve all timesheets for that employee, but this just gives me the start- and enddate of the week and the totalHours of the week, but what I need is to get the time-entries day by day, is this possible cause I tried this search
Copy code
search.create({
	type: "timeentry",
    filters: [["employee","anyof", id]],
	columns: [
		search.createColumn({
			name: "date",
			sort: search.Sort.ASC,
			label: "Date"
		}),
		search.createColumn({name: "employee", label: "Employee"}),
		search.createColumn({name: "customer", label: "Customer"}),
		search.createColumn({name: "item", label: "Item"}),
		search.createColumn({name: "hours", label: "Duration"}),
		search.createColumn({name: "timesheet", label: "Timesheet"}),
		search.createColumn({name: "starttime", label: "Start Time"}),
		search.createColumn({name: "endtime", label: "End Time"}),
		search.createColumn({name: "type", label: "Type"})
	]
}).run().getRange({ start: 0, end: 1000 });
and it shows me this notification when running it, do you guys have any idea what I'm doing wrong here?
b
do a timebill search
👍 1
alternatively use the time join (id is timebill) from your timesheet search
z
I'll try it thanks for your reply!