So far I have not found a better/shorter way to check if a table entry exists than the following:
1 2 | let exists = await SELECT(1).from(Books,201)return (exists .length > 0) ? true : false |
Found here: https://cap.cloud.sap/docs/node.js/cds-tx#cds-tx-ctx-fn
To check if a record exists, you can simply use the HEAD query.
“HEAD is almost identical to GET, but without the response body.” (https://www.w3schools.com/tags/ref_httpmethods.asp)
Unfortunately, there is no shortcut in CAP for a HEAD query, so simply use send with method HEAD.
1 2 3 4 5 6 7 8 | sfsfSrv = await cds.connect.to('sfsf')try { await sfsfSrv.send('HEAD', `/User('${userId}')`) return true // status 200} catch (err) { return false // status 404} |
1 2 3 4 | " Check if class exists and is activatedIF cl_esh_ca_check=>is_active_class( 'ZCL_MYCLASS' ) = abap_true. WRITE: 'Class exists'.ENDIF. |
