cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

Query Builder Criteria Confusion

CBaker
1-Visitor

Query Builder Criteria Confusion

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 2
jessh
12-Amethyst
(To:CBaker)

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
1-Visitor
(To:CBaker)

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

Announcements


Top Tags