cancel
Showing results for 
Search instead for 
Did you mean: 
sreetha28
Nintex Newbie

List Lookup control with filter (multiple)

Jump to solution

For the Lookup control, I am trying to mention the view name(I have view with some filter condition), But after applying the view name it showing blank fields in Display, Edit forms. If you navigate to the View, it showing all the values. How to apply multiple filter conditions for lookup control. Can I use Java script with CAML query to achieve this functionality?

0 Kudos
Reply
12 Replies
Automation Master
Automation Master

Re: List Lookup control with filter (multiple)

Jump to solution

can you post an example what are you trying to achieve and configuration of lookup control?

it sounds to me you mention two problems - 1st one how to apply filter by a list view  and 2nd one hoe to apply multiple filters.

Reply
sreetha28
Nintex Newbie

Re: List Lookup control with filter (multiple)

Jump to solution

Find the below screen shot . 

0 Kudos
Reply
Automation Master
Automation Master

Re: List Lookup control with filter (multiple)

Jump to solution

what form version are on?

there were addressed several issues with filtering by source view in recent releases, especially if used together with filtering by value/control.

see release notes  

0 Kudos
Reply
sreetha28
Nintex Newbie

Re: List Lookup control with filter (multiple)

Jump to solution

See the version details

0 Kudos
Reply
Automation Master
Automation Master

Re: List Lookup control with filter (multiple)

Jump to solution

moreless the same with NF2010   Nintex Forms 2010 - Release Notes 

eg.

1.11.3.0: Validated an issue where views on a Lookup control may not filter. Fixed in a previous release. (84914)

1.11.2.0: Fixed an issue where a value in a List Lookup may not display when the selected item is not within the filtered source view (0)

0 Kudos
Reply
sreetha28
Nintex Newbie

Re: List Lookup control with filter (multiple)

Jump to solution

As  we are using  version 1.6.0.0 , how to fix this issue . I have to use java script to populate list Lookup control . 

How to fix this issue? Please suggest ?  

0 Kudos
Reply
Automation Master
Automation Master

Re: List Lookup control with filter (multiple)

Jump to solution

manipulating lookup's content with a javascript is a no way to go.

two possible workarounds come to my mind

- create a calculated column on the list out of all fields that you need to filter on. then in form compile a value that will filter items by that calculated column

- build a cascade of dropdowns which allow users to create step by step a filter similar to one you have modeled in view.

0 Kudos
Reply
sreetha28
Nintex Newbie

Re: List Lookup control with filter (multiple)

Jump to solution

In my scenario there are three levels , Based on A ,B should be filtered and based on B, C should be filtered with Status is equal to Active ( 2 Conditions for display C - filter based on B and status is equal to Active).


create a calculated column on the list out of all fields that you need to filter on. then in form compile a value that will filter items by that calculated column-Could you please guide me  - how to implement the below approach . 

build a cascade of dropdowns which allow users to create step by step a filter similar to one you have modeled in view.--  This is the second  approach : This what we implemented now , what is the difference ? what I am missing.?

Thank you so much .

0 Kudos
Reply
Automation Master
Automation Master

Re: List Lookup control with filter (multiple)

Jump to solution

Could you please guide me  - how to implement the below approach

have a look eg.  on this thread - Nintex Forms - lookup with 2 filters 

to compile a value for the filter it uses javascript, but usually it's not necessary. simple calculated value control should be enough.

This is the second  approach : This what we implemented now , what is the difference ? what I am missing

currently with view filter you have defined one filter with 3 conditions, for each level one.

with cascading lookups you would let user first select a value for level1, then level2 list would be automatically filtered just to those items that belongs to selected level1. once a user selects a value from filtered level2 list, the same applies for level3, and so on for further levels if needed.

have a look on eg following examples

How to filter a look up column in nintex forms 

 

if you searched the forum I believe you would find several good examples for both appraches.

0 Kudos
Reply