I am working on a search screen. This search screen has more than 10 fields the

erickp over 9 years ago

I am working on a search screen. This search screen has more than 10 fields the user can search by. After making a search, I want to populate the data on a grid. The search results consist of a very complex sql query with many joins. I am wanting to pass all my search criteria to a store procedure, execute the query and return the results to populate the grid. Is this possible? If yes, in what format do I need to return the results and how?

Discussion posts and replies are publicly visible

Parents

0 Josh
Certified Lead Developer
over 9 years ago

I'm not sure if this will apply to Sybase but I ran into an issue with aliases with Appian (7.10) and mysql when "useOldAliasMetadataBehavior" was not set correctly. The solution was to configure the jdbc connection like so: jdbc:mysql://server:3306/appian_primary?useOldAliasMetadataBehavior=true
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Josh
Certified Lead Developer
over 9 years ago

I'm not sure if this will apply to Sybase but I ran into an issue with aliases with Appian (7.10) and mysql when "useOldAliasMetadataBehavior" was not set correctly. The solution was to configure the jdbc connection like so: jdbc:mysql://server:3306/appian_primary?useOldAliasMetadataBehavior=true
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data