# SysQueryForm add field in lookup

**URL:** <https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067>\
**Category:** Developer Forum\
**Created:** [October 31, 2013, 1:30pm UTC](https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067 "2013-10-31T13:30:02Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![DominicB](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@DominicB](https://www.dynamicsuser.net/u/DominicB)\
**Post date:** [October 31, 2013, 1:30pm UTC](https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067/1 "2013-10-31T13:30:02Z")

</div>

I would like to add the field\_id in the range lookup to see the true database fieldName but I`m not able to display any row in lookup.

Is it possible to modify sysqueryform lookup?

public void lookup() // this is what i have tried

{

SysTableLookup sysTableLookup = SysTableLookup::newParameters(tablenum(TmpSysQuery),this);

Query query = new Query();

QueryBuildDataSource queryBuildDataSource;

;

queryBuildDataSource = query.addDataSource(tablenum(TmpSysQuery));

sysTableLookup.parmQuery(query);

sysTableLookup.addLookupfield(fieldnum(TmpSysQuery,FieldLabel));

sysTableLookup.addLookupfield(fieldnum(TmpSysQuery,field\_id));

sysTableLookup.performFormLookup();

}

 ![3414.2.png](https://us1.discourse-cdn.com/flex023/uploads/dugusers/original/2X/0/0e3e249d39ff98c12e2fc288aa3712f50bc0db87.png)

---

<div class="post-metadata">

**Author:** ![MartinDrab](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)\
**Post date:** [October 31, 2013, 2:51pm UTC](https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067/2 "2013-10-31T14:51:06Z")

</div>

Field\_Id has the Visible property set to No. Isn’t that the problem?

---

<div class="post-metadata">

**Author:** ![DominicB](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@DominicB](https://www.dynamicsuser.net/u/DominicB)\
**Post date:** [October 31, 2013, 3:16pm UTC](https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067/3 "2013-10-31T15:16:08Z")

</div>

Actualy I want fieldName and not field\_id sorry.

In the form sysQueryForm, the datasource → Range → fields -\>FieldLabel have the method lookup.

I think this is where I should add my field FIELDNAME

I saw something

[http://kiwiaxguy.blogspot.ca/](http://kiwiaxguy.blogspot.ca/) → [Filtered lookups on SysQueryForm](http://kiwiaxguy.blogspot.ca/2012/05/filtered-lookups-on-sysqueryform.html)

using the **public void lookup(FormControl \_formControl, str \_filterStr) method for customisation**

**But in my case i just want to add field name beside field label in the lookup feilds… should`nt be hard… but hard for me 😛**

* * *

I maid a temporary solution that display the fieldName in a textbox by modifing the method Range.FieldLabel: modified

public void modified()

{

super();

range.LookupButton = sysLookup::lookupValidate(range.RangeStatus, range.Table\_Id, range.Field\_Id);

range\_ds.setLookupButton();

fieldNameResult.text( dbutil::FieldName( tableId2Name(Range.Table\_Id), Range.Field\_Id));

}

---

<div class="post-metadata">

**Author:** ![DominicB](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@DominicB](https://www.dynamicsuser.net/u/DominicB)\
**Post date:** [November 1, 2013, 6:17pm UTC](https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067/4 "2013-11-01T18:17:23Z")

</div>

This is what Im trying to get on the query form.

A new column fieldName

 ![1200.Sans titre.png](https://us1.discourse-cdn.com/flex023/uploads/dugusers/original/2X/c/cdb293e489d99da78106ef9ff8997af58e0d380b.png)

---

<div class="post-metadata">

**Author:** ![DominicB](https://avatars.discourse-cdn.com/v4/letter/d/e56c9b/32.png) [@DominicB](https://www.dynamicsuser.net/u/DominicB)\
**Post date:** [November 4, 2013, 4:24pm UTC](https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067/5 "2013-11-04T16:24:11Z")

</div>

I think you already reply to a similar request back in 2011

[http://dynamicsuser.net/forums/p/47447/240899.aspx](http://dynamicsuser.net/forums/p/47447/240899.aspx)

Use SysTableFieldLookup class. Pass the form query to the constructor, save TableId to TmpSysTableField table (DictTableId field) and pass it to performLookupField().

I`m trying to follow you instruction here but my level of expertise is not enough to follow your instructions…

Could you elablorate a bit more or in the best world … a small .xpo that represent these changes.

Thanks Martin

---

<div class="post-metadata">

**Author:** ![MayNav](https://avatars.discourse-cdn.com/v4/letter/m/d2c977/32.png) [@MayNav](https://www.dynamicsuser.net/u/MayNav)\
**Post date:** [March 6, 2014, 7:14am UTC](https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067/6 "2014-03-06T07:14:17Z")

</div>

simple code

at classDeclaration  
SysTableFieldLookup tableFieldLookup; // function for lookup field  
TmpSysTableField tmpSysTableField; // to catch selected lookup value

at lookup method:  
Query query = new Query();  
;  
query.addDataSource(tableNum(SalesLine));  
tableFieldLookup = new SysTableFieldLookup(query);  
tmpSysTableField.DictTableId = tableNum(SalesLine);  
tableFieldLookup.performLookupField(this, tmpSysTableField); // lookup display label description

at modified method after super  
FieldId fieldIdNum;  
fieldIdNum = tableFieldLookup.parmSelectedRecord().FieldId; // get the field id

---

<div class="post-metadata">

**Author:** ![akuamoah](https://avatars.discourse-cdn.com/v4/letter/a/67e7ee/32.png) [@akuamoah](https://www.dynamicsuser.net/u/akuamoah)\
**Post date:** [April 17, 2014, 8:34pm UTC](https://www.dynamicsuser.net/t/sysqueryform-add-field-in-lookup/49067/7 "2014-04-17T20:34:56Z")

</div>

Hi Dominic,

What you should do is create a display method on TmpSysQuery like so

display FieldName FieldName()

{

return fieldId2name(this.Table\_Id,this.Field\_Id);

}

then add the display method to the grid on the form SysQueryFieldLookup. make sure the datasource “Allfields” is set as the datasource of the display method control which you added.

I think that is about it. The lookup should now have the field label as well as the fieldname. You should be able to take it from here.

-Albert.
