Where would I find the list of valid column data types available for query reports?

1

I used to have a link to such a list but it seems lost to the ether. Anyone know where I might find it?
I’m specifically looking for the available data types for formating the column display in a query report. The types I know about are:

  • data
  • int
  • date
  • float
  • link

Looking for any others, possibly one that will left justify a number.

2

Go to Doctype form of DocField. IE: http://192.168.1.190/desk#Form/DocType/DocField

Look for Options section for Type.

Attach
Attach Image
Barcode
Button
Check
Code
Color
Column Break
Currency
Data
Date
Datetime
Dynamic Link
Float
Fold
Geolocation
Heading
HTML
HTML Editor
Image
Int
Link
Long Text
Markdown Editor
Password
Percent
Read Only
Rating
Section Break
Select
Small Text
Table
Table MultiSelect
Text
Text Editor
Time
Signature

image
image1310×768 52.6 KB

I hope this helps.

3

Thanks for the quick response!

I’ll check these out.

Thanks so much!

4

I did a quick test of some of these types in a query report and it appears this is just a list of field types for DocTypes.

I’m looking for the column formatting definition types for query reports.

But thanks for getting back to me! I’m sure I’ll make use of this list in the future.

The hunt continues…

5

@jvantslot

There’s no documentation for that

In theory @TurkerTunali, is right, but in reality no, the list is much more restricted

The mostly used field types are

Data
Int
Check
Float
Currency
Date
Datetime
Link
Dynamic Link

Fields like attach, images and any that are for layout control, will be avoided by the Report

In case the column has any value to represent, In 90% of the cases it will be displayed as an Data field

The column formatting is

“Label:Type:Width”

Only 3 types vary in this

Link, Dynamic Link and Currency, that accepts

“Label:Type/Options:Width”

1 Like
6

max_morals_dmm,

Thanks for verifying what I suspected. I appreciate you clearing this up.

james