What is QBE

[shankar]

Hi,
      what is the difference between setQBE ,setQuery  and setWhere



regards,
shankar 

[shankar]

BTT

[shankar]

Hi every one more than 270 views to my question. can any reply who knw the answer for this\


regards.

[matzi]

I'm not sure what setQuery is, but if you use setWhere you can pass in the where part of a sql-statement. Example: setWhere("where location in (select locations from location where status='SOMESTATUS')"). With setWhere you can build your own custom sql-sentence.

If you use setQBE it's like typing in a search from the GUI. The searchtype will be the same as specified in the db-configuration. If wonum is set as searctype=EXCAT and you do a setQBE("wonum", "1001") then Maximo builds a sql-setence for you that would be "where wonum='1001'".

[Ethen]

I am not very sure but setquery is used to set the whole query. I am not wrong then you even specify which colums you want.
set where only specifies the where clause.
and in qbe you specify the values of column as a filter criteria....

[Ethen]

and yeah, forgot to say full form of QBE is query by example.

[anks123]

setQBE refers to Query By Example ,its like when you click on a look up and you want to display values binded by specific condition .
Eg: you want all records to show up belonging to a particular REGION on WorkOrder application,it will display all records with this defined condition.

[Today]

• How to get list data whic... by kvnaresh [Today at 12:39:03 am]
• How to change an email ad... by kvnaresh [Today at 12:25:57 am]
• Difference between fixpac... by jithu1989 [Yesterday at 05:25:18 am]
• Maximo Programmer Require... by ravikorukonda [February 06, 2012, 05:59:58 pm]
• Demo Maximo 7.1 Online by hyubby [February 06, 2012, 11:05:43 am]
• Error loading the Object ... by G Jeevan [February 06, 2012, 07:21:36 am]
• plzz attribute in another... by Dileep Kumar [February 06, 2012, 07:02:09 am]
• Jpeg attachments within M... by zenagarfield [February 02, 2012, 02:02:53 pm]
• How to change senders ema... by zenagarfield [February 02, 2012, 10:28:06 am]
• Lead and Crew by G Jeevan [February 02, 2012, 07:08:45 am]