Who's On?

	Membership:
	Latest: cat andrews
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5215

	People Online:
	Visitors: 0
	Members: 0
	Total: 0

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chesca	1042

IC Audit Table Field Number

3 Replies

1 Subscribed to this topic

39 Subscribed to this forum

Sort:

Author

Messages

John Turpin

Basic Member

Posts: 7

2/1/2016 11:19 AM

Hi,

In the ICAUDIT table, we are able to dump the data using an SQL script. What I am struggling to find is a list of all of the field names that are associated to the field number value on that table. Does anyone know if there is such a list?

Would be great if we could find a list for both the ITL and ITE DB_FILES. Thanks

Kat V

Veteran Member

Posts: 1020

New Poster

Engaged Reader

Avid Reader

2/1/2016 1:43 PM

My IT once gave me one in v8 - but the field numbers change all the time - the field names are what I use to query and I typically just use ctrl+shift+o for those.

JonA

Veteran Member

Posts: 1163

2/1/2016 3:29 PM

If you modify your script to include ICDICT (join on FIELD_NBR) you can select ICDICT.FLD_NAME in your output.

A note about Ctrl-Shfit-O: The field numbers displayed in the IE status bar are not the same as in ICAUDIT. Ctrl-Shift-O is good for identifying the table and field for use in MS Addins uploads but not for ICAUDIT. For instance, Ctrl-Shift-O in the Active Status field displays

Which matches MS Addins

But in ICAUDIT the field number is 34

Ctrl-Shift-O for Item Description is Id=_f7. In ICAUDIT the field number is 515.

kyle

Basic Member

Posts: 16

New Poster

10/10/2016 7:19 PM

join on the ICDICT table. This should contain the field_nbr names.