Filters for Big Object

Filters on Big Object are based on the index fields. Big Object Utility lets you filter records easily using the UI provided in the list view component.

How does the filter work on the index fields?

A filter is always applied from left to right, using the primary index field as first. In the following screenshot, Account__c is the primary index and Customer_Id__c is the secondary index field so when filtering we cannot include the secondary index field without the primary index field. 

Common issues:

Q) Why != (Not Equal To) operator is missing?

A) Data retrieval is based on the index field and using != operator doesn't exactly match any index value. 

Q) Filters may not have any gaps within the composite key?

A) This error occurs when you are trying to filter without primary index field. 

Tab for Big Objects

Creating a tab for Big Objects is now possible using my AppExchange app Big Object Utility. I have created a LWC component called big-object-list-view which helps in creating a tab for Big Object. The component contains the UI from which you can view Big Object records as a list view. The component also helps in filtering the records.

Step 1:

Install Big Object Utility app from AppExchange.

Step 2:

Use VS Code or any other tool to create a custom LWC component. In the HTML file use the <cloudbat-big-object-list-view></cloudbat-big-object-list-view> component from the manage package.

Enter the API name of the Big Object in object-api attribute and Field API names in fields-api-list attribute. For example, if the Big Object API name is Archived_Contact__b.

In the meta.xml file, enter true in <isExposed> tag and lightning__tab in <target> tag.

 

Leave js file as it is. 

Deploy the component to your org. Github link in case you want to refer to the component.

Step 3:

In order to use Big Object Utility manage package LWC component in your component, We need to enable Lightning Web Security.

Go to Setup -> Security -> Session Setting and enable Use Lightning Web Security for Lightning web components check box.

Step 4:

In this step, we create a lightning tab.

 Go to Setup -> User Interface -> Tabs and click on New button.

Select the lightning component you have created in Step1, enter the label, name, and style. Click on the Next button. Select the visibility based on your requirement and click on the Save button.

You should be able to search for the tab from the App menu.

Please do leave your lovely reviews on the AppExchange - Big Object Utility 

Common issues:

Q) Attempting to reference cross-namespace module cloudbat-bigObjectListView.

A) To resolve this issue enable Lightning Web Security.