Questions tagged [datatable]

An HTML table that is defined by iterating over a set of data, displaying information about one item of data per row.

Filter by
Sorted by
Tagged with
7
votes
3answers
10k views

Is it possible to call a Lightning Component from a Javascript function?

I am using a jQuery Datatable inside one of my lightning components, and would like to call another lightning component on click of one of the fields in the Datatable. On click of the "edit" field ...
7
votes
0answers
555 views

Lightning Datatable Action Violates Content Security Policy directive

I'm using Lightning Datatable with Static Actions and following the guide in Developer Salesforce.com Lightning Datatable component guide but getting the following error (seen in the Chrome developer ...
6
votes
2answers
3k views

Used jQuery datatable for pagination and got this issue: Collection size 1,378 exceeds maximum size of 1,000

I have implemented client side pagination using jQuery datatable for pagination and got this issue: Collection size 1,378 exceeds maximum size of 1,000. This resultant list of records is from a ...
6
votes
1answer
3k views

Query for Emails sent in the past month, unsubscribes opens, clicks for each

Ok this seems like it should be a fairly simple query, but I'm not getting anywhere. What makes it worse is that all the data is stored in several tables. I basically need to recreate the monthly ...
5
votes
2answers
4k views

Is there a way to filter rows in an Apex:DataTable?

I've been playing around with an Apex:DataTable in the past few days and would ideally like to find a way to filter out rows from the table: Without using a controller and SOQL query to feed in a ...
5
votes
2answers
2k views

Displaying more rows

I have a simple table for displaying users... <apex:page standardController="User" recordSetVar="Users" tabStyle="User"> <apex:pageBlock > <apex:pageBlockSection title="Today’s ...
5
votes
1answer
3k views

LWC - Extended lightning datatable with picklist is not working

I have use case where i need to show the values in the picklist format in lightning-datatable for which i am extending the lightning-datatable component.The datatable shows a drop-down box but i am ...
5
votes
1answer
2k views

LWC is it Possible to Load the JQuery Plugin Datatables in a Lightning Web Component?

Edit: Solved! I'm struggling to load the infamous datatables.net jQuery plugin into my Lightning Web Component. Even using the most basic example, I haven't had any luck. It seems like there are a ...
5
votes
1answer
6k views

Lightning Datatable Picklist and Lookup Work Around [duplicate]

I am aware that lightning:datatable does not support picklists. The approved attributes are: action boolean button button-icon currency date date-local email location number percent phone ...
5
votes
1answer
38k views

Filter by multiple conditions / drop-downs using DataTables - Table plug-in for jQuery

Using this example from http://www.verticalcoder.com/2014/11/21/datatables-in-visualforce-part-1/ I implemented a Visualforce page that creates a dropdown and filters records in the datatable based on ...
5
votes
1answer
4k views

Collection size 1,100 exceeds maximum size of 1,000. Limited my query to 100 items but still getting the error

public class Checkbox_Class { List<assetswrapper> assetsList = new List<assetswrapper>(); List<Asset> selectedAssets = new List<Asset>(); Integer x; public ...
5
votes
2answers
21k views

How to properly use JQuery Datatable sAjaxSource with Apex providing JSON source

I'm trying to use sAjaxSource with server side processing from Apex class which will provide JSON as source. First I was trying simple example, which won't work and won't output any error (not in ...
4
votes
1answer
5k views

onComplete javascript function in actionFunction behaves differently. Why?

i am having four tabs. Each of the tab contains an actionFunction with the same name "methodOneInJavaScript" but rerender attribute have different pageblock Ids to refresh it based on the click event ...
4
votes
1answer
3k views

jQuery Datatable disappears once rerender the pageBlockTable using actionFunction. Any suggestions?

i am calling a method to bring the latest data from SAP on click of a button "Refresh" using actionFunction and set to rerenders pageBlockTable. But, after rerendering happens the entire datatable ...
4
votes
1answer
1k views

apex:actionsupport event not firing

I have this sample page created that uses Jquery datatable within that I'm using <apex:actionsupport> and when I click on the hyperlink for that particular column it does not fire the event and ...
4
votes
1answer
423 views

LWC lightning-datatable not accepting cellAttributes in the first column

Lightning-datatable is not accepting any cellattributes in the first column. All other columns are formatting correctly. Is this a limitation, or am I doing something wrong? (Irrelevant code removed ...
4
votes
3answers
6k views

Re-Evaluating Selected-Rows in Lightning-Datatable When Data Changed

I've been stuck on this issue for a few hours now and don't seem to be getting any closer to resolving it. I currently have a Lightning-Datatable with pagination that renders 20 rows at a time. When ...
4
votes
1answer
3k views

lightning datatable (AURA or LWC) can automatically fetch records from database?

Is it possible to fetch records automatically from database just by mentioning columns? Also can we use relationship fields to get data without any processing? For example CreatedBy.Name ? Other ...
4
votes
1answer
348 views

lightning:dataTable not available in Version 41.0 yet(Winter '18)

I was trying to use the lightning:dataTable in my Winter '18 preview enabled sandbox with Version 41.0(shown in snapshot) But unfortunately it fails to identify the base lightning component(lightning:...
4
votes
3answers
2k views

How to submit all wrapper class records using datatables.net jQuery plugin & apex dataTable?

I am using the [datatables.net][1] jQuery plugin with an <apex:datatable /> and I want to submit all records checked from the dataTable meaning i'm using <apex:stylesheet value="{!$Resource....
4
votes
1answer
2k views

LWC Datatable - Turn Custom Lookup Field Value in Editable Datatable to Draft Value for Mass Update

As you know, datatables do not support lookup field. I've built a search lookup field that queries an object, and added that to the LWC datatable as a custom type. The id of the selected record (...
3
votes
3answers
8k views

How do we dynamically add columns in a datatable

I am trying to build a VF page which dynamically displays the datatable. The fields to be displayed are not known, they need to taken from a custom setting. Here is what i am trying to achieve I ...
3
votes
1answer
5k views

Lightning Web Components inline editing Datatable - data update issue

I am starting with Lightning Web Components and I've tried to use data table. For some reason I can see data being changed in table - but in js controller my variable remain unchanged. js import { ...
3
votes
2answers
7k views

lightning:datatable clear row selections

Does anyone here know how to clear the selected rows of lightning:datatable on a button click or post processing of checked records?
3
votes
1answer
2k views

apex:outputPanel not working with <td> elements

I am building a table using apex:repeats and html and I would like to stick with the method I currently have, but I am not getting my table to output correctly. Current code is the following, <...
3
votes
2answers
789 views

replicate salesforce alphabetic sorting feature on list views

Has anyone ever tried to replicate the alphabet sorting functionality you see in the list views? Any ideas on how to achieve this?
3
votes
1answer
941 views

Use jquery data table export functionality in lightning component of salesforce after enabling locker service?

I have created lightning component to use jquery data table. I am using export functionality of jquery data table. But it is not working. It is showing only Export button. When I clicked that it doesn'...
3
votes
1answer
3k views

Initializing Javascript plugin after loading data in lightning component

I am displaying a list of cases in a table and want to use DataTables jQuery plugin to implement sorting, pagination, search on the table. The list of cases is retrieved as part of component ...
3
votes
1answer
654 views

how can you group results in a datatable

I'm not sure if this is possible, but is there a way to group records that are displayed in a datatable in a type of hierarchical structure? Here is the apex code: public List<Deal__c> ...
3
votes
1answer
1k views

Problems displaying custom objects on VF page using <apex:datatable>

I've created a custom object called Beer. I've also created a VF page and Apex controller to simply display the beers via the customer portal site using a high volume customer portal user license. VF ...
3
votes
1answer
1k views

Return string value of id on jQuery datatable server side sorting

Hi I'm working on a server-side sorting using jQuery datatables based on an example from here. Everything works fine bar one detail - the look up fields to the user returns the user id and I'm not ...
3
votes
2answers
4k views

Hyperlinking in Lightning:Datatable

Currently when I use the lightning:datatable and then a column of type url. I cant seem to bind a actual event to the url.. My Code is currently as follows Component <lightning:layoutItem ...
3
votes
0answers
781 views

How to make table align correctly Salesforce Lightning design system Javascript Table

I was able to append my data, and now the data does not align correctly with the column headers as well as it is not sortable (in the code I have sortable enabled. and the check boxes do not align ...
3
votes
0answers
159 views

Table with independent rows

I need a table showing sObjects within independent rows. I need to perform actions on single rows without even taking care about all the other rows. Reason: Some rows might be invalid (having ...
2
votes
2answers
14k views

get data when click on row in pageBlockTable

I have a pop-up display a table with some columns (Name, ID) of Accounts for example, I want to display additional information of the selected account when I click on specific row. I used something ...
2
votes
1answer
9k views

Date formatting to MM/DD/YYYY in LWC datatable

How do we format the date in datatable like MM/DD/YYYY in LWC data table. In my datatable column type is defined as date, value display in table as Jan 10, 2020. Expecting in MM/DD/YYYY format. { ...
2
votes
2answers
3k views

Jquery datatable error pops up when table is loading

I am using datatable plugin in a visualfroce page. Below warning popsup only at the time of page loading and table looks good after closing the alert. Here is the code... VisualForce Page $('#...
2
votes
1answer
4k views

Lightning Datatable - Errors Attribute

Could someone provide a working example of a lightning:datatable that utilizes the 'Errors' attribute? I want to validate fields in a datatable and flag the cells that need correction. According to ...
2
votes
1answer
943 views

How to rename 'Checkbox' column in lightning 'datatable' component?

Description: Lightning datatable component allows to place checkboxes within the rows. Checkbox column on top contains a select all checkbox by default. Question: Would it be possible to put a ...
2
votes
1answer
4k views

Why Lightning:datatable typeAttributes do not support neither tooltip nor title for url?

I want to use lightning:datatable component to display list of records where the first column is the URL with label and tooltip consisting of record name and value directing to record URL in format /{...
2
votes
2answers
2k views

After rerendering, retrieving elements in jquery seems stopped working

I am using apex:dataTable and implemented some code to do the pagination. But instead of using apex:commandButton to go Next and Previous, I am using pure html tags as listed below in purpose of ...
2
votes
2answers
2k views

How to clear draft values in LWC datatable after save

I am working on an LWC datatable application in which I must call an Apex method imperatively, passing it the JSON string of the event.detail.draftValues which it uses to add or update some Sobject ...
2
votes
1answer
391 views

lightning-layout stretches inner datatable

I have the following code in a web component: <lightning-accordion-section name="Products" label="Products"> <lightning-layout> <lightning-layout-...
2
votes
3answers
2k views

Lightning Web Components lightning-datatable detect "select all" checkbox

When using the lightning-datatable component, by default each row has a checkbox beside it (unless so explictely specify hideCheckboxColumn to false). So when a row is selected the onrowselection ...
2
votes
1answer
2k views

Sorting apex:pageblocktable

I was wondering if someone has used the PageBlockTableEnhancerADV plugin and was able to implement sorting function for each column. I was trying to use the www.datatable.com sorting plugin but I can ...
2
votes
1answer
3k views

How to limit the number of rows displayed in <apex:datatable> and add a scrollbar?

I have an <apex:datatable> like this : <apex:dataTable value="{!accList}" var="account"> <apex:column> <apex:facet name="header">Account ID</apex:facet> ...
2
votes
2answers
5k views

Building a Table of Data in a Visualforce Page

Want to create a table using vf which displays 10 records will be displayed in a single page and i need to click on next(or) previous button to view records and records number(1-10,11-20,..) must be ...
2
votes
1answer
3k views

how to make the icon on a data table clickable in lwc?

We are trying to extend the data table in lwc where in earlier we are using the default row actions but now we want the icons to be included like edit, delete. But I am not sure on how to make them ...
2
votes
1answer
1k views

How to increase the apex datatable width dynamically

I have designed an inline vf page with lightning design css. But my apex:datatable is not responsive. If i increase the resolution it is not fit into the page block . Please provide me a solution . ...
2
votes
1answer
2k views

Dragging and reordering dataTable/ pageBlockTable rows

I have a dataTable which is populated by the a list of Sobject. I need to be able to drag the rows of the table and reorder them. I have a HTMl table code snippet which does this using jQuery. <...

1
2 3 4 5