Filtering related predecessors in Task list

  • 13 June 2019
  • 1 reply
  • 2 views

Badge +1

Hi all,

I have problems in filtering the predecessor lookup field in my task list form.

 

I have added a column called "ECR-ID" to my task list. This column is of type "Number" without decimals.

 

All tasks that belong together do have the same value in this column.

 

At the time when I open the NewForm.aspx I have a value at hand that is being transmitted via GET variable (e.g. &ECR_rel=18).

 

Now I want to use the 'fn-GetQueryString()' function from Nintex in order to filter the predecessor lookup field.

 

So in the settings for the predecessor lookup field I have set the following filtering:

 

Filter available selections: By a specific value

Where field: ECR-ID

Filtered by value: fn-GetQueryString(ECR_rel)

 

By doing it this way I expected to get all entries that have the value "18" in the column "ECR-ID" but the lookup field remains empty.

 

Does anyone have an idea why this isn't working?

 

Any help is much appreciated!

 

Best Regards,
Dirk


1 reply

Badge +1
Hi!

Today I was able to solve the problem.

Initially I have filled the "Where field" by using the "Insert Reference" function but this turned out to be the root cause for my problem.

As soon I have written the column name into the "Where field" by hand the filter was working fine.

Reply