** Changed in: aikiframework
Milestone: 0.9.0 => 0.9.1
--
You received this bug notification because you are a member of Aiki
Framework Admins, 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.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
