Can you change the display of the results of a data link search?

Permanently deleted user

2. August 2017 20:30

Hello out there!

 

Is there any way to change the results of the data link search? 

 

The data link is from Access and the field it is returning is set as a "short date". but I see this... I would like to see just the date...eg: Oct 02 2007.

 

thanks!

 

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=906f20000000CLv&feoid=Body&refid=0EMf2000000E3wk" _/_img_

0

• 

  Permanently deleted user

  11. November 2017 00:16

  Hi Larisa, 

   

  The appearance for fields in a datalink depends on the "Command" used in the data link configuration.  In Essentials Manager, go to Map > Edit Layer > Data Links > Advanced.  That is where you will see the "Command" property.  The field formatting you apply anywhere else in Manager or within Access don't apply to data link fields in the viewer.

   

  The type of things you can do with this command depend on the data source/sql dialect.  For example, for a table from MS Sql Server you can use Convert() (https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql) and change  SELECT date, name FROM table WHERE idfield = @id to SELECT CONVERT(varchar, date, 101), name FROM table WHERE idfield = @id and the date field will then appear as mm/dd/yyyy.

   

  I am not sure if there is an equivalent expression that we can use for a date field from an Access table.  I took a look but didn't have any success.

   

  Another thing to note is that the field that shows up on this link is whichever field is listed first in the Command's SELECT statement.  If you don't have any luck formatting the date, you could change the order of the list of fields around, and have different field displayed in the SignalWarrants list.

   

  Eg, change SELECT date, name FROM table WHERE idfield = @id to  SELECT name, date FROM table WHERE idfield = @id

   

  Hope that helps!

   

  -Amanda

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.