Adding filter of custom table's filed to target table

[Tamil4]

Hi Everyone!

Am having a custom table, in that I have a field called condition which is Conditions type field.

I have to get the value of this condition filed and use that as a filter in my target table through script.

For Example: The custom table's condition field having company=ACME Africa, then I should use the same in incident table filter.

Below is the script I wrote. Not sure how far it is correct.

1. var Script = new GlideRecord('u_integration_configuration'); -> this is the custom table name

2. Script.addQuery('u_table_name', current.sys_class_name);
3. Script.addQuery('u_active', true);
4. Script.query();
5. while (Script.next()) {
6. //var fliterString = Script.getValue('u_condition');
7. var Rec = new GlideRecord(Script.u_table_name);
8. Rec.addEncodedQuery(Script.u_condition);
9. Rec.query();
10. if (Rec.next()) {

In the 8th line I have to use the condition field's value of custom table.

Please help me to achieve this.

Thanks in advance.

Thanks,

Tamil

[Tamil4]

Hi Anil,

Added the above line after while but it is still same.

Tamil

[Anil Lande]

I don't see any issue with script.

Make sure to use correct name of field, it may not be u_condition.

[Tamil4]

Anil,

 Filed name is u_condition only. anything other than this I should check.

[Ankur Bawiskar]

@Tamil4 

that line should be inside the while

gs.info('Condition' + Sc.getEncodedQuery());

[Tamil4]

Hi Ankur,

Put that line inside while but it is not evening print the string in log.

And additionally I tried to print the value what I am getting from that field that is also blank only.

Tamil