Dynamic Filtering of a Smart Dropdown Based on Populated Field in Confiforms

[Chris Iacovelli]

i have a source page (P1) with a confiform that contains 3 fields, archCode, archDesc, and archType.

• archCode is a unique code to identify the entry.
• archDesc is the description.
• archType is the flag to identify if it is a major item (1), minor item (2), or trivial item (3).

the items stored in this table are numerically encoded to capture the relationship of major to minor to trivial items:

• archCode XX.01 for a major item
• archCode XX.01.01 for a minor item
• archCode XX.01.01.01 for a trivial item

on a differing page (P2), i have 2 smart dropdowns (archCodeMajor and archCodeMinor) which use the items from P1.

• the first drop down filters the list presented to all entries where the archType is major (1), e.g., CD.01 (Apply filter on choices is "archType:1").
• the second drop down intends to filter the list presented to all entries where the archType is minor (2) and the archCode is arcCodeMajor with the literal ".*" appended to the end of the entered value, e.g., CD.01.* (Apply filter on choices is "archCodeMinor:[entry.arcCodeMajor.archCode.append(.*)] AND archType:2").

first drop down works without issue.

second drop down returns a message stating there is no matches. the portion of the filter [entry.arcCodeMajor.archCode.append(.*)] renders as expected as i dropped the value into a readonly field for inspection.

when i removed the .archCode portion i am presented with a list of all minor items (2).

not sure what i am doing wrong here. 

[Alex Medved _ConfiForms_ · Accepted solution]

You are applying the filter on the P1 records, as this is wher the data for the archCodeMinor field is coming from

So, it should be something like this, if I understand you correctly

archCode:[entry.arcCodeMajor.archCode.append(.*)] AND archType:2

[Chris Iacovelli]

@Alex Medved _ConfiForms_ - yes, filtering against the entries in P1.

i have done that in my encoding (even tried copy and paste of your snippet above):

archCode:[entry.arcCodeMajor.archCode.append(.*)] AND archType:2

and get the following response:

I'll keep plugging away on this.

[Alex Medved _ConfiForms_]

It is what I have said, but there was a typo in your expression that I have copied... so, this is what it should be

archCode:[entry.archCodeMajor.archCode.append(.*)] AND archType:2

 

[Chris Iacovelli]

@Alex Medved _ConfiForms_ thank you! i was staring at this too long to see the typo. in addition, i was filtering on the form display and not in the form definition.