Ask Your Question

Correct Listing Status Field

asked 2015-10-22 10:23:45 -0600

Connecting to with the user LArealestatenetwork and having trouble identifying which status field I should be querying. I'm assuming it's L_StatusCatID as the standard name is Listing Status but its type is SMALL. None of the status fields I'm looking at have a type of LOOKUP which prevents me from seeing what values are available. Is there anyway to confirm I'm querying the correct field and how can I find out the corresponding values without a LOOKUP?

Any help would be appreciated.

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2015-10-22 11:33:53 -0600

There are 3 status fields: L_StatusCatID, L_StatusID, and L_Status. L_StatusCatID and L_Status both have lookups assigned. L_StatusCatID is the major status values. L_Status contains all the available status/sub status values.

edit flag offensive delete link more


I was able to get a listing of all the status values by doing using the L_Status lookupname of 'Status'. Thanks for pointing me in the right direction.

stuckinrets gravatar imagestuckinrets ( 2015-10-22 12:30:25 -0600 )edit
Login/Signup to Answer

Question Tools


Asked: 2015-10-22 10:23:45 -0600

Seen: 1,134 times

Last updated: Oct 22 '15