need you to try this on the new aiki development builds and confirm what is and isn't working.
-- You received this bug notification because you are a member of Aiki Framework Developers, which is subscribed to aikiframework. https://bugs.launchpad.net/bugs/726311 Title: Unable to use other fields or global variables inside of sql within an aiki form Status in Aiki Framework: Confirmed Bug description: As I've been experimenting with what's possible in aiki forms, as far as inserting values from another table into an aiki form of type 'auto filled field', I've run into several stumbling points when using value:(sql((select something from something_else where id = [userid]||[-[something]-]))sql) * I've been able to successfully insert data into the table in cases where ** The conditional is comparing the url ( where id = (!(1)!) ) ** The conditional is comparing a static value ( where id = 1000 ) *I've been unable to successfully insert data into the table in cases where ** The conditional is comparing a global variable ( where id = [userid] ) ** The conditional is comparing a field from the form itself ( where id = [sender_id] ) So, currently, the only option I have, if I want to grab some value from a different table & auto-insert it into an autofield in an aiki form, is to put a value to compare in the url link. This creates messy urls & would be much more usable if I could use global variables & other fields in the form to compare in the sql. To manage notifications about this bug go to: https://bugs.launchpad.net/aikiframework/+bug/726311/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~aikiframework-devel Post to : aikiframework-devel@lists.launchpad.net Unsubscribe : https://launchpad.net/~aikiframework-devel More help : https://help.launchpad.net/ListHelp
