Jump to content

worksheet query in one layer


Recommended Posts

I have a worksheet that generates a list of lengths and heights of curtains from the softgoods tool. Because the curtains exist in a symbol the worksheet keeps listing every curtain twice or however many times the symbol is instanced in the file.

I would like to isolate the query to just one layer, but when I "add criteria" nothing happens. I assume this is some syntax error on my part.

How do I insert a filter for just one layer in a worksheet database criteria?

Link to comment

1. Edit the worksheet

2. Goto the worksheet Edit menu and make sure Database Headers is checked

3. Right Click in the database row header (i.e. 3, not 3.1, 3.2, etc).

4. Choose Edit Criteria

5. Click the More Choices button at the bottom left of the Criteria window.

6. Set the criteria to the layer you are interested in.

Click OK.

Let us know if this helps or if you need more information.

  • Like 1
Link to comment

You get the Count because the field you have chosen (TTLSGLngth) is formatted as text not a number.

Two options. I don't know enough about Soft Goods to know which is better. I will see if I can get Andrew to chime in.

1. Use a different field. It appears that 'SoftGoods 2'.'AdjustableLength'

gives the same value as a number. Those will sum properly to the top of the column. If there truly is a field that has the numeric value this is the best option.

2. Change the formula to =value('SoftGoods 2'.'TTLSGLngth'). This will get you a number, but you will lose the unit marker. You can then select the column and use the Format - Cells menu command to set the formatting to Dimension (instead of General) and you are back close to what you want.

You could also leave the formula in column 2 as is and add an additional column with a formula of =Value(B2) and this will give you a numeric column. You can then format that if necessary.

Link to comment

Grant -

First off, in the "Criteria" dialog, add a filter for "Record" "SoftGoods 2" "is present." That will restrict display to SoftGoods 2 objects only.

2 things to try:

1) Change your header filter to "=VALUE('SoftGoods 2'.'TTLSGLngth')." That will, as Pat said, strip out units so you'll have to reformat the header cell (by right-clicking on it and selecting "Format Cells...") to "Dimension." The header cell will then display the sum of the lengths.

2) If your Symbols are all single runs of straight sections (confirmed by "Adjustable Length" being visible and enabled), change the field you're displaying to from "TTLSGLngth" to "AdjustableLength" and reformat the header cell (by right-clicking on it and selecting "Format Cells...") to "Dimension." The header cell will then display the sum of the lengths.

One of those should give you what you want.

Does that help??

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...