Question on Query service

[Former Member]

Hi,

Can I use the Query service direclty, to retrive data from two or more table by joining them and with out having a persistant objects for the above said tables.

If this is possible please let me know how to do that.

Thanks,

Ram

[matt]

In short. No.

matt

[Former Member]

Hi Matt,

Thanks for your answer.

Matt I request you to clarify me the following.

First we creating the query by using the following methods

QUERY_MANAGER = CL_OS_SYSTEM=>GET_QUERY_MANAGER( ).

QUERY = QUERY_MANAGER->CREATE_QUERY

( I_FILTER = )

and for the parameter I_FILTER we are passing the values.

Now i have the query with me, can't i use this query any where else except for a persistant object...? as it is independent of the persistant object.

Thanks,

Bharani kumar

[Former Member]

Hi Matt,

Is there any other way to create a Query except IF_OS_CA_PERSISTENCY~GET_PERSISTENT_BY_QUERY( ).

Thanks,

Bharani kumar

[matt]

I think you have a fundamental misunderstanding. The query service is a bunch of classes and interfaces that provide services to the persistence framework.

Look at this

These Object Services include:

· A Persistence Service, used to manage persistent objects in the database

· A Transaction Service, used to update persistent objects

· A Query Service, used to search for and load persistent objects.

matt