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.

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.

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

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

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:-

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.
 

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:-

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

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.

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.

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