Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Business objects and equivalent sql minus/intersect/union/union all

in Visual Builder 2 comments

Summary:

Business objects and equivalent sql minus/intersect/union/union all

Content (required):

Hi all, I would thank any help with the following.

Business objects in VB are great to CRUD operations, but I cannot find an easy way to apply basic sql operations, as said in Question.

Example :

I have table 1 and 2 with same structure (employees). I would like to know for example the common employees in both tables (intersect operation).

Has anyone some workaround for this?

Currently the only option I have worked out is looping in resultsets, which is time consuming and sometimes not feasible.

Business Objects Equivalent to DB-views would be an option, but I have not found doc. about this.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!