Sync with a fictitious SQL Server database

The fictitious SQL Server back-end database contains contact information (companies, contacts, record status, etc). It is used as part of a secure web-site, where users can view/modify their information. The managing organization already uses InfoQube for CRM type information and wanted to link to the web-site information as its agents were answering calls/emails.

The following configuration file can be used:

<ConnectionString>PROVIDER=SQLOLEDB.1;PASSWORD=SomePassword;PERSIST SECURITY INFO=TRUE;USER ID=SomeUser;INITIAL CATALOG=YourDataBase;DATA SOURCE=SQLServerIP;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096
</ConnectionString>

Citation parser anyone ?

Submitted by Pierre_Admin on 2017/07/04 08:55
Hi IQUsers !
 
Anyone interested in a built-in citation parser (user customizable of course) ?
 
The idea would be that you could select an article reference, clip and the Add Item dialog would recognize a citation and fill-in fields for you. From the PMID, it would be able to detect duplicates.
 
 
---------------
Freedman SB, Adler M, Seshadri R, Powell EC. Oral ondansetron for gastroenteritis in a pediatric emergency department. N Engl J Med. 2006 Apr 20;354(16):1698-705. PubMed PMID: 16625009.
---------------
 
Interesting idea or not ?

Grid Source EditBox

 

Source

  1. Source Box
  2. Dropdown for the Source Box

The Source is the first level of filtering. That is, of all the items in your IQBase, the Source sets which ones to show. Further filtering (Filter, Alpha / Date filter, column filter) can limit even further what items are shown, but the Source is the first level

Source can be as simple as a single field or a single tag, such as AddressBook, or #News. But it can be more than just a field / tag name, in fact it's also a filter. It's the query that indicates what items are selected for the current Grid.

For example, instead of just AddressBook you could put AddressBook and Archived is null to only show unarchived contacts.

Filtering the Grid Source

The grid source filters items to show only items matching the source. It mimics the "folder" concept, with the added advantage that if can also be a more complex source (e.g. (Field1 OR Field2) AND Field3)
 
An additional filter can be toggled on / off and has a dropdown list of recently used filters:
 
 

1. Filter Box Syntax

Filter Syntax is close to Transact-SQL syntax.
 
The best way to learn it is to experiment using Live-Search which can generates the filter string for you. For that you can either:
  • Invoke the Live-Search (View > Live-Search).

Properties > All Fields - live filtering of fields list?

Submitted by jimspoon on 2017/06/30 05:52
I'd like to be able to apply a "live filter" to the All Fields list in the Properties Pane.  It would provide a quick way of finding fields that I want to assign to the current item.
 
I notice that the Field Properties window (Tools > Manage Fields) can already be filtered by field name, by clicking on the tiny underscore at the right of the "name" header.  Wildcards are supported in this filtering, but the filtering is not live, i.e. you have to press Enter to see the fields that meet the field name filter.
 
 

Filesize regularly/disproportionally increasing [have you seen this?]

Submitted by Tom on 2017/06/30 05:18
 
Wondering has anyone else noticed a steady increase in filesize disproportionate to the new data added to the file ?
 
Naturally, filesizes increase, but with my active file, I add very little to it on a daily basis - maybe a couple of text emails, and a couple of new (text) items per day.
Yet, it increases steadily in size - last time I checked, from 4 or 5MB to over 30MB i.e. when it is compacted it goes back to ~ 5MB, then it increases at a rate I'm not sure of (I guess at over 5MB per week).

Item Join and Split

Content is often entered in a hurry and some re-organizing may be required later on. These include:
  • Join 2 or more items into a single one
  • Split one item into 2 or more items
Currently the only view that supports Join and Split is the Grids.

1. Joining Items

  1. In a grid, select 2 or more items
  2. Item > Join Items.... (Ctrl + Shift + J)
Subscribe to