IQA

Customer Portfolio screen is not active when IQA returns results

I have attached a link to a brief video that demonstrates this issue.

Essentially, when using an IQA query that has been set up to return details to the Customer Portfolio, the query runs, the list is generated in an IQA window and a record is selected.  When this occurs, the results set is returned to the results  pane in the imis customer portfolio, but the cust portfolio is completely inactive.  You cannot enter a new record, select a record from the results set, no record is returned to the customer screens, etc.

Can we create our own "preconfigured security set"?

When we export a document (IQA query, business object, content, content type, etc.) today, if that document has custom permissions it will not import into a database that didn't already have that content with custom permissions.  This comes up in the following scenarios:

  • Create a new query in Dev, set permissions, test, copy to production.
  • Create a generic iPart with permissions, import to new clients.
  • Modify the ACL for a query to include a new Role in Dev, then import to Test.
  • Import new Nav items we've set up in Dev.

Beside all that, we often have to apply the same permissions over and over to multiple items.  Having our own predefined security sets would make this a lot simpler.  (It would also keep the Access* tables from growing excessively, since each "custom set" is assigned its own key.)

IQA Drilldown

We have an IQA that members can use to search for other members who fit a particular criteria - based upon specialty.  We want to then be able to select one of the returned company records and then drill down to another IQA that would list all that members areas of expertise.  Is that something that can be done?  I know we can like back to the actual ID and member record, but we want to drilldown to another report.

SQL User_names in 10.6 are what in 15.1

Hi people.

In 10.6  our users run an ADHOC query to identify which records they have touched during the day to produce labels to post out their results..

In this case the Name_Results_Summary  table where their username is entered into the table in the updated_by field.

Here is the username element fo the adhoc..

Name_Results_Summary.UPDATED_BY = Substring(user_name(),1,Case when charindex('_',user_name()) > 0 Then charindex('_',user_name())-1 Else len(user_name())End )

Is there any way to match to a value in an IQA LEFT JOIN sources clause?

Hi,

I have two NetContact Business Objects, holding firms and employees, linked via a CsRelationship Business Object. I want to first collect all the firm records in  which have the relation type 'CR_PARTN', and I particularly want to keep track of firms that DO NOT have a relation of type 'CR_PARTN' (for them, the CsRelationship.Relation field will be NULL). I then want to link all of these firm records on the left-hand side to the employees in the second NetContact, matched by CsRelation. I should hopefully end up with a collection of firms linked by the relation CR_PARTN to employees and some firms with NULL relations, meaning that they do not have any CR_PARTN relationship with any employee.

ASI IQA iPart errors

Problem Description

 
We have loaded the ASI IQA Viewer as a webpart (the one asi created). I added this ipart to a content record, published, added a navigation item and linked it to this content record and published. Everything publishes fine but when I go to the page (and on the ipart configuration) we get the following error:

############## ERROR ##################

Unable to process your request!
Incorrect or Unknown source query! Please verify that IQA Query: $/Library/Reports/Chapter Roster exists and (or) you have enough permissions to run it!

#######################################

The query exsits and I can run it from this location. I am logged into the staff website imis15 as manager and getting this error....How do I troubleshoot this?

Unwinding Customizer fields with BOD

I've hit a little snag with UD_Tables, and I'm not sure the best way to recover.

I'm in a prototype database for a rather large client (implementation in progress).  Early in the design, we added a number of UD tables with the fields they wanted.  In addition to the standard business objects (e.g. CsName_Demo), we created a couple of custom ones.

As the prototype evolved, we discovered some of the fields weren't needed anymore.  Our normal MO for removing fields (bad habit, I know) is to remove them from Define Tables, then touch all the windows based on those tables, which cleans up the orphaned fields.  This time, we got a PK violation on UD_WindowFields.  Apparently, iMIS now only deletes rows from UD_WindowFields if they exist in UD_Field.  I cleaned up the orphaned fields through SQL and the windows worked OK.  That problem is solved, and desktop iMIS is (mostly) happy.

IQA Web Service

Having Don Robertson in town (Melbourne, Autralia) has already been beneficial and he's only been here for a few hours.  One of the things we have been struggling with for a while now is how to use the IQA Web Service to call an IQA query with parameters and get a filtered result set as a response.

The key problem in the past has been trying to find information on how to pass the parameters into the query service, Don was able to set us straight, so here is the information you need.

IQA

Hi Guys,

Does anyone know how I can increase the number of rows returned per page in IQA??

The standard output is 10 rows per page, I would like to increase this to say 25 or 30.

Regards

IQA in the Casual iMIS view

How can I set up an IQA for the casual web view with the export feature? Has anyone done this before?

Patti