delete records based on condition

[venishawakodika]

Hi All,

I have created 2 tables, say A & B

Table A stores 'project_code;

Table B refers to this project_code & stores other values related to it like project amount & other values.

My requirement is when i delete that project code record from table A, its corresponding entries in table B should get deleted.

I am writing a 'before-delete' BR on table A(after delete does not fetch project code), it doesn't work.

Here is the code:

(function executeRule(current, previous /*null when async*/) {

  // Add your code here

  var bill = new GlideRecord("u_project_billing");

  gs.log('test'+current.u_project_code);

  bill.query();

  while (bill.next()) {

  if(bill.get('u_project_code',current.u_project_code))  

  {

  //bill.deleteMultiple();

  bill.deleteRecord();

  gs.log('test done');

  }

  }

})(current, previous);

Any help on this please.

[venishawakodika]

It worked perfetcly, Thanks for your help Harel

[oharel]

Excellent.

Actually, I just helped. goranlundqvist's answer is the correct one

[gana1]

Hi All,

I think this is the right conversation chain where In can put up one of my questions related to this. I need to create a bbutton/UI action through which I should be able to select multiple records from User table/custom table and populate the records back to the form. The uiser form/custom form will be opened as a dialog window.   So as shown below like delete option available, I want to have one more button, "OK". So when users select multiple records and click "OK", the records should be populated back to the catalog form/any other form. Hope question is not confusing!

[oharel]

After checking the records, you can click on the horizontal lines and choose "Update Selected" where you get to a template form. Once you fill in the required data, you can save it and it will update the records.

Does this help you?

harel

[gana1]

Hi,

It doesn't seem to help for me. Basically its a glide dialog window . Users should be able to select multiple items and the selected records should be populated back to the original form upon clicking on something.

Regards

Ganapati