TurboCAD Forums

The Ultimate Resource for TurboCAD Knowledge

Register
 
All posts discussing pricing or where to buy TurboCAD will be deleted.

Using "Select by Query" in TC2015
Read 345 times
* August 13, 2019, 10:39:12 PM
I think 'Select by Query' might be what I need to find what I need in a drawing but I can't get it to work.
I have followed the help pages, set the criteria etc., saved the query and parsed the query successfully but I can't work out how to implement the query. Any help would be greatly appreciated.

Thank John

Logged
Core i7-6700 CPU
16GB Ram
64 Bit
Windows 10 Home
TurboCAD 2015 Pro Platinum 64 bit Build 90.0


* August 14, 2019, 01:19:25 AM
#1
I usually clear ,first
 then go to criteria to find what I am looking for.
When you select your query the correct syntax should be automatically be filled in the query box - click ok.

If it is a query you are going to use often you can save it and it will be added to the query list for future use.
« Last Edit: August 14, 2019, 01:21:23 AM by nikkipollard »

Logged
Nikki
TC20 platinum
TC 2015 platinum
TC 2017 with lightworks


* August 14, 2019, 02:31:19 AM
#2
Thanks Nikki, that's what I have been doing without success. Are you saying that clicking OK should invoke the search? My problem seems to be invoking or implementing the search.

Thanks John

Logged
Core i7-6700 CPU
16GB Ram
64 Bit
Windows 10 Home
TurboCAD 2015 Pro Platinum 64 bit Build 90.0


* August 14, 2019, 05:41:29 AM
#3
Thanks Nikki, that's what I have been doing without success. Are you saying that clicking OK should invoke the search? My problem seems to be invoking or implementing the search.

Thanks John

Perhaps nothing in your Drawing satisfies (wrong word?) the query.
If that's the case, TurboCAD probably will not give you any indication as such.

Try this:
>Insert a Line, it's Pen Color set to Red (not By Layer, or any other way of getting to Red).  Make sure it is on a Visible and UnLocked Layer.
>Select by Query.  Clear the Query box and go to Criteria->Common_Properties...->Line Color.  Select Red.  [Close].
You should see a query string that reads:  'Line Color'='Red'
>Parse it if you want to, but click OK in the main Query Window.

Is your Red Line selected?  It is for me in version-20PP.

Also-- Please Copy & Paste here a Query String you are trying to use but is unsuccessful.  And including the Drawing file here would be a good thing; and share with the Forum in plain words (not Query Syntax) what it is you are trying to achieve-- trying to Select-- via the Query.
« Last Edit: August 14, 2019, 05:50:04 AM by Alvin Gregorio »

Logged
Alvin Gregorio
(mostly Residential Architectural 2D; no formal CAD Training; intermittent TurboCAD user since yr. 2000 [ver6.5])
---TurboCAD: V20.2PP(57.0)[as of 3/12/15]; V19DL(54.2); V11.2Pro; Windows-7-Pro/64-bit; Intel-Core-i3 CPU; 2.27ghz; 4GB RAM; Intel HD Graphics (CPU based)


* August 14, 2019, 04:37:10 PM
#4
Thank you Alvin. I can get that example to work and at least that gives me confidence in how the tool works. What I need to do now is work out how to search for a specific surface area or volume of a solid. I will post a sample drawing.

Regards  John

Logged
Core i7-6700 CPU
16GB Ram
64 Bit
Windows 10 Home
TurboCAD 2015 Pro Platinum 64 bit Build 90.0


* August 14, 2019, 04:50:33 PM
#5
In the attached drawing there are two solid objects that are quiet similar but not identical. In a typical drawing that I work with there could be 30 occurrences of one and 12 occurrences of the other, and also other very similar solids. What I would like to be able to do is search for and identify all occurrences of each different solid. I think I would like to be able to search by volume or surface area.

Logged
Core i7-6700 CPU
16GB Ram
64 Bit
Windows 10 Home
TurboCAD 2015 Pro Platinum 64 bit Build 90.0


* August 14, 2019, 05:16:25 PM
#6
Don't you want to just make each of those Objects a Block.
Give each of those Blocks a particular Name.  Then insert, and Copy, those Blocks.
Thay way you could Query by Block Name. And you would save on file size.

Someone(s) that can open a 2015 file will come along and give you more specific suggestions; I max out at version-21.

Logged
Alvin Gregorio
(mostly Residential Architectural 2D; no formal CAD Training; intermittent TurboCAD user since yr. 2000 [ver6.5])
---TurboCAD: V20.2PP(57.0)[as of 3/12/15]; V19DL(54.2); V11.2Pro; Windows-7-Pro/64-bit; Intel-Core-i3 CPU; 2.27ghz; 4GB RAM; Intel HD Graphics (CPU based)


* August 14, 2019, 05:35:30 PM
#7
Yes Alvin that's what I would do if I created the drawing but the problem is that I didn't create the drawing and the designer that created it has either not used blocks or has exploded them prior to releasing the drawing for use. I might contact him and ask if he can provide the file with blocks intact. I'll attach a V19 file.
Thanks John

Logged
Core i7-6700 CPU
16GB Ram
64 Bit
Windows 10 Home
TurboCAD 2015 Pro Platinum 64 bit Build 90.0


* August 14, 2019, 08:56:37 PM
#8
Something that would work is to insert the number in the "Attribute" field of the 3D object.
Then use 'Info'='64762.638' in the Query.

Logged
John R.

V17—V21, 2015—2019
Designer, Deluxe, (Professional, Expert, Basic), Platinum
RedSDK enabled
Windows 10 Pro (1803), 64-bit


* August 14, 2019, 09:15:10 PM
#9
Similarly to John R., I did it by entering the Volume and/or Surface Values in the Objects' Properties' Custom page.

But that's probably not what you're after; you probably want to be able to open up the imported file and just immediate Select By Query and have what you want selected.

I couldn't find "Volume" or "Surface" Criteria in the Selection by Query.

Logged
Alvin Gregorio
(mostly Residential Architectural 2D; no formal CAD Training; intermittent TurboCAD user since yr. 2000 [ver6.5])
---TurboCAD: V20.2PP(57.0)[as of 3/12/15]; V19DL(54.2); V11.2Pro; Windows-7-Pro/64-bit; Intel-Core-i3 CPU; 2.27ghz; 4GB RAM; Intel HD Graphics (CPU based)


* August 14, 2019, 09:19:50 PM
#10
Maybe Color will suffice.  Any chance we can get a Drawing file just as you get it, at the point in which you want to make the Query.
A version-19, 20, or 21 for me? ;D

Logged
Alvin Gregorio
(mostly Residential Architectural 2D; no formal CAD Training; intermittent TurboCAD user since yr. 2000 [ver6.5])
---TurboCAD: V20.2PP(57.0)[as of 3/12/15]; V19DL(54.2); V11.2Pro; Windows-7-Pro/64-bit; Intel-Core-i3 CPU; 2.27ghz; 4GB RAM; Intel HD Graphics (CPU based)


* August 14, 2019, 09:25:25 PM
#11
Similarly to John R., I did it by entering the Volume and/or Surface Values in the Objects' Properties' Custom page.

But that's probably not what you're after; you probably want to be able to open up the imported file and just immediate Select By Query and have what you want selected.

I couldn't find "Volume" or "Surface" Criteria in the Selection by Query.

The "Custom" page was my first thought, but wasn't sure if the other party had something like that in their program. I think everybody has an Attributes/Info section.

Logged
John R.

V17—V21, 2015—2019
Designer, Deluxe, (Professional, Expert, Basic), Platinum
RedSDK enabled
Windows 10 Pro (1803), 64-bit


* August 14, 2019, 10:54:05 PM
#12
Thanks for all your effort here Alvin and John. The method I use now to identify these items is similar to your suggestions. I go over the whole model and add the surface area or volume to the selection info which allows me to then do a count. In an effort to try and speed this part of the process up I thought that if I could search for the items by volume or surface area, I could then temporarily group each different set and therefore eliminate them from the rest of the search until I had located all the different ones. Colour does help me to some extent because the designer uses different colours for different parts but there are always many other items the same colour.
I'm sorry but I can't attach the model as I have signed an agreement to not allow access by others.
I find it frustrating that I can search for 2D items by surface area (circles, rectangles etc.) but not ACIS solids.
Again thank you both for the time you have put into this, it's much appreciated.

John

Logged
Core i7-6700 CPU
16GB Ram
64 Bit
Windows 10 Home
TurboCAD 2015 Pro Platinum 64 bit Build 90.0


* August 15, 2019, 06:00:37 AM
#13
Seems to me that the most efficient way this should be done from the get-go-- the CAD way-- is for the original creator to make them named Blocks-- before inserting multiple copies of them (or inserting the initial Blocks and copying those).  And/Or, at the very least, assign them an Info attribute before copying them.

Logged
Alvin Gregorio
(mostly Residential Architectural 2D; no formal CAD Training; intermittent TurboCAD user since yr. 2000 [ver6.5])
---TurboCAD: V20.2PP(57.0)[as of 3/12/15]; V19DL(54.2); V11.2Pro; Windows-7-Pro/64-bit; Intel-Core-i3 CPU; 2.27ghz; 4GB RAM; Intel HD Graphics (CPU based)


* August 15, 2019, 07:32:52 AM
#14
It could be the way the original program saved and the way TC converted it.

Logged
Nikki
TC20 platinum
TC 2015 platinum
TC 2017 with lightworks


* August 15, 2019, 02:48:43 PM
#15
I couldn't agree more Alvin. That is a possibility Nikki, I receive the model as a DWG. I will see if I can talk directly to the designer.
Thanks for all the help.
John

Logged
Core i7-6700 CPU
16GB Ram
64 Bit
Windows 10 Home
TurboCAD 2015 Pro Platinum 64 bit Build 90.0