Forum Replies Created

Page 9 of 20
  • Andreas Pfeiffer

    Administrator
    April 10, 2024 at 9:22 am in reply to: How to rebuild columnpicklist

    Martin,

    I think what you want to have is a picklist with different data on each line of your grid?

    I don’t think this is what the datagrid is able to do. You should probably use a complex grid for this instead.

    I made you a quick sample (attached) that shows how you can achieve this using a complex grid instead. Note that the pick_list is going to be a column within the main list. That allows individual content of the picklist depending on the type of the data in the main list.

    As an additional feature I added a page pane object that is controlled due to a column in the main list “type”. Check out the $dataname of the page pane object. So depending on the value of the type column in the main list it will switch the page accordingly. I placed two different icons on either page. I was using the “car” icon to indicate it is a vehicle (car, truck or motorbike).

    Hope this helps. Let me know if there are additional question.

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    April 9, 2024 at 12:13 pm in reply to: js data entry error

    What version of Omnis Studio 11 are you using? Do you use the latest build? 36251?

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    April 9, 2024 at 12:09 pm in reply to: js data entry error

    Hi Martin,

    Can you double check if you use the same version of Omnis Studio JavaScript resources as you have on your web server?

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    April 9, 2024 at 7:06 am in reply to: How to rebuild columnpicklist

    Hi Martin,

    In the samples section there is a JS Data grid and a JS Data grid formatted. But none of them is using a droplist.

    Can you please specify what library you refer?

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    April 1, 2024 at 12:02 pm in reply to: Reading Postgresql schemas and Omnis schemas

    Hi Martin,

    If using schema classes you would need to prefix the schema class name in the “server table or view” field of the schema class.

    The $sqlclassname property of the table class should take the name of the schema class.

    Hope this helps.

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    March 21, 2024 at 2:59 pm in reply to: Closing an additional library closes the main window

    Robert,

    would you let me know what steps are required to reproduce this problem? Do I need to open both libraries? When I run the Export Library button it simply closes the library.

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    March 21, 2024 at 11:04 am in reply to: Closing an additional library closes the main window

    Hi Robert,

    can you upload a sample lib that shows the problem?

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    March 21, 2024 at 10:02 am in reply to: Closing an additional library closes the main window

    Hi Robert,

    Yes. Try to add “().$fullname”

    Note, the parentheses.

    For example: calculate myTextVar as $cinst().$fullname

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    March 18, 2024 at 1:22 pm in reply to: Closing an additional library closes the main window

    Hi Robert,

    This could be because the window instance that you are talking about is probably running inside the task instance of the library that you close. Although the window class may sit in another library the instance can live in a task of another library. This is all about who has opened the window instance. If the instance that opened that window is also part of the task instance the new instance will be in the same task instance. Etc.

    You can find out if you check what the current task instance is using $ctask().$name (note the parentheses). That gives you the name of the current task instance.

    If you want to make sure to open the window instance in another task instance you would need to open the window instance either directly from the $construct of that task or from another instance (menu etc.) that was opened from that $construct.

    I hope that makes sense.

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    April 10, 2024 at 9:57 am in reply to: How to rebuild columnpicklist

    Martin,

    Just get the new Community Edition.

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    April 9, 2024 at 2:49 pm in reply to: How to rebuild columnpicklist

    Mh – what is the purpose of changing the picklist?

  • Andreas Pfeiffer

    Administrator
    April 9, 2024 at 2:47 pm in reply to: js data entry error

    could it be that a variable is missing for a $dataname property?

  • Andreas Pfeiffer

    Administrator
    April 9, 2024 at 12:15 pm in reply to: How to rebuild columnpicklist

    No – I can try to help.

    Actually I do not think it does matter if your list is filled with data in the $construct or due to another event. So if you want the list to have a different content than simply make another load on the list.

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    April 2, 2024 at 6:53 am in reply to: Reading Postgresql schemas and Omnis schemas

    Great,

    Thank you for your feedback. I am glad it helped.

    Best,

    Andreas

  • Andreas Pfeiffer

    Administrator
    April 1, 2024 at 5:05 pm in reply to: Reading Postgresql schemas and Omnis schemas

    Martin,

    it is probably easiest if you try the query build first to see how the correct syntax is and if it works from there.

    Then when using schema classes it is probably best if you use double quotes to describe schema and server table name within the schema class. For example something like “mySchema”.”myServerTable”

    These are double quotes not two single quotes.

    Hope this helps.

    Best,

    Andreas

Page 9 of 20