Skip to main content
C
CBaker1-Visitor
1-Visitor
May 26, 2011
Question

Query Builder Criteria Confusion

  • May 26, 2011
  • 2 replies
  • 909 views

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

2 replies

J
jessh12-Amethyst
12-Amethyst
May 26, 2011
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

C
CBaker1-VisitorAuthor
1-Visitor
May 26, 2011

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

Terms & ConditionsAccessibility statement