IQA

Reading IQA queries from SQL

Does anyone know if it's possible to retrieve/run an IQA query from a SQL script? I was hoping we could query the Blob field in the DocumentMain table to retrieve the SQL script for a particular IQA query, but it doesn't look like the Blob data for DocumentTypeCode='IQD' is stored in XML format, so I'm not sure how to encode/retrieve the data.

We want to do this so that an IQA query can be executed as part of a SQL job or stored procedure so that the users can maintain the query, but we can leverage it for back-end processing.

Passing ID as paremeter in IQA to SSRS and Back

I am creating some reports for a client that are easy enough to do - I have created the query in IQA but there is one parameter, and that is the ID of the person running the report. For now, I have hard coded an ID - I could have the user enter their ID but ideally I would like to get their login name, run it against the contactmain table to get the ID and use that as the resulting value.

I was hoping to be able to do this using IQA, saving to RDL, going into BIDS, formatting the report, importing the template, creating the report, and then creating the content. I have a feeling it's not going to be that simple. I know once I touch the SQL code, I cannot use the iMIS template system.

IQA - Display Tab - SQL Expressions to control how output is displayed

We're using 15.2.15.4667.

I have a query (IQA) which presents via iPart a listing of customer's 'Specialties'.  The data is maintained in a custom table which the customer updates using checkboxes.  The db stores this as either 1 or 0 (True or False)

Currently the output displays as something like:-

Example 1

Breast Cancer True
Palliative Care False
Paediatrics True
Education False

and I would, at a minimum, prefer the display as:-

IQA - Concatenating Fields and Text as SQL expression

We're using 15.2.15.4667

Have an IQA query and wish to display concatenated output using a SQL expression on Display tab.

I can get plain text to display.  For example, entering 'My test text' in quotes displays as expected.
I can get a field from my business objects to display.  For example, entering 'vBONetContact.FirstName' (without quotes) also works.

Attempts to concatenate both text and variables fails.  My syntax is in the form:-

IQA that uses an SQL function?

 

Hi All,

We have some add-hocs that use SQL functions to limit the data set, but now we want to put these into IQA but at a glance I thought I could do this but now seems it can’t.

So Is that actually possible at all, or am I correct in my thinking that I need to create a view based on what the function was looking for, and then import that as a BO and link that way.

Thanks.

Lance.
 

Display 'public profile' page based on iQA search result

Hi,

We are building a new WCM site in 15.2.15.4667 version.

We created an iQA and used the query menu iPart to display in the WCM. All went good but when we click on the search result, we wanted the perseon performing the search to be able to view the 'Public Profile' of the search result but instead it gives me an 'Access Denied' error.

There are certain points to be considered:-

Drop Down menu for a UDT in iQA

Hi,

We are developing a search functionality for our client. The public needs to be able to perform a search for a 'Translator' from one language to another. I've set up a custom table in iMIS with 'Multiple Instances Allowed' option and also the validation from the General Look up containg about 50 language options.

I'm createing an iQA query to be able to perform this and implement the iQA in WCM. I got it to work except the fact that there is no drop down option available for users to select the languange but they have to type it in manually like:-
------------
From = Chinese
To = English
------------

Is there anyway I can get the drop down menu in the iQA for selecting the language?

Thanks,
Vig

"Desktop Home" Customisations and providing staff with information about IQAs

We are starting to look to use the imis "Desktop Home" page as a communication tool for our iMIS users about what is new (e.g. new IQA's, new Reports) etc.

We are currently on 15.2.1.3282.

We do have a Corporate Intranet, but I'm thinking may be better to centralise this type of information in iMIS.

What I'm wondering is how others tell users about new IQAs they are available and also the documentation around the IQA.

Profile Pictures IQA

I have a client who would like to display a list of committee members via IQA and use their "Profile Picture", along with their name, title, etc. I have found the Name_Picture table, a good start I suppose - but how would I get the actual profile picture to force into an '<img src="{{path/to/profile/photo.jpg}}"/>' in the IQA? I was hoping that the Query Profile Picture List iPart would be a little more useful, but that just shows the profile images and none of the other elements in the IQA query.

Disable "Show all 500" results on QueryMenuCommon ipart that displays results of an IQA

Hi,

How can I disable the "Show all 500" results link on a particular QueryMenuCommon ipart that displays results of an IQA.

Using 15.2.1.3282 and ASI tech support say they cannot assist.

Thanks,

Scott