Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Advance Reference Qualifier on Dictionary Override | Query

chatsaurav19
Tera Contributor

Hi All,

 

I have a custom table with two fields :::

chatsaurav19_0-1724329170009.png

 

backend names as - service_offering and assignment_group

 

I have a requirement where on populating the SO, only those assignment groups should show up ( when I click the lookup icon ) which has a specific group_type.

 

chatsaurav19_1-1724329391661.png

 

I have tried writing a Advance Qualifier on Dictionary Override of 'Assignment Group' table but somehow it is not working. 

 

chatsaurav19_2-1724329533608.png

 

chatsaurav19_3-1724329647537.png

 

Can someone help ?

 

Regards,

Saurabh

 

1 ACCEPTED SOLUTION

Sandeep Rajput
Tera Patron

@chatsaurav19 I spotted two issues in your code.

1. update your method to accept an argument

getOfferingAssignmentGroup: function(idOffering)

2. Comment the following line in your code.

//var idOffering = this.getParameter(‘offering_id’);

 

Replace the last line with following.

return 'sys_idIN'+JSON.stringify(arr);

 

Please don't forget to mark the response helpful and accepted solution if it manages to address your issue.

View solution in original post

3 REPLIES 3

Sandeep Rajput
Tera Patron

@chatsaurav19 I spotted two issues in your code.

1. update your method to accept an argument

getOfferingAssignmentGroup: function(idOffering)

2. Comment the following line in your code.

//var idOffering = this.getParameter(‘offering_id’);

 

Replace the last line with following.

return 'sys_idIN'+JSON.stringify(arr);

 

Please don't forget to mark the response helpful and accepted solution if it manages to address your issue.

Hi @Sandeep ,

 

I tried but this time when I click on the lookup icon it is giving me empty results from groups table

 

chatsaurav19_0-1724332647177.png

chatsaurav19_1-1724332684188.png

 

Regards,

Saurabh

Just a small twist and it worked. Marked as yellow tag

 

chatsaurav19_0-1724915597508.png