This topic is locked

Value properties

4/27/2011 10:50:13 AM
PHPRunner General questions
G
Grissom author

Hi,
on the add page I have a lookup value for my customers which displays concat(company,' (',cust_id,')') and the link field is set to "cust_id". In the database the value is stored correct - only the customer ID.
When adding that field to the List page, it would display the customer ID the same way as on the Add page though - "concat(company,' (',cust_id,')')". If I would change the settings in the "Edit as" dialog to a regular text field, this would also change the Add page field layout which is not desired though.
How could I have only the actual stored customer ID displayed on the List page?
Best regards,

Chris

Sergey Kornilov admin 4/27/2011

Chris,
you'll need to add fields alias to SQL query.
select cust_id,

cust_id as cust_id1

from ...
Then make sure cust_id1 appears on the List page only. cust_id should appear on all other pages. You can setup this on 'Choose fields' screen.