- SAP Managed Tags:
Hello.
I'm struggling to implement an Action inside CAP.
What I want to do is simple SELECT, but it throws me an error...
Service definition
using { demo.callcenter as call } from '../db/schema';
service CallCenterService {
entity Inquiries as select from call.Inquiries
actions {
@sap.applicable.path: 'startEnabled'
action start();
};
}Service implementation
const cds = require('@sap/cds')
module.exports = async function () {
const { Inquiries } = cds.entities
this.on ('start', async (req)=> {
console.log('data: ' + req.data)
const id = req.params[0]
//Get createdAt
const createdAt = await SELECT.from(Inquiries).columns(['createdAt']).where({ID:id})
//Calculate hoursBeforeStart
const startedAt = Date.now()
const difference = startedAt - new Date(createdAt).getTime()
const hoursBefoerStart = Math.floor(difference/1000/60/60)
const n = await UPDATE(Inquiries).set({
status_code:'2',
startedAt: Date.now(),
hoursBefoerStart: hoursBefoerStart
}).where ({ID:id}).and({status_code:'1'})
n > 0 || req.error (404)
})
}The error is occurring at below statement.
const createdAt = await SELECT.from(Inquiries).columns(['createdAt']).where({ID:id})
Can anybody point out what's wrong with this statement?
Thanks,
Mio
| User | Count |
|---|---|
| 49 | |
| 6 | |
| 5 | |
| 5 | |
| 5 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.