Hi,
I want to know how to do BAQ to distinguish between inactive vs inactive and closed.
any thought?
If those are fields that show in the UI (like on an entry or tracker form), you can use Field Help, to show technical details about the source data. Like what table and field drives it. If you canât find the exact field. You can et least determin which tables are used.
Then use Data Dictionary to look at the tables fields. Make a BAQ to do some experimenting to ensure those fields do what you think.
And if you canât find it as a boolean (bit) field, sometimes a character field to hold a status code.
1 Like
Hi Mark,
But this ActiveProject indicates whether project is inactive.
Iâm trying to say is how can I have a baq to distinguish these two?
Right. Create a BAQ that shows all fields (or just the bit fields) and set a selection for the ProjectID equal to one or the other and look at whatâs different between the two.
1 Like
We donât use the Proj Module, so Iâm making some guesses here ⌠Those indicators are on the âDetailsâ sheet. So they probably are from a table like ProjectDtls(?), and not the Project table (which I assume is akin to a âHeaderâ table like OrderHdr).
edit
Well I was wrong about there being a Details tableâŚ
But another way to try and find fields with the Data Dictionary is to select the table then view the fields on the list tab. Then right click and select âCopy to Excelâ The once that opens in excel, you can search for text like âClosedâ.
1 Like
You solve my issue. PBClose is the field
1 Like
