First time here? Check out the FAQ!

Correct Listing Status Field

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.

stuckinrets's avatar
asked 2015-10-22 10:23:45 -0500
edit flag offensive 0 remove flag close merge delete


add a comment see more comments

1 Answer


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.

bwolven's avatar
answered 2015-10-22 11:33:53 -0500
edit flag offensive 0 remove flag delete link


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's avatar stuckinrets (2015-10-22 12:30:25 -0500) edit
add a comment see more comments

Your Answer

Login/Signup to Answer