>
> Without the ability to post data to reference fields it's a problem to
> achieve it. just posting the reference data as strings won't allow me to
> make these filters, unless I will insert them into tables after posting to
> the tests results table. (I think).
>
Keep in mind, a reference field references an entire record in another
table, not just a particular string field in that table. In general, the
referenced table may not even include a string field that contains unique
values, so you couldn't reference a particular record simply by specifying
a single string.
I'm not sure I completely follow your data model, but for example, is the
f_platform field a reference to the db.t_types table (which itself contains
an f_platform_name field)? Is it the case that you want users to be able to
specify an f_platform_name string and have that converted to the
appropriate record ID of the t_types table so the ID can be stored in the
f_platform field? If so, you just need to write the code to do that:
post_params['f_platform'] = db(db.t_types.f_platform_name ==
post_params['f_platform']).select(db.t_types.
id).first().id
That will use the string value of f_platform to look up the record ID in
db.t_types, and then change post_params['f_platform'] to that record ID.
You could do something similar for any other fields that need to be looked
up/converted.
Anthony
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
