Query Builder Criteria Confusion

[CBaker]

Hello All,

I've noticed that when working with query builder, there are some attributes that I'd like to use in the criteria, but aren't there. For example, I'd like to be able to run a query that gathers some records based on an entered name. The Full Name value from the User table would work (I think), but when I look to the User table for criteria to add, Full Name isn't there. Could someone please offer some clarification as to why that is? Thanks in advance.

- CB

[jessh]

That's documented in the QueryBuilder help, I believe.

QueryBuilder's criteria are SQL criteria -- and thus can only operate
against attributes correspond to database columns. These have a green
triangle in the other view vs. derived attributes that have a yellow circle.

In general for efficiency you're better off staying away from derived
attributes as much as possible in any case -- since they are obtained by
selecting all columns from the table, creating a full Persistable (e.g.
WTPart) object, and calling a corresponding method on that object.

Many derived attributes can actually be found as non-derived attributes
if you look a bit further (e.g. joining in additional tables as needed).

--
Jess Holle

[CBaker]

I was wondering what the significance was between the different icons. That explains everything, thanks for the help!