Hi All, I'm trying to get the company value from t...
# suiteqlc
Charan
07/13/2022, 11:44 AMHi All, I'm trying to get the company value from the case record. Since, I need a value rather than I'd so I'm using BUILTIN.DF(supportcase.company) but unfortunately still it is returning id instead of text. Any ideas ?
s
Slackbot
07/13/2022, 1:16 PMBy using @ here, you have just notified all active users in this channel. Please only use @ here when absolutely necessary.
c
Charan
07/13/2022, 1:18 PM@here Any thoughts? I tried joining the case and entity tables. Still I'm getting the id instead of name.
s
Slackbot
07/13/2022, 1:18 PMBy using @ here, you have just notified all active users in this channel. Please only use @ here when absolutely necessary.
m
Matt Bernstein
07/13/2022, 1:18 PMBUILTIN.DF should return the text as in the image
c
Charan
07/13/2022, 1:23 PMThat's weird. I'm using the similar one but I'm getting id instead of text
m
Matt Bernstein
07/13/2022, 1:25 PMis the entity setup with the id as the name?
c
Charan
07/13/2022, 1:25 PMYes it is Matt.
m
Matt Bernstein
07/13/2022, 1:27 PMthat’s probably the issue. what is the actual name field used on the entity?
Matt Bernstein
07/13/2022, 1:28 PMmaybe it’s one of these fields?
select
company as company_id,
BUILTIN.DF(supportCase.company) as company_text,
entity.entityid,
entity.lastname,
entity.firstname,
entity.email,
entity.entitytitle,
entity.entitynumber,
from
supportCase
INNER JOIN entity ON supportCase.company = entity.id
c
Charan
07/13/2022, 1:36 PMThanks Matt. I tried this but still I'm getting id. I would like to get the autogenerated Id in the entity record.
m
Matt Bernstein
07/13/2022, 1:37 PMif it’s a custom field, try adding that custom field to entity.custfield…
c
Charan
07/13/2022, 1:37 PMNo it's not a custom field. The id of that field is entityid.
m
Matt Bernstein
07/13/2022, 1:38 PMand entityid is only returning the internalid of the record?
c
Charan
07/13/2022, 1:39 PMYes even I tried using the BUILTIN.DF(entityid)
Charan
07/13/2022, 1:39 PMI'm excepting the text in the entityid
m
Matt Bernstein
07/13/2022, 1:41 PMthat’s odd… what happens if you try a direct query onto the entity record? Are you able to pull the text value at all? Maybe try a select * from entity WHERE entity.id IN (<<insert id>>)
c
Charan
07/13/2022, 1:44 PMFinally I got it 😊. Thanks for the idea! I tried getting all the values from the entity record and the correct value sits in the entitytitle column
🎉 1
Charan
07/13/2022, 1:45 PMThanks @Matt Bernstein
3 Views