Data Resource is not binding to list component

[Kishore32]

Dynamic data resource is not binding to the list component. 

I've added dot walked dynamic data resource value in Table field of list component. Even though data is not binding. I'm seeing below issue.

Do let me know if you need info around it, Appreciate your help!!

Thanks,

[Kishore32]

Thanks for the reply!!

I've a requirement to query the table, I need to get a record based on a integer value column.

The column will have 50,40,30,20,10,0 values and I need to get all the records with value 50 means records with highest value.

Other requirement to except highest value I need to all other records in this case below 50 value.

Here question is where to write the this kind of queries on the table?

Thanks,

Kishore

[Brad Tilton]

Hi Kishore,

I'm not quite sure I understand your use case, but if you can do this query in a normal list view then you should be able to do the query in the list component.

[Kishore32]

Hi Brad,

Below is my requirement, I have users tables and it will have duplicate employee records

1. First, get distinct records based on EmpId column of my table.

2. There is a sequence order on each record with different values with 50,40,30,20,10,0. I would like to get the max value records from the table for each employee.

        Example: User A having 2 records with sequence number column value as 30,20 and User B having 2 records with sequence number column value as 50,30. So I have to 2 records of 30 value record of User A and 50 value record of User B, here we get 2 records out of 4 records.

So, how can I achieve the above requirement, I'm just wondering using which option I can achieve this. Do we have any gliderecord concept in the list component? please help me out here. Appreciate the help!!

I've posted the same use case in your blog

https://developer.servicenow.com/blog.do?p=/post/quebec-ui-builder-lists/