cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

ModelManager Search Enhancements

ModelManager Search Enhancements

I would like the ability to do enhanced searches in ModelManager.

First, I would like to do searches where I look for all attributes that do not meet a certain condirion rather than meet one. For example, I would like to find documents that are NOT in a particular state ("! released").

Second, I would like to have searches where an attribute can be one of a couple of options. For example, I would like to find documents that are in either of two states ("released | support").

12 Comments
MaxKublin
1-Newbie

I think all of your requirements are covered by the query capabilities of the WM kernel (aka WM classic). Unfortunately, the MM U/I does currently not allow all query capabilities of the underlying

WM kernel since it does some processing/filtering of the input.

PeterKehoe
5-Regular Member

Max, you are right that it is possible in the WM classic, but I want to see this in the ModelManager U/I. I should have specified that.

MaxKublin
1-Newbie

Pete, it was clear from the beginning that you want to have the capability in Model Manager.

My point was that the capability of WM classic is *basically* also available in Model Manager,

since both products are based on the common WM kernel.

It is really just the MM U/I (=the Java code parsing the input) that does not allow everything

possible by the underlying WM Kernel.

For someone with experience in MM customizations it would be possible to develop

a U/I that allows everything that is available in the WM classic.

However, I fully understand and support the request to have this in the OOTB Model Manager.

The (limited) query capabilties are one of the last areas where MM is behind WM classic.

MaxR.Kublin
11-Garnet

Pete,

Meanwhile I have developed a "Saved Search using a  SQL Query" in Model Manager,

which is even more powerful than the existing functionality of the Workmanage U/I

If you are interested in this functionality, get in touch with me.

Regards,

      Max

MaxR.Kublin
11-Garnet

Pete,

After digesting my recent response, the following would be the perfect enhancement:

Provide possibilty to define/edit a SQL QUERY as a saved search.

This would satisfy all requests listed in this thread.

Implementing the feature is fairly simple - would give experienced users the possibilty to query "everything".

Max

PeterKehoe
5-Regular Member

Max, I am interested in this functionality

lfortner
9-Granite

I'm too, Max.

MaxR.Kublin
11-Garnet

Louis and Pete,

Well, I possibly set the expectations too high.

Same as  Louis, I am in the Consulting Business now, and that means: earning mony with custom solutions - one is a SQL Query as Saved Search.

Therefore, I will contact you directly instead of posting the complete solution in this Community.

Developing the solution took quite a bit of brainwork and effort, and I don't want to disclose this for free.

Thanks,

      Max

thollerweger
5-Regular Member

Hi Max,

I'm also interested in this functionality.

Would you please contact me for an offer?

Thanks,

Thomas

thollerweger
5-Regular Member
MaxR.Kublin
11-Garnet

As mentioned above, I am in the Consulting Business now, so the Community is not the place to post the solution I developed.

With a "saved SQL query", queries are possible that are (even) not available in WorkManager.

To give you some ideas, the following (and more) is possible via SQL:

- List Models that have no Masterdata

- List Masterdata that has no Model (Drawing etc.)

- List isolated/orphaned models (no parents, no children)

- List Models that have (or do not have) associated drawings

- List Models that have (or do not have) up-to-date thumbnails, PDFs etc.

......

The power of SQL is that you can combine several tables (e.g. elements + links) to produce a list of results (and show that in MM !)

Everyone having a *true* interest in this functionality may contact me directly to discuss a consulting Project/Workshop.

PTCModerator
Emeritus
Status changed to: Archived