Queries with DYNAMIC Plain Text att's in their Criteria FAIL

[pureist]

The purpose of this topic is to formally report the exact bug as resolved from:
http://www.awareim.com/forum/viewtopic.php?f=2&t=9036

Description:

If a Query contains DYNAMIC Plain Text attributes in its Criteria then it doesn't work.

'DYNAMIC Plain Text attributes' means:

Plain Text attributes whose value has been set to also (as well as just typed in) be sourced via 'Dynamic choices':

'Use existing attribute values as choices'
'Choices are determined by a query..'

Please advise if a bug and will edit post and attach bsv.

[bartthefish]

We are busy developing an AwareIM module, which is going to be used by a large number of users to do perform various tasks. The AwareIM module is only a part of the overall system architecture.
In our scenario, we have an external database, and have a query that draws data from a SQL View within this Database. We need to have the AwareIM users select an object from this query and then do further processing on a related object within the AwareIM realm. The AwareIM object connected to this external view has plain text attributes which are used to filter the external view. The external view is a very complex object, and returns hundreds of thousands of records, and has no foreign keys to create reference attributes to AwareIM database. Therefore we use Dynamic Choices on these attributes in the search form. In Build 2144 These Dynamic Choices worked as expected, however in that version PICK FROM process didn't use the search form. In Build 2237 (Current version at this date) the PICK FROM process now respects the search form in the query, but does not load Dynamic Choices for Plain Text attributes any more.
I'm not sure if there is a version in between these (Cannot find where to download a specific build) where both of these works.
This is critical to our application.

[bartthefish]

If anyone knows where to access downloads of specific builds, I am happy to test those to see if one of the ones in between works.

[aware_support]

You need to send us the BSV that demonstrates the problem with the LATEST build only.

[bartthefish]

Attached is a sample bsv - I've simply added an object to the CRM Sample and the associated query. It is supposed to list the customer names in the dropdown. The test functions are in the admin perspective

[bartthefish]

Seems I forgot to press the add file button

[bartthefish]

Any feedback on this problem?