Get a Users details using a List Method?

  • 25 October 2018
  • 2 replies
  • 3 views

Userlevel 3
Badge +16

Hi,

 

Anyone able to help with this?

 

I have a SQL Table with a List method

In the List Method i have fields like Title First Name, Surname.

 

In the K2 form, I do a Filter to retrieve a list of all matches to a List View The Input is the EmpNumber and Output is Title, First Name, Surname.

 

If there a multiple entries for the same person that is fine, but how do i put the first instance of Title, FirstName and Surname in Data labels?

 

I tried Output mappings, but none of the List Return Properties will map to Data labels.

 

Anyone know why?

 

Thanks


2 replies

Badge +6
If you're mapping the outputs to datalabels it's probably trying to return multiple since it's a list method. Is your goal to concatenate Title, FirstName and Surname in one list view column? If so you could accomplish this with an expression on a new list view column made from a data label
Userlevel 5
Badge +13

Is it possible to use a "Read" method instead of a "List" method? It must be getting confused trying to map a list of records to a single value display (data label)

Reply