GI Function Select statement

Posted about 2 months ago by Retha van Alphen

R
Retha van Alphen
Un Answered

0 Votes

GI Function have the Select. 

=GI(Connection, Name, Filter, Select, IncludeHeader)

This is the  Comma-separated list of field names to be included in the resulting dataset.

How can I return the values in the Select statement & include Header with own defined Caption?


0 Votes


2 Comments

Sorted by
R

Retha van Alphen posted about 2 months ago

Hallo Yes the explanation is correct the issue is that the Velixo GI does not accept the Acumatica Caption value. Hence I am unable to use the values in the columns

0 Votes

Miron Shikhov

Miron Shikhov posted about 2 months ago Admin

Hi Retha,


You need to keep the Select argument with the required columns, set IncludeHeader = FALSE, and then add a new row before the GI function with the manually added headers.

0 Votes

Login or Sign up to post a comment