Double spacing issue on query

rbross

Hello,
When I run this query it is display double spaced it looks like.
Wondering if any know what would cause this?
There are no images or Document types in this BO.
Looking at the font on description looks a bit off wondering if that has something to do with it?
See attached screen shot

BenHayat

Just to rule one thing out, can you change the theme and run it again? I've noticed different theme impose different spacing.

rbross

I did try that and there was no change.
Also I am running the latest service pack.

BenHayat

rbross wrote
I did try that and there was no change.
Also I am running the latest service pack.

Ross, can you take a screen shot of your query configuration and post it here? Are you using Unlimited? If yes, changed it.

BenHayat

On the "Width" part, can you clear it to take the full width and see if that would change it?

rbross

not using unlimited rows, rows to show is set to 10.
I will remove the width and see if that changes anything.
thx

BenHayat

A while back, I had a query that did not behave normal and couldn't see anything wrong with it. So, just to make sure my data was good, I created a new query based on the same specs and worked perfect. Deleted the old one. You may want to try that as well.

rbross

I will try that, This query was actually copied from another one. I will create it from scratch and see what that does...

BenHayat

rbross wrote
I will try that, This query was actually copied from another one. I will create it from scratch and see what that does...

Let us know the result...

hpl123

Rbross,
Another thing, this could be html in one of the attributes. If have a linebreak somewhere it could be reflected in the Query presentation / row.

rbross

I thought of that as well. but i don't think there is a field they would use the return key on.
One thing I don't think I mentioned id this data was created from an external table. So it was not added in AwareIM via the Add New button.
I created a process to read the external table then did a CREATE BOName WITH.....

BenHayat

Roger, were you able to find the cause of the problem?

rbross

Not yet I had to go back to work!
I will look at it again later today and report what I find.

Thanks for the followup.

BenHayat

Try what I suggested with creating a new one. that has helped me before getting into goose chase.

rbross

Creating a new query did not resolve the issue.
Maybe there is a return code some place in the data.
Do you know the expression to use to strip out any special characters?

tford

I would try eliminating the five text attribute columns to see if that solves your issue. Assuming that solves it, add them back one by one to narrow it down.

rbross

I deleted all the data and created two new records via Add New and still double spacing on the query.
Tom, why would one of the 5 text columns be an issue?

BenHayat

rbross wrote
I deleted all the data and created two new records via Add New and still double spacing on the query.
Tom, why would one of the 5 text columns be an issue?

What Tom was saying to introduce ONCE column at a time in query to see which column [field in table] may have a CR or </br>.

Also when you display the two records on the screen, do a "View source" and see for each row of you see </b> in any of the columns.

rbross

Since I have never seen this issue before I wanted to see if it was just this BSV or all of them?
I went into an other BSV and it is doing the same thing on queries.
Must be something related to AwareIM then and not just the single BSV.

tford

Have you tried loading one of the sample apps?