ModelManager Search Enhancements

[PeterKehoe]

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").

[MaxKublin]

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]

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]

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]

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]

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]

Max, I am interested in this functionality

[lfortner]

I'm too, Max.

[MaxR.Kublin]

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]

Hi Max,

I'm also interested in this functionality.

Would you please contact me for an offer?

Thanks,

Thomas

[thollerweger]

Apart from that I have described a practicable suggestion here: ModelManager: Advanced Query Options: [isnull]; [notnull]; [0..9]; [a..z]; [1;3;5;a..z]; A[1..9]z*;

[MaxR.Kublin]

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.