Aggregate Card

Description:

Aggregate Card

Aggregate Card is used to show the Aggregates of data.E.g:SUM,COUNT,etc..

Allowed Parent Components:

1. Card Body

2. Col

3. Drag Source Wrapper

4. Drop Target Wrapper

5. Horizontal Section

6. Page

7. Scroll Layout

8. Vertical Section

Allowed Child Components:

1. Card Wrapper

2. Col

3. Popover

4. Pulse

5. Row

6. Switch

7. Trigger Before Render

Properties

➤ Render As Row

Check this to get the cards in row.

Allowed Values: Yes/No

➤ Hide No Data Placeholder

Check this to hide the data displayed when no data found.

Allowed Values: Yes/No

➤ No Data Icon

Select an icon to display when no data found.

Allowed Values: Icon List

➤ No Data Text1

Provide a text to display as title when no data found.

Allowed Values: Free text field

➤ No Data Text2

Provide a text to display as sub title when no data found.

Allowed Values: Free text field

➤ Icon

Select an icon for button when no data found.

Allowed Values: Icon List

➤ Text

Provide a text for button when no data found.

Allowed Values: Free text field

➤ onClick

Select or enter the action need to be performed on button click.

Allowed Values: Controller Function

➤ Color

Select a color or enter the custom class to change the color of the button.

Allowed Values: Select a color or enter the custom class to change the color of the button.

➤ Use Existing Data Source

Choose this prop if you want to reuse a Data Source that was defined on some other component on this page or any of the parent abstract pages.

Allowed Values: Yes/No

➤ Data Source

Select a datasource from the list.

Allowed Values: Select a datasource from the list.

➤ Data Source Alias

Allowed Values: Free text field

➤ Default Where Clause

Allowed Values: Free text field

➤ Max Rows

Allowed Values: Any number value

➤ Order By Clause

e.g. #firstAttr#, #secondAttr# DESC

Allowed Values: Free text field

➤ Auto Query

Check this property to query the selected datasource on component render.

Allowed Values: Yes/No

➤ Execute Count SQL

Check this to execute count SQL to get the total number of rows in the database on a query. You can get this value by using the expression: #{DataStore.totalLength}

Allowed Values: Yes/No

➤ Execute Distinct SQL

Check this to execute distinct SQL to get the total number of distinct rows in the database on a query.

Allowed Values: Yes/No

➤ Key Attribute

Select a attribute to perform groupByClause in data.

Allowed Values: Select a attribute to perform groupByClause in data.

➤ Value Attribute

It is a column through which you can get the data from DataSource.

Allowed Values: It is a column through which you can get the data from DataSource.

➤ Function

Select a function to do arithmetic operations on data.

Allowed Values:

1. SUM

2. COUNT

3. AVG

4. MAX

5. MIN

6. COUNT(DISTINCT)