With javascript: How to delete a one specific record from the database

[ahmet Karamanli]

Hi,
I want to delete a one row in the database with javascript: how do I do that?

As example I use:
Products_update.execute({body: {where: {ItemIDToUpdate: "8712566378614"}, operations: {$set: {ColumnX: varX} } } });

Where I can set a value in a cloumn X : "ColumnX": at row with ItemIDToUpdate equal to: 8712566378614,

The same question again now for deletion:
I want to delete a row with arow element "ItemIDToDelete equal to "8712566378614"

Can I use:

Code: Select all

Products_delete.execute({body: {where: {ItemIDToDelete: "8712566378614"}, operations: {$delete: {ColumnX: varX} }  } }); 

????

and same question if I want to ADD a Item, can I use :

Code: Select all

Products_create.execute({body: {where: {ItemIDToCreate: "8712566378614"}, operations: {$set: {ColumnX: varX} }  } }); 

Thanks,

[Serhii Kulibaba]

Hello Ahmet,

Please look at this documentation: https://devcenter.appery.io/documenta...

[ahmet Karamanli]

Hi Sergiy,

So far I can see you can't use CURL commands in javascript is that correct?.

I'm looking for javascript solution.

[Illya Stepanov]

Execute your delete service using JavaScript and pass object id with it -- https://devcenter.appery.io/documenta...

[Duane Roderick]

Every answer for support redirects back to the appery site, but no examples are provided. This is frustrating.

[Illya Stepanov]

To invoke any service directly from JavaScript, use:

precode
serviceInstanceName.execute({});/code/pre

[Duane Roderick]

Thanks, but this doesn't answer how to delete a record on the gui.

[Serhii Kulibaba]

Please look at this detailed example how to send parameters to the service with JS code: https://devcenter2.appery.io/document...

Could you clarify what you have tried and what exactly does not work?

[saurabh8122815]

Hi Duane,

For delete record,you can use other solution,
like use server code service for delete record in database.

Regards.