Search found 65 matches

by fbrano
2021-06-11 06:29
Forum: Advanced Customizations > Hooks
Topic: Filter Lookup Value
Replies: 5
Views: 240

Re: Filter Lookup Value

Great advice, it works as needed. Thank you.
by fbrano
2021-06-08 14:09
Forum: Advanced Customizations > Hooks
Topic: Filter Lookup Value
Replies: 5
Views: 240

Re: Filter Lookup Value

Great, I wonder how to implement also check for user's group into condition wtith status of lookup field. Thank you in advance var stav = $j("#Stav_pristupu option:selected" ).text(); if((stav == "ziadany")) { for (var i = 0; i < $j('select#Stav_pristupu option').length; i++) { if ($j('select#Stav_p...
by fbrano
2021-02-17 06:24
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85563

Re: Audit Log

c:\>php -v
PHP 7.4.5 (cli) (built: Apr 14 2020 16:17:19) ( NTS Visual C++ 2017 x64 )
Copyright (c) The PHP Group
Zend Engine v3.4.0, Copyright (c) Zend Technologies
by fbrano
2021-02-09 18:38
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85563

Re: Audit Log

Server running on php 7.3 or 7.4, but what about syntax, is'nt it wrong?
by fbrano
2021-02-09 14:20
Forum: Tips And Tricks
Topic: Audit Log
Replies: 99
Views: 85563

Re: Audit Log

Hi Olaf,
what does mean this warning after opening plugin?
by fbrano
2021-01-30 01:37
Forum: Tips And Tricks
Topic: How to set TV at the same row which ID was edited in DV?
Replies: 7
Views: 572

Re: How to set TV at the same row which ID was edited in DV?

I do not see any changes in behaviour of TV after going back from editing record in DV.
by fbrano
2021-01-27 09:50
Forum: Tips And Tricks
Topic: How to set TV at the same row which ID was edited in DV?
Replies: 7
Views: 572

Re: How to set TV at the same row which ID was edited in DV?

After close Detail View of the some ID how to set active the row with the same ID at the Table View.
by fbrano
2021-01-27 08:59
Forum: Tips And Tricks
Topic: How to set TV at the same row which ID was edited in DV?
Replies: 7
Views: 572

How to set TV at the same row which ID was edited in DV?

How to set TV at the same row which ID was edited in DV?
by fbrano
2020-12-11 11:33
Forum: Getting Started
Topic: Access Admin Area
Replies: 11
Views: 3766

Re: Access Admin Area

I know that blog, also tested it several times on 5.8x versions, but with no success.
by fbrano
2020-12-10 06:30
Forum: Getting Started
Topic: Access Admin Area
Replies: 11
Views: 3766

Re: Access Admin Area

for ver. AppGini 5.91
Edit file /admin/incFunctions.php function getMemberInfo($memberID = '') {

//'admin' => ($adminConfig['adminUsername'] == $memberID ? true : false),
'admin' => ($row['groupID'] == 2 ? true : false),

Many thanks for solution to my colleague Greg
by fbrano
2020-12-07 19:43
Forum: Getting Started
Topic: Access Admin Area
Replies: 11
Views: 3766

Re: Access Admin Area

Why pböttcher's solution does not work on ver. 5.91?
by fbrano
2020-09-28 07:59
Forum: Advanced Customizations > Others
Topic: sorting in tablename_view.php
Replies: 4
Views: 4257

Re: sorting in tablename_view.php

Also working via hook file tablename.php

function tablename_init(&$options, $memberInfo, &$args){

$options->DefaultSortField = '3';
$options->DefaultSortDirection = 'asc';
by fbrano
2020-09-11 21:57
Forum: Advanced Customizations > Others
Topic: filtering records by login.
Replies: 14
Views: 10432

Re: filtering records by login.

Here is correct syntax,

$x->QueryWhere = 'where `Pristupy`.`Schvalovatel`='.$memberInfo['custom'][1].'"';

but query is empty, isn't it because of Manazer field is lookup field?
by fbrano
2020-09-10 19:58
Forum: Advanced Customizations > Others
Topic: filtering records by login.
Replies: 14
Views: 10432

Re: filtering records by login.

This code is without syntax error, but no records shows as result in query

$memberInfo = getMemberInfo();
$osc = $memberInfo['custom'][1];
$x->QueryWhere = 'where `Pristupy`.`Ziadatel`="$osc""';
by fbrano
2020-09-10 19:17
Forum: Advanced Customizations > Others
Topic: filtering records by login.
Replies: 14
Views: 10432

Re: filtering records by login.

Here is my code:
$memberInfo = getMemberInfo();
$x->QueryWhere = 'where `Pristupy`.`Manazer`="{$memberInfo['custom'][1]}""';

Still with error:
( ! ) Parse error: syntax error, unexpected 'custom' (T_STRING) in D:\wamp64\www\elp\Pristupy_view_revizia_ziadatel.php on line 142
by fbrano
2020-09-10 18:41
Forum: Advanced Customizations > Others
Topic: filtering records by login.
Replies: 14
Views: 10432

Re: filtering records by login.

I'd like to use $memberInfo['custom'][1] variable, but have porblem with sytax:

$x->QueryWhere = 'where `Pristupy`.`Manazer`='{$memberInfo['custom'][1]}'"';

( ! ) Parse error: syntax error, unexpected '{'

Thank you
by fbrano
2020-08-17 11:37
Forum: Tips And Tricks
Topic: Switching the rolle in AppGini Application
Replies: 6
Views: 4197

Re: Switching the rolle in AppGini Application

My generated csv file with list of users ended up at the first line with 1024 characters. From all possible users I got to choose only from fraction of them... any idea why?
by fbrano
2020-07-31 12:19
Forum: Advanced Customizations > Hooks
Topic: Conditional format that recognizes > than or ≤
Replies: 4
Views: 1307

Re: Conditional format that recognizes > than or ≤

console said undefined, but still no collour
by fbrano
2020-07-31 10:00
Forum: Advanced Customizations > Hooks
Topic: Conditional format that recognizes > than or ≤
Replies: 4
Views: 1307

Re: Conditional format that recognizes > than or ≤

How to format condition for Null value? Neither of these conditions works:
var status = $j(this).text();
a) if(status == 'Null'){
b) if(status == Null){
c) if(status == ''){
by fbrano
2020-03-18 19:17
Forum: Advanced Customizations > Others
Topic: How to fill the third table by missing combination of values from the other two tables?
Replies: 4
Views: 7621

Re: How to fill the third table by missing combination of values from the other two tables?

I created a view by the last select and I would like to add it as lookup advanced sql query or as a separate paralle window where user can select which row would like to add from parent table to newly inserted record in child table.
by fbrano
2020-03-10 21:43
Forum: Advanced Customizations > Others
Topic: How to fill the third table by missing combination of values from the other two tables?
Replies: 4
Views: 7621

Re: How to fill the third table by missing combination of values from the other two tables?

Finally I have found the solution, here is link to the great place for testers of coding in many programming languages: https://rextester.com/discussion/ZOLIGE34706/How-to-fill-the-third-table-by-missing-combination-of-values-from-the-other-two-tables- Create table syst( sid int IDENTITY primary key...
by fbrano
2020-03-07 22:01
Forum: Advanced Customizations > Others
Topic: How to fill the third table by missing combination of values from the other two tables?
Replies: 4
Views: 7621

How to fill the third table by missing combination of values from the other two tables?

I figured it out how to prepare a selection, but I do not know how to implement it in table tsoa lookup field definition in AG in order values will offer only desired requirements according category of preselected system. And the most user friendly solution should be if it can be reduced to the list...
by fbrano
2019-11-28 07:43
Forum: Feature Suggestions
Topic: Filter which compare two fields in the same table
Replies: 3
Views: 4007

Re: Filter which compare two fields in the same table

How to implement command line which works in phpMyAdmin: SELECT DISTINCT Pouzivatel, (SELECT Pouzivatel FROM `pouzivatelia` WHERE Osc = pristupy.Pouzivatel), (SELECT Pouzivatel FROM `pouzivatelia` WHERE Osc = (select Manazer FROM `pouzivatelia` WHERE Osc = pristupy.Pouzivatel)), (SELECT Pouzivatel F...
by fbrano
2019-11-27 22:39
Forum: Feature Suggestions
Topic: Filter which compare two fields in the same table
Replies: 3
Views: 4007

Re: Filter which compare two fields in the same table

Create table Streets( ID int IDENTITY primary key, Name varchar(100) ); create table users( ID int IDENTITY primary key, Username varchar(100), StreetID int references Streets(id), OldStreet varchar(100) ); insert into streets values ('1st street'), ('2nd street'), ('3rd street'), ('4th street'), ('...