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
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
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