Syntax for flow designer record lookup script

[Community Alums]

Hi , 

I want the below encoded query to be added in record lookup for my flow designer.

What is the syntax for adding encodedquery in lookup record -

[Community Alums]

Hi Raghu , 

not working like this.

Can we write script for lookup records , if yes , what should be the syntax.

Thanks,

Gaurav Tyagi

[Ankur Bawiskar]

@gaurav tygai 

I already shared above

sharing again here

"active=true^due_date<javascript:gs.beginningOfToday()^assigned_toISNOTEMPTY^parent.closed_by.managerSAMEASassigned_to"

Regards
Ankur

[Community Alums]

Hi Ankur ,the above script worked but after adding return to it it should be -

return "query" ;

Marking your answer as correct.

Thanks,

Gaurav Tyagi

[Ankur Bawiskar · Accepted solution]

I am updating it

return

"active=true^due_date<javascript:gs.beginningOfToday()^assigned_toISNOTEMPTY^parent.closed_by.managerSAMEASassigned_to"

Please mark my response as correct

Regards
Ankur

[Raghu Ram Y]

Hi @Gaurav Tyagi 

Create glide record like below code... and change your encoded query according to urs and try it.

var gr = new GlideRecord('sc_task');
gr.addEnocdedQuery('active=true^short_descriptionSTARTSWITHtest');
gr.query();
while(gr.next())
{
return gr;
}

I hope it definetly helps you, please mark my response as correct and helpful.