- 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
Accepted Solutions (1)
It was my namespace that was causing the issue: demo.callcenter.
ensureUnlocalized method compares the localized table name with below localized prefixes.
localized.de, localize.fr ....
In my case, localized table name is localized.demo.callcenter.Inquiries and it matches with localized.de, so the method truncates the table name, resulting the error.
I changed the namespace to zdemo.callcenter and now it is working fine.
It seems we cannot use namespaces starting with 'de', 'fr', or any other language keys.
Answers (1)
| User | Count |
|---|---|
| 73 | |
| 21 | |
| 8 | |
| 7 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.