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
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.
inventTable contains many fields ,
I see it's not practical to go through all the fields one by one to check
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,
I debug the code, I get only the name of field :
I want to check if this field is empty or no like this :
Yes, try the code i have given in my previous reply and let us know if it meets your scenario.
Thanks,
Girish S.
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"
...
What do you mean by field found in invent Table is empty or not?
Can you elaborate?
Thanks,
Girish S.
yes I understand this part,
But I want to check if this field found in inventTable is empty or no
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.
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
André Arnaud de Cal...
291,969
Super User 2025 Season 1
Martin Dráb
230,842
Most Valuable Professional
nmaenpaa
101,156