Finance | Project Operations, Human Resources, ...

how to get field Name from fieldNum?

(0) Share

Report

Posted on by BASMA

932

Hello,

I have this tabel that contains TableNum and fienNum :

I want to get the field Name But I don't which table that contains the fieldId and the fieldName

Have you any idea how to get the field name?

Thanks

I have the same question (0)

All responses (25)

Answers (0)

Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report

RE: how to get field Name from fieldNum?

You can use the Find labels from extensions and then paste the table label and give a find reference on that. It will give the field name.

Another way is to navigate to that tablenum means you can get table name and then you can search the fields with that labels.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

RE: how to get field Name from fieldNum?

inventTable contains many fields ,

I see it's not practical to go through all the fields one by one to check

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report
RE: how to get field Name from fieldNum?

Then there is no way you need to check each of the field from the InventTable and add select statement based on that.

while select mandatoryFieldsTable where mandatoryFieldsTable.StateId == productLifeCycleState.StateId { switch(mandatoryFieldsTable.TableNum) { case tableNum(InventTable): DictTable dictTable; DictField dictField; int i, cnt; InventTable inventFieldTable; dictTable = new DictTable(tableNum(InventTable)); cnt = dictTable.fieldCnt(); for (i= 1; i<=cnt;i ) { dictField = new DictField(tableNum(InventTable),dictTable.fieldCnt2Id(i)); if(dictField.label() == mandatoryFieldsTable.FieldLabel)) { fieldName = fieldId2Name(mandatoryFieldsTable.TableNum,dictField.Id()); } } if(fieldName == "ABCTieUp) { if(invnetFieldTable.ABCTieUp != 0) { } } //smilarly for all the fields you need to write. if(fieldName == "Field2") { if(invnentFieldTable.Field2 != 0_ { } } break; case tableNum(InventModelGroupItem): InventModelGroupItem inventModelGroupItem; break; case tableNum(EcoResStorageDimensionGroupItem): EcoResStorageDimensionGroupItem storageDimensionGroupItem; break; case tableNum(EcoResTrackingDimensionGroupItem): EcoResTrackingDimensionGroupItem trackingDimensionGroupItem; } }

Thanks,

Girish S,

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

RE: how to get field Name from fieldNum?

I debug the code, I get only the name of field :

I want to check if this field is empty or no like this :

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: how to get field Name from fieldNum?

Yes, try the code i have given in my previous reply and let us know if it meets your scenario.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

RE: how to get field Name from fieldNum?

ok,

for example I select this field :

I want to serach in inventTable if this field is filled or not I means that I find a value in the field"ABC-Code Carring Cost"

...

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: how to get field Name from fieldNum?

What do you mean by field found in invent Table is empty or not?

Can you elaborate?

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

RE: how to get field Name from fieldNum?

yes I understand this part,

But I want to check if this field found in inventTable is empty or no

Was this reply helpful? Yes No
GirishS 27,825 Moderator on at

Like (0)

Report

RE: how to get field Name from fieldNum?

Code I have given will loop through all the fields in the InventTable and compare with fields given in your custom table which is MandatoryFieldTable.

So, the DictTable used DictField to loop through all the field in the InventTable.

Thanks,

Girish S.

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

RE: how to get field Name from fieldNum?

you probably don't understand me,

I search if the field in the table inventTable has a value or empty

not if the table has this field or no

I want to add select from inventTable where this field != null

Was this reply helpful? Yes No