Public bug reported:
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.
** Affects: aikiframework
Importance: Undecided
Status: New
--
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:
New
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.
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework.admins
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework.admins
More help : https://help.launchpad.net/ListHelp
