Search
You searched for the word(s): %27
-
I am glad that your issue is resolved now.
-Inder
-
Hello kefpa01,
According to your requirement the code should look like this. In this code it is looking for value on the grid column and comparing it with screen.
CASE WHEN viewActivity.DueDateEnd < ScreenValue THEN '<font color="red"><b>' + Entity + '</b></font>'
WHEN ...
-
Of course. QB does not let you use more than 5. There's no option to add more.
Anyway, it eventually worked. I'm not sure why it didn't work the first time.
Perhaps there was a syncing lag/issue.
-
The SQL Override is on the grid column DueDateEnd and I want to compare it to a value on the screen called 8DaysAway. So, I'm wanting the override to look something like this.
(CASE WHEN [DueDateEnd] < 'screen value 8DaysAway' THEN ... ) Where 'screen value 8DaysAway' is a date on the screen. How do ...
-
Hello kefpa01,
You syntax should look something like this:
(CASE WHEN [DueDateEnd] < viewActivity.8DaysAway THEN '<font color="red"><b>' + Entity + '</b></font>'
WHEN [DueDateStart] < viewActivity.8DaysAway THEN '<b>' + Entity + '</b>'
ELSE ...
-
Hello MikeB,
There first thing I would check is how many custom fields you have in your QB file. The item list has a limit of 5 custom fields in Pro and Premier version. In Enterprise (starting with V10) you can add up to 15 custom fields in the item list.
Please check it and let me know if that is the issue.
-Inder
-
Yes, 8DaysAway is a date field on a screen and the comparison field is a grid field from the Activity table
-
Hello theSolarguys,
Is this happening for all users or just one specific user? Is it just happening on calendar or overall Method is slow? Did you try using different browser?
-Inder
-
This week Method has been going very slow and freezeing on calendar refreshes. You have to refresh the browser in most cases because the Method loading symbol won't go away.
-
I created a custom field in QB:
The label/name is "SPECIAL ORDER"
When I export the IIF file from QB for the Items table, the field has the official name "CSTFLD4"
In Method, the Column "SPECIAL ORDER" shows up in the Items table, which is good.
However, as a test, I populated an item in QB with a ...
|
|
|