What's new in Customer Journeys?

Connect and learn more!
How to use aggregate and groupby clause for reporting in VBCS. — Cloud Customer Connect
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

How to use aggregate and groupby clause for reporting in VBCS.

Received Response
38
Views
4
Comments
edited Nov 15, 2018 5:29AM in Visual Builder 4 comments

Summary

How to use aggregate and groupby clause for reporting in VBCS.

Content

How to use aggregate and group by clause for reporting in VBCS.

Business Scenario:
We have below mentioned objects in one to many relationship:

Table A:

AID (Primary Key)

Name

Type

Comments

1

Test

Business

 -

2

 -

 -

 -

Table B  (Contains list of all questions asked): AID references Table A primary Key

BID (Primary Key)

AID (Foreign Key)

Question

Title

Comments

10

1

Java

Do you know Java

 -

11

1

Driving

Do you know driving

 -

Table C (Contains answers for each of the questions asked by different users): BID references Table B primary key

CID (Primary Key)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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