Service Manager / Service Center Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

Fill Button issue

SOLVED
Go to Solution
Valued Contributor

Fill Button issue

Hello Experts 

 

I am facing an issue with the fill button in 9.32.0016

 

Scenario:

 

1. I have created a field "project.id" in both incidents and category dbdicts

2. In the interaction form, when for eg:"ProjectA" is selected I want the category to filter only that belong to ProjectA.

3.  Query in incidents link in category line - "$query+=" and project.id=project.id in $File"

4. WHen I click Fill button it shows all categories but when I tested using the "Third Button", it shows only the categories that belong to "projectA"

5. I would like to know how I can make the fill button functiion the same way as third button?

 

Any suggestions will be much appreciated.

 

Abhinav

Kindly assign kudos if the post is helpful!
10 REPLIES
Advisor

Re: Fill Button issue

Hello, can you try:

 

if (not null(project.id in $File) and option()=8) then ($query=$query+" and project.id=project.id in $File")

 

 

Advisor

Re: Fill Button issue

Better with option()=9 ;-)

option()=8 -->find

option()=9 -->fill

Honored Contributor [Founder]

Re: Fill Button issue

[ Edited ]

Hi,

If you added the link line then it must work.

You have to add below line at last while keeping the current expression category link line,
if (not null(project.id in $File)) then ($query+=" and project.id=project.id in $File")

Check the case of your field values and project id values in category field.

Post your link line snap shot.


hth,

____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Valued Contributor

Re: Fill Button issue

Hello Both 

 

I tried the above steps, but still the fill is not functioning. Attaching the Category link line of incidents link.

 

Abhinav

Kindly assign kudos if the post is helpful!
Honored Contributor [Founder]

Re: Fill Button issue

Hi,

 

Do you only use the master link record, or do you also have a form specific link record for your open Interaction form?

 

Audrey

Valued Contributor

Re: Fill Button issue

Hi Audrey

 

I even tried the same query in SD.open.interaction link as well.

 

Abhinav

Kindly assign kudos if the post is helpful!
Highlighted
Honored Contributor [Founder]

Re: Fill Button issue

Hi Abhinav,

 

In looking at your link line, it doesn't look like your $query is being built correctly.  You don't seem to have the initial query.  For example, in an OOB 9.30 environment, the Expression in the category link line is as follows:

 

$fill.recurse=true

$query="active=true and name~=\"tbd\" and name~=\"example\" and (name isin $G.auth.categories or name=\"change\")"

if (not (null(category in $File))) then $query+=(" and name#\""+category in $File+"\"")

 

It seems that you should start with something like that and perhaps add a line:

 

if (not  (null(project.id in $File))) then $query+=" and project.id=project.id in $File"

 

Audrey

Valued Contributor

Re: Fill Button issue

Hi Audrey

Should I add it in incidents link or SD.open.interaction?
Kindly assign kudos if the post is helpful!
Honored Contributor [Founder]

Re: Fill Button issue

[ Edited ]

Hi,

As per your snap shot ther must not be second line and yes it will give all category as no query in you link line.
So replace second line with

if (not (null(category in $File))) then $query+=(" and name#\""+category in $File+"\"")



hth,

____________________________________
Assign Kudo, if found post useful and mark it accepted if solves the issue.
Valued Contributor

Re: Fill Button issue

Hello Audrey

You query seemed to work, I had to give in both ethe master and form specific link.

But I am facing another issue now, it is not populating the same way for the below fields

1. affected.item and vendor (in probsummary)

Any pointers will be of help.

Abhinav
Kindly assign kudos if the post is helpful!